Check out this article:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;224071

It will give you steps for moving user as well system databases.

The best way to make sure SQL server always has enough memory, is to cap "maximum server memory" and also use "minimum server memory" setting and make sure both values...

To make use of memory more than 4 Gigs you MUST enable AWE in SQL Server and use /PAE switch in the boot.ini

But, this may or may not solve you...

Check the versions of sqloledb.dll and sqloledb.rll files, if they don't match replcae them with proper versions.

Also, make sure that you have enough permissions on both these files.

Try to look for any 17883 errors in the sql error log, if you do , try applying sp4.

If this doesn't help you need to call Sql support.

Try this :

ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE

This should put you in single mode, provided that you have sysadmin access. Please keep in mind this will only work...

I would like to hear more,

cause' I am from one of those "low-wage" locations.

Regards.

Yes a Primary Key can indeed be made so that it is not a clustered index. You will have to specify it while creating the key.

If you are using EM...

Hi Bharat,

It seems that your database log is not really full, since it is in SIMPLE recovery model, log will be truncated frequently and SQL SERVER won't let it get "TOO...

Hi Xavier,

This is a simple problem. All you have to do is change from windows NT authentication to mixed mode authentication. To do this, Go to EM, righclick on your...

You are in soup, aren't you ?

If you are lucky enough you should have log backups, and as mentioned above you will be able to get things back.

If you don't have...

I do agree with brian. All of us "Production DBAs" will have to move withe cheese

Check this out:

http://www.sqldts.com/?204

Regards

Hi,

Before shrinking use

BACKUP LOG WITH TRUNCATE_ONLY

and then do

DBCC SHRINKFILE(2)

(I am assuming that you have only one log file)

This should work.

Regards.

Just login using the Windows NT authentication. Change the Sa password. And this time keep it safe