Viewing 15 posts - 5,326 through 5,340 (of 6,676 total)
Can you access the D drive on the server? Can you navigate to the folder where the mdf/ndf/ldf files exist and verify that they do in fact exist?
I have...
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 21, 2009 at 10:09 am
I am happy that you got it working - thanks for the feedback.
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 21, 2009 at 9:09 am
Based upon your sample data - you don't have a primary key. The examples given here don't include a primary key definition.
For either solution to work - you need...
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 20, 2009 at 9:45 pm
Lynn Pettis (4/8/2009)
Goldie Graber (4/8/2009)
For example if I use the following data, I still expect 1 as the answer but...
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 20, 2009 at 8:22 pm
FlyFish-N-Lady (4/20/2009)
I...
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 20, 2009 at 5:11 pm
That procedure, by itself - is not the problem. That procedure executes a sql command that is dynamically built.
You can look in books online to get more information on...
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 20, 2009 at 4:37 pm
When you installed SQL Server, did you change from Windows Authentication only to both SQL and Windows authentication?
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 20, 2009 at 3:59 pm
The recommendation is generally anything with less than 1000 pages doesn't need to be rebuilt/reorganized. Of course, you are going to need to test that in your own environment.
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
April 20, 2009 at 3:45 pm
I am just curious, but why would someone need to drop a work-table on a regular basis?
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 20, 2009 at 3:25 pm
You want to look at the new syntax to alter an index:
ALTER INDEX index ON table DISABLE;
You can use sys.indexes, sys.tables and sys.partitions to identify the appropriate indexes to disable...
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 20, 2009 at 1:53 pm
That makes sense - since, as a sysadmin the default schema is overwritten to 'dbo'. SQL Server checks the default schema (now dbo because of sysadmin), then checks 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
April 20, 2009 at 12:01 pm
Thanks for the feedback - I hope that was the problem and that it is now fixed.
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 20, 2009 at 11:50 am
As was asked earlier - why do you need to rollback? Are you having a specific issue that SP3 broke?
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 20, 2009 at 11:49 am
Did you add a BEGIN TRANSACTION somewhere?
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 20, 2009 at 10:52 am
Maybe a group policy for that server is causing the problem?
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 20, 2009 at 10:39 am
Viewing 15 posts - 5,326 through 5,340 (of 6,676 total)