Are you issuing a SELECT statement in the stored procedure against the temporary table? Or are you just creating the temporary table and then having the ASP code reference it?

I guess it was. We discovered it only a few months ago ourselves. Even with the article, I had to do some testing to prove that what the article said...

You can nest DATEPART comparisons. For instance, look at the hours, then the minutes, then the seconds.

This is a known bug. Though the CmdExec job step is actually running with the account set for the service, it is being misreported. It's documented here:

November 30, 2005 at 7:12 am

#606717

Do you mean at the OS level?

Excellent review, Jeremy. I would have to agree on attempting to use it on production databases with the other posters (albeit with caution). If source control works the way it...

You can certainly remove the shortcut from the Start menu. Also, you could remove the files from wherever BOL installed. The default is the C:\Program Files\Microsoft SQL Server\80\Tools\Books directory. Keep...

True, but a justification can be made that Books Online can be accessed, even in IE enhanced security mode on Windows Server 2003 by dropping msdn.microsoft.com in as an approved...

Ultimately this is a business decision your organization is going to have to make. It's not hard to modify the stored procedure and have it refer to a second stored...

When you're able to upgrade to SQL Server 2005, you'll find you can get granular with the permissions and create the mix that you want. Ability to create a login,...

Check the event logs in Windows. The application and system event logs may give you an idea of why SQL Server went down if it wasn't a person doing it....

It's not a documentation thing... it's the fact that Books Online uses Windows Help and is a known target... typically in a certain location (default of C:\Program Files\Microsoft SQL Server\80\Tools\Books...

We're also heavily using SQL Server on VM in non-production. We've gone with ESX Server. It's substantially more efficient than GSX Server on Windows based on how it's architected (as...

Take a look at:

SSC.com Article: Oracle Link by Adrian Small

He worked through the errors he was receiving making a linked server connection to Oracle and that error you cite...

Write a select statement pulling back the metadata to do most of the work for you and execute it in QA:

SELECT COLUMN_NAME + '1,
' FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = '<Your table...