My opinion is that it will be beneficial to have a "procedural language" available to perform functions that TSQL is not as adept at.  That is available today on the...

These are the correct steps...

1.  Press the green button

2.  Restore from backup

3.  Analyze

4.  Repeat

And I have had great success using BLAT http://www.blat.net/ called from xp_cmdshell in environments where sqlmail is inappropriate.

jg

Hello,

This approach should work, but you might want to consider using T-SQL for steps 4 and 5 combined.  I'm not sure what the advantage would be in using VBS to...

103 is an example of an optional parameter that can be passed to the convert function.  For more information, see the BOL.

jg

Hello,

The SQL agent will also support batch separators (GO) in the T-SQL type of job step.

JG

I guess it is no time for me to quit my day job to become a comedian.

I think the *easiest* way is to script the jobs and run the script on the target server.

Now there is a gotcha with this method.  If any of your job...

If it takes and extra hour to generate the calling list, maybe I can get through dinner without having the phone ring...

 hehehehe

Darn it.  I forgot the Irony tags in my post.

My bad....

For me (slow typist), #tables are faster, because I can select * into them without declaring the columns.

:oP

Hello,

It is a longshot, but you may be able to recover the deleted file using a disk recovery tool.  If none of the physical disk 'blocks' have been reused since...

Or we could say:

"Almost everything almost always depends."

       -- jgray  20050629 

Aslo make sure that you use a valid share name:  '\\1.2.3.4\c:\xxxxxxxx' is not going to work, because the ':' is invalid.

If you mean the drive root, then you might connect...

WHBT!