Not that I am aware of. It's a real pain if you are using the MS logshipping and have to set it up again....

I don't see any inherent problems in your proc, I would get rid of the BEGIN and END unless you are using them in some logic not posted. Double check...

The question is a little confusing, do you have a stored proc that is using a temp table, or are you trying to pull data from a seperate temp table...

I have definately come across this in Windows 2003, earlier versions I am not sure about, logic dictates that this would be the case however.

Did the file already exist before the execution of the package today? If so the creation date will remain as it was originally. When it comes to changes you need...

You would execute it as you would from a dos prompt, just within the xp_cmdshell parameters.

exec master..xp_cmdshell 'c:\folder\runthisfile.bat'

Also check that you have sufficient permissions to be able to read those entries from the regsitry using your login, and make sure that no new group policies were put...

I've run with a setup that had the workhorse server sitting on it's own vlan behind a firewall. Data is replicated from this server out to a couple of SQL servers...

I'm running an active/active Win2k3 SQL cluster and have had no problems with SQL running under sp3a.

Never used geocluster software however.

One thing that I've found especially useful for moving db's back to QA is to keep the logins the same. You don't mention it in the article, but there might...

This works...

declare @ch varchar(10)

set @ch = '23.467'

select convert(real, @ch)

Have you looked at other queries that are running when executing your proc that could account for variations in run times?

Also if SQL is running under a domain account it allows you to go out and screw with stuff all over the place...lotsa fun to be had by all

Temporary tables are stored in tempdb, so you would reference it as TempDB..#shipmentsB

I don't have one, so can't really answer this, but I will say that I have seen a vast number of MCDBA's in the last couple of years, and they...