It is my understanding that there are no 64 bit Enterprise Manager nor do you have the ability to save DTS packages in 64 bit. You must access them via...

Curiosity question. Why would you want to create a synonym name for employee as emp ..... why cant you just use the three part name ?

I believe you can run 32 bit SQL on 64 Bit WIndows 03 without any problems. I would think you will not see a performance decrease but you will not...

That is what I thought... It is an install of SQL Server parameter.... I 'think' this can be database specific in SQL 2000... not sure though... I know I would...

I have went from SP3 to SP4 on one Prod server. No problems reported. I now have two new installs running SP4, no problems yet either.

A couple of months ago during some construction on our building a painter hit the emergency kill power switch for our entire data center. The phone system, the mainframe, 300+...

It will be released to the general public on November 7 2005. Do NOT deploy the Beta version, you will not be supported by Microsoft nor is this a 100%...

My two cents:

I know here we have it somewhat good. All of IT puts in tons of hours and it seems like new projects never end and old...

We have a very good UPS, a diesel generator and a good fire suppression system in our data center. Unfortunately our building is going through a major remodeling and two...

Maybe this will help... look at the create date of the tables, sort by date created. Granted, it won't give you the exact date of when the db was created...

We have two production clusters here. I was not a fan of this but I was told we would do it to guard against hardware failure. The first one we...

Thanks for your replies. I took your SQL and modified it a tad and it gives me the date and time it came up... Probably not the cleanest but it...

  I agree with everything you said. I installed it on a Win2K test server and it looked and acted just like SP3. I did notice in the readme file...

We have AV on ALL of our SQL Servers without any problems. A few are WIn2003 as well. I simply exclude the *.MDF *.LDF, *.NDF sql server data files.

I ran into this once. In doing some research when our server group installed our server backup software (TSM/Tivoli) they activated the SQL Server backup plugin so it was backing...