Probably not. How much memory do you have on the server? SQL Server is designed to 'claim' almost every bit of memory. At its default, I believe it...

I have seen this also and used the solution Carl suggests. Just run DBCC UPDATEUSAGE ('dbname')

-SQLBill

Not necessarily. I suggest you run the rollback commands manually.

-SQLBill

Right now, apply SP3a to the linked server. Now. There are lots of security issues with SP1 & 2 for SQL Server 2000. That might also solve your linked...

If you are replicating, you can't shrink the subscriber database. Only the publication database can be shrunk and then the shrink is replicated to the subscriber(s).

-SQLBill

I do not work for RedGate, Quest, ApexSolutions, or SQLServerCentral.com. I am a SQL Server DBA for a major U.S. Airline.

I saw Bob Boule's post (one of the many)...

Please don't cross post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=347556#bm347580

-SQLBill

It looks like the ODBC connection or whatever you are using to make the connection is trying to use the Windows Login. Somewhere the ODBC connection should have the...

I just read the part about being out of space and can't backup the log file.

Okay, I'm assuming this, but would bet I'm right. Your database is set for Full...

First things first....

1. what recovery mode is your database set for? Use Enterprise Manager, right click on the database, select properties, go to the options tab.

If it is set...

What do you mean it doesn't update the transaction log?

-SQLBill

Microsoft has a stored procedure that copies logins. Go to their SQL Server website and query move logins.

-SQLBill

Look up CREATE FUNCTION in the Microsoft SQL Server Books OnLine (BOL).

And please don't cross post the same question.

-SQLBill

GOOD ADVICE:

Before you remove Builtin\Administrator, create a SQL Server authenication login for yourself. Make its default database Master and give it System Administrator role.

That way you can ensure you will...

Run the script in query analyzer. WHen you get the error message, right click on the error and it will highlight the line in your code where it believes the...