Viewing 15 posts - 5,401 through 5,415 (of 6,676 total)
That was where I was heading - but needed to see the error message.
The problem usually does not show up with a connection (login) problem. Usually it shows up...
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
April 14, 2009 at 12:38 pm
Grant Fritchey (4/14/2009)
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
April 14, 2009 at 12:34 pm
Are you getting an error?
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
April 14, 2009 at 12:29 pm
If you are seeing processes block themselves, you need to review what type of waits you are encountering. My guess would be that they are CXPACKET waits - which...
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
April 14, 2009 at 12:29 pm
How are you determining that the error logs are not rotating? Issue that command does not create new files, it rotates the files so that errorlog.1 is renamed 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
April 14, 2009 at 12:09 pm
I have another question - how do you connect to the client's server? Do you connect using an IP address or the name? If you use IP address,...
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
April 14, 2009 at 12:00 pm
I believe the GUI tools require a higher privilege than just ddl_admin. Basically, this privilege allows the user to issue the DDL statements, but does not allow usage of...
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
April 14, 2009 at 11:11 am
Are you using Windows Authentication to connect to SQL Server? When you connect to the server, are you using a client specific domain account?
If so, then you will not...
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
April 14, 2009 at 11:06 am
Yes - it is Activity Monitor that is generating that statement. The question really would be why is this showing up in the logs? Generally, things like this...
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
April 14, 2009 at 10:49 am
You are welcome - I remembered the conversation and then it was just a matter of searching for a question that was posted by Jeff Moden. Since that particular...
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
April 13, 2009 at 6:20 pm
The problem is going to be which row do you want to use to order the columns? And then what happens when you add a region, or additional funds?
If...
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
April 13, 2009 at 5:43 pm
Here is a previous discussion that shows how to do multiple aggregations in a single pivot. We went back and forth on the various forms of pivot/cross-tab and which...
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
April 13, 2009 at 3:36 pm
Great - it sounds like you now have things under control and should be able to shrink the transaction log.
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
April 13, 2009 at 12:00 pm
The server you are running is 2000 - you can modify the agent jobs as needed. You should look at upgrading to SQL Server 2008, but that really depends...
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
April 13, 2009 at 11:59 am
Can you run SELECT @@VERSION to verify?
Or, look to the right of the server name and verify the server you are connected to has a version of 9.0.xxxx or greater...
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
April 13, 2009 at 11:49 am
Viewing 15 posts - 5,401 through 5,415 (of 6,676 total)