When was the last time that statistics were updated?

Yeah, it sounds like a name resolution issue. As Roy suggested, check if the two servers are the same domain. If not, you may need to make an alias or...

Lynn Pettis (2/3/2010)

--------------------------------------------------------------------------------

Just thought I'd throw in my two cents. Buying the Developers Edition is well worth the expenditure. Plus, if you look around, you can find it for usually...

I am not sure if this is what you are looking for, but you could try this:

- Load all of the sql scripts into an array

- Connect to the SQL...

There is not a whole lot to go on here. What edition of SQL 2005 is installed on the server? What kind of locks are there when other users cannot...

Have you checked for hardware errors on the server?

Error 8998

I agree with DNA_DBA. From the sounds of the clone process, serverA and serverB were EXACT copies of the parent server with no consideration to issues this can bring up....

Microsoft tends to recommend that you do not install the CUs unless you have a specific issue that is addressed by them. I think the reason for this is two-fold....

I agree with Gail. It sounds like SQL is preventing you from renaming the objects because of constrainsts to other tables in the database.

I think the previous replies are great suggestions, but I just want to caveat something. If your intent is to practice to learn SQL commands that you can utilize in...

If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL and starting the...

If your account is an administrator on the machine and Built-in Administrators is in the sysadmin server role, then your account should not have problems accessing SQL

That should work if it is a push subscription, and it will need to be ran at the publisher. If it is a pull subscription, then you will need to...

That is a great point, since SQL 2000 ended support in 2008.

Have you seen this yet?

How to move databases between computers that are running SQL Server