Can be either one, but typically it's an admin that has rights to do this, not necessarily the DBA.

MCSE isn't a job, it's a certification, by the way.

You can use CPU time, but if you're looking for overall time, you need duration.

I like George's first suggestion. Go in chunks, use shrinkfile.

Also, you should not be shrinking the log regularly. If they need that much space, then they need it. Log shipping results in regular log backups, that allow space to...

If you need to restore a database from 2005 to 2000, no matter what the compatability, you can only script out objects and permissions, and run that on 2000. There...

I'm not sure there's a reason to pick one over the other for simple tests, but as you get into queries, testing for equality can be more efficient. People often...

Usually there are some ports that are "listening", look for those.

SQL Server prints this in the error log as well when it starts, so you can always check there. The...

Wayne,

Sorry, I need to update the IFCode, and I'll do that tomorrow. The code formatting has been a challenge, and it's confusing to everyone. I wish there were a better...

Look up attach in Books Online. you can re-attach the data files.

However that won't get you logins.

What was the problem originally, and what did you do?

What about DBA's Delight?

That's the modern holiday, fireworks. Even reading the Declaration of Independence last year with my son didn't register with him.

I think it's a great day in the US, and there...

I don't know, but I'll ping a few people tomorrow.

The site was founded in the US, and we're still > 70% US members, so we do some fun questions for holidays here. Outside of the US, feel free to...

No, don't do that. The system expects two log files. Attach both, then try to use SSMS to remove the 2nd one. IF it doesn't work, try a shrinkfile to...

Shared logins might be hard to get to work, and I'm not sure how we could get permission from people to use them.

We try not to link to places that...