The company I work for was bought out so both of our companies are going through an analysis phase of consoldiation. We have more SQL Servers and databases here...

This is what I use to gen out a list and then run it in the new SQL Server. However, it only works in SQL 2000. I have...

If your DTS packages are not just simple some of them will NOT upgrade to SQL 2008. That would be the very first thing to check to make sure...

I have encountered the I/Os taking longer than 15 seconds problem. If it is like our problem this is not a SQL Server issue. It has something to...

Problem is we have a lot of purchased apps that REQUIRE to install you use the sa login to install it. In that install process it will create the...

One one SQL Server there is four gig of memory in the server and it is 32 bit SQL Server 2000 so it can only take two gig.

The other two...

Thanks to all that replied. In a turn of events the powers at be have changed their minds and are making me go with a Win2003/SQL 2005 SP3 cluster...

I would agree memory is probably not going to help that much. You will need to dig in further and look at the problem SQL statements and see if...

Thanks to both of you. I am starting to see that a cluster in 2008 is more involved than in SQL 2000 version.

I have a few scheduled prod db backups, xcopy to test server and restore automated. Basically I manually coded the db backup.. backup database xyx to disk= 'e:bcksql\xyz.bak'. ...

Yep. However, the VP here is comparing what we have purchased and what we have installed and he states if we get audited the question is PROVE it... then......

I just found in Control Panel, SQL Server licenses it shows it there.

Thanks.

That is exactly what I feared. SQL 2005 does not keep track of this. Only SQL 2000. Thanks!

We are attempting to make sure we are in compliance and it appears our 'test' SQL Server licenses were purchase as CAL base but installed as two CPU's. My...

I agree. SQL 2000 and 2005 also put stuff on the C drive eventhough you change the defaults on the install. Very misleading. Everytime I install a SP...