Viewing 15 posts - 286 through 300 (of 306 total)
A more important question might be - why am I timing out, have you asked the resident DBA, have you tried the same query from a remote query analyzer, did...
November 4, 2002 at 12:14 pm
Thanks Antares686,
But I want to make sure that 'Session idle timeout over, tearing down the session.' informational message is occuring by design and NOT occuring needlessly.
The message is...
November 4, 2002 at 10:10 am
Thanks Antares686,
But I want to make sure that 'Session idle timeout over, tearing down the session.' informational message is occuring by design and NOT occuring needlessly.
The message is...
November 4, 2002 at 10:09 am
Very coool, I'll have to add that to my bag of tricks.
Good Luck
Zach
John Zacharkan
November 1, 2002 at 2:29 pm
Session idle timeout over, tearing down the session.
I see this in my event viewer regulary, several times a day. Is this not normal when dtc is not in use? If...
November 1, 2002 at 9:45 am
Not sure if this will help but you can move a DTS package outside of the GUI by modifying the code you'll find here to only select the desire package.
November 1, 2002 at 8:56 am
or just change this code:
/*
** Set @mspertick. This is just used to make the numbers easier to handle
** and avoid overflow.
*/
select @mspertick = convert(int, @@timeticks / 1000.0)
to...
October 31, 2002 at 2:49 pm
What version of SQL Server are you using?
In 7.0 you need a place to start from and you don't have that. I know of know way to restore back...
October 30, 2002 at 9:08 am
dbcc checkdb ran fine on all user and system databases, except for this one user db. I also subsequently had found that all database and transaction log backups for this...
October 30, 2002 at 7:21 am
I think I found my answer, Copying DTS Packages To a Different Server Posted: 03/19/2002 by you Andy
I'll give it a shot, hope it works in 7.
Zach
John Zacharkan
October 25, 2002 at 1:17 pm
Nice to hear from you Andy.
Is there script for copying over the DTS packages and jobs? I usually just open a package and save it to another server. If...
October 25, 2002 at 12:27 pm
Looks like you're talking about setting the sp_dbcmptlevel
Any reason why the upgrade did not set this to 7.0? Does not upgrading the master database have anything to do with...
November 6, 2001 at 8:35 am
quote:
Im not sure Im for using log shipping as a way to CYA in case of a bad data load.
October 19, 2001 at 12:47 pm
First off I would like to thank all of you for your opinions and incite. I especially like the idea of having the logs shipped but not applied to the...
October 19, 2001 at 9:36 am
quote:
Actually, the "Service startup account" area is greyed out now. I can't change it to anything.
October 17, 2001 at 10:31 am
Viewing 15 posts - 286 through 300 (of 306 total)