Not seen it personally. Maybe try copying the DLL from another machine?

To create a login, you will need to have the "Alter any Login" permission granted to it. Either that or make the login a member of the securityadmin fixed...

You can use profiler. Just kick it off and look for what process is doing what at 3am.

Either that or sit up and run a sp_who2 just before the...

Hi Steve,

Part of it is required. We may need to restore a client database as part of an upgrade process or we may need a fresh copy of a...

Yes...I do. I perform at least one full restore per week.

Huh? Reinstalling SQL Server is an option for a process which is taking a long time to roll back?

Great article Gail. I'll be sure to forward this on to a DBA who I know has had a few corrupt database issues.

BIDocumentor is not bad either.

Either way, you'll still need to document functionality.

I wouldn't mind seeing that stored proc you wrote Steve.

ananda.murugesan (2/12/2009)

what is the use check point in SQL sever database?

How to set a check point in SQL Server?

which condition and what are steps should followed for attempt check...

As I suggested, if you have Visio or something similar, reverse engineer the schema so you can get a visible feel for the database and its relationships. This was...

I think most of us will believe it!

I agree. It makes no sense and I strongly disagree that any money given by the governments should be used for bonus handouts. This should have been a...

A first step would be to get a tool like Visio and reverse engineer to database so you can see the entire (or subset, depending on which tables you select)...

Just one thing to bear in mind is that some stored procedures may not run frequently if you do delete any, make sure you have a copy.

You'd not want to...

Hi,

Tempdb - No. It gets re-created when you start the SQL Server service anyways.

Model - You only need to move this database if you have made any customization to...