Interesting. I've run into the issue with single NIC/single IP, but NT auth works with named pipes. However since it's disabled with most servers (sockets only), it was blind luck...

Not that we're the most dilligent, but we don't have any real information about anyone on this site (no SSNs, credit cards, etc). Any billing we do for http://www.sqlserverstandard.com is...

Thanks. Glad that after a year or so, this stuff still applies.

Can you post the code? What does the proc do? This is usually when a connection cannot find the server. Are you sure you have a connection at this point?

If you login as the SQL Server Agent account and run EM, does it still run? It's a connection problem of some sort. It's like the source server isn't running...

Wow, you're asking a tough one. Not sure how much there is on the web. Swynk used to have some stuff, might search there (it's not dbjournal or something).

I do...

Yes and no. Some sites want to hold the copyright. We don't. Not sure about SSWUG. We do ask that you do not submit anywhere else for 90days if you...

Are you looking for a "row number" type thing?

http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

Andy Warren, Brian Knight, and Steve Jones run this site. Steve Wynkoop runs sswug. We know each other, but that's it.

sswug is an aggregator of content for the most...

Run profiler and see exactly what is happening. Also perf mon to be sure that SQL has enough memory, CPU not stacked, etc. Brian Kelley has a great performance tuning...

Use the same technique as this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=107483

More about it here:

http://www.sqlservercentral.com/columnists/sjones/batching.asp

CASE statement,

sorry

you can also use WITH NO_LOG

Why do you need this functionality? I've got a package that checks the backup path and if it doesn't exist, creates it.

select @cmd = 'exec master..xp_cmdshell ''if not exist '...

Never tried this and not sure it will work. Typically I've opened and resaved each on the new server. Or exported to flat file (.dts) and then imported.