How can I register new SQL server by name?

I got some problem when I try to register new SQL Server. It cannot connected by server name. However, if I connect it by IP Address it can. How can I register new SQL server to Enterprise Manager by name?In Client Network Utility, add name as an alias for that IP address using TCP/IP...|||Thank You.

How can I launch a report without generating it automatically?

I am accessing a report in IE by typing the following link in the address field:

http://localhost/ReportServer/Pages/ReportViewer.aspx?/Reports/TheNameOfMyReport

When the page is loaded, the report is generated automatically because all report parameters have default values.

How can I modify my report so that it is not automatically generated? I would like to wait until the user clicks on "View Report" before rendering the report.

As a temporary solution, I removed the default value of one report parameter but I would like to get it to work even if I leave all default values in.

I have seen sites where they describe a list of extra parameters you can include in the url to modify the behavior of the report like:

&rs:Command=Render

&rs:Format=Excel

&rc:NoHeader=true ...

but I haven't seen anything to tell the reporting engine not to render a report.

Any help would be appreciated, thx.

Is this not possible. I am also looking forward to a way to do the same?|||This appears to be only possible with your workaround above or by using the Reportviewer control in Visual Studio.

How can I grab a notification email address from a job?

Is there a handy-dandy way for me to be able, from a stored procedure, to capture the notification email address for a user associated with a job?

I need to send an email out from a stored procedure, and I want it to be set up to send to the same user that is set up in the job that calls the stored procedure.

the same notification stored proc will be used in multiple jobs, but the jobs are already set up with a notification email to be sent to the defined users "on completion" (error or not). I want a separate email to be sent, but I want to use xp_Sendmail because I have to perform a select who's output I want to appear in the body of the email (and unless I am missing something, I have no control over the body of the standard "job completion" email).

I would prefer to NOT have to "hard code" the user email address in the stored proc that calls xp_sendmail, OR to put it in some user table in the database, when the user I want to send it to will always be the same one defined in at the JOB level in Enterprise Manager.

Any thoughts? Thanks in advance for your instantaneous and informative answer-packed responses! ;)I'm shooting from the hip on this, but I'd start with:SELECT j.name, o.email_address
FROM msdb.dbo.sysjobs AS j
LEFT JOIN msdb.dbo.sysoperators AS o
ON (o.id = j.notify_email_operator_id)-PatP|||That's what I was looking for, Oh Great One...

Or something to that effect...I obviously need to get more accustomed to the sys tables...but tried as many ways as I could think of to find a reference to something like that in BOL...but alas, apparently didn't know what to search for *L*

I guess I need to break down and read my SQL200 Unleashed book and learn a little about the architecture that is padding my paycheck *sigh*

As always, thanks for the gentle nudge ;)