Viewing 15 posts - 5,851 through 5,865 (of 6,676 total)
First, let's verify what version of SQL Server you installed. Should be either Developer or Express - and if it is the Express version then you will need 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
December 11, 2008 at 5:36 pm
At this point, I really could not say how to troubleshoot this problem. It appears (to me) that the DMI database does not reside in that instance of SQL...
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
December 11, 2008 at 5:29 pm
I see no references to the DMI database - either starting up or shutting down. That would tell me that the database does not exist in that instance. ...
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
December 11, 2008 at 3:36 pm
The section of the log that you have provided appears to be from when the service was shutdown (prior to the failover).
We would need to see the section of 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
December 11, 2008 at 2:21 pm
Hint:
SELECT 333/334
,333.0/334.0;
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
December 11, 2008 at 2:15 pm
I would bet anything that the instance name that you connected to when you setup your DSN was .\SQLEXPRESS and not just SQLEXPRESS.
In your attempt to connect using MS jdbc...
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
December 11, 2008 at 1:19 pm
On the reindex task - what is the setting you put for 'Change free space per page percentage 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
December 11, 2008 at 1:06 pm
Lynn Pettis (12/10/2008)
I have been in and walked away from 7 major accidents (2 motorcycle, 4 car, 1 auto/pedestrian {the one I just told you about}) and several minor accidents.
Wow...
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
December 10, 2008 at 7:55 pm
pat (12/10/2008)
so will it beselect CONVERT ( smalldatetime , start_date , 101 ) from table
No, you need to convert to a string datatype (char, nchar, varchar, nvarchar). Since...
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
December 10, 2008 at 7:32 pm
Jeff Moden (12/10/2008)
Garadin (12/10/2008)
(I know I know, it makes it easier to comment out lines and such, but I still hate it)
I do...
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
December 10, 2008 at 7:22 pm
Patricia Monreal (12/10/2008)
Jeffrey,I made the changes you suggested and tested the report - it works perfectly!. Thanks so much.
Pat
Hi Pat - thanks for the feedback. Glad this worked well...
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
December 10, 2008 at 4:46 pm
Jerry - that is definitely interesting. Did not know that it was introduced sometime after SP1.
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
December 10, 2008 at 11:41 am
I will give you a couple of hints:
1) You need to JOIN the table in your query
2) You will need to use a CASE expression to return 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
December 10, 2008 at 11:37 am
Check the ARITHABORT setting on each server/database. I bet on the one that is failing - this setting is 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
December 10, 2008 at 11:30 am
SQL Server 2000 Standard Edition can only use a maximum of 2GB of memory (or 3GB if you enable the /3GB switch in the boot.ini).
No matter what - that is...
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
December 10, 2008 at 10:50 am
Viewing 15 posts - 5,851 through 5,865 (of 6,676 total)