What ever comes after the CREATE PROCEDURE and before the GO is treated as the text of the stored procedure. This is the same for all the other CREATE ... statements...

As per the ever-friendly, ever-reliable Books Online,

GO

Signals the end of a batch of Transact-SQL statements to the Microsoft® SQL Server™ utilities.

So when you excluded the first GO statement, all the...

Anythings possible, but the real question is, why would you want to??

Can't think of any reason you'd go to all the trouble of calling a batch file when it's much...

Dear Sufian

Are you posting this as a Question of the Day (QOD), or as an actual problem you have?

If its a QOD, you might want to follow the instructions for...

Easiest way is to setup the DTS Package to run in a scheduled job.

Use the DTSRUNUI program to generate the command line for you, this way you won't have an...

Nothing wrong with the question you've asked, just that it doesn't have anything to do with Notification Services! A more appropriate forum would be SQL Server Administration

http://www.sqlservercentral.com/forums/messages.aspx?forumid=5 

The locks that SQL Server acquires are on the base data. Unless you are using indexed views, there is no data in the views to place locks on.

Using NOLOCK...

FWIW.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=196184

Why can't you have a permanent table, its standard practice for loading data?

If you can't have a permanent table then add an ExecuteSQL step at the start to create the...

What has this got to do with the Administration of Notification Services??

Please check the forum you are posting to before clicking submit.

Ok, what are the specific properties on your linked server? I'm not at work at the moment, but I can post our settings on Monday if you think that might...

How about another case.

I've got to send out the same email message to two different addresses

EmailAddressTable
me@here
you@there

MessageTable
The job you wanted done is complete

I've got a procedure called usp_SendTheEmail that...

... and then again there is always SQL Reporting Services

Bryan

My initial thoughts are that you can't get the information you need without creating some sort of connection. You could use a bit of VBScript to query the computer name...

Oh goody, goody another clue ...

I must say this is the...