Viewing 15 posts - 4,126 through 4,140 (of 6,676 total)
First, make sure your client tools have been upgraded to at least the same version level as the server you are accessing. If your client tools are SP2 or...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 17, 2010 at 9:35 am
The update from 9.0.4035 to 9.0.4053 was done through a windows update security patch. You can find more information at: http://support.microsoft.com/kb/970892
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 17, 2010 at 9:32 am
What is the full error you are getting?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 17, 2010 at 8:42 am
GSquared (2/16/2010)
http://support.microsoft.com/kb/919155
DBCC CHECKDB does take a lock on tables. The above is about DBCC itself recording a timeout, but in a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2010 at 3:08 pm
I am not going to say whether or not it is - I am just going to say that you should not even consider it. Shrinking database files will...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2010 at 2:52 pm
Sergei Zarembo (2/16/2010)
1) shrink all databases
Really bad idea to schedule a shrink of the databases every night. Why do this, just so the database can grow the next day,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2010 at 2:32 pm
Sorry - you still have to modify the startup parameters using SQL Configuration Manager. I believe you might have to modify the registry directly to get the changes to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2010 at 2:01 pm
Database files don't automatically shrink when you delete data - that is normal. If you really need to recover the 23MB of space, then you use SHRINKFILE to shrink...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 15, 2010 at 2:08 pm
SQL Iron Chef (2/15/2010)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 15, 2010 at 2:02 pm
Google is your friend, first three items when I searched for that error are:
http://support.microsoft.com/kb/889646
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
http://support.microsoft.com/kb/925744
That should get you started on fixing this issue.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 15, 2010 at 7:03 am
Is the SQL Browser service running?
Are you running SQL Server 2005 Express Edition? If so, is the system it is running on joined to the domain?
When you create a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 14, 2010 at 10:06 am
CirquedeSQLeil (2/13/2010)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 14, 2010 at 9:57 am
What account is running your SQL Server? Is it local system, local service, network service or a domain user?
Getting an access denied error tells us that SQL Server does...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 12, 2010 at 5:14 pm
You are going to have to identify what you mean when you say it doesn't work. The query is fine written the way you have it, however - running...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 12, 2010 at 5:08 pm
This is telling you that the account running SQL Server does not have access to the drive and/or folder. It is a permissions issue and once you correct the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 12, 2010 at 4:32 pm
Viewing 15 posts - 4,126 through 4,140 (of 6,676 total)