Viewing 15 posts - 37,306 through 37,320 (of 39,456 total)
Boot the Maintenance plan?
Don't like these are I have had similar issues (not this though) and no error messages.
There are quite a few scripts in the librar that duplicate this...
June 24, 2002 at 10:11 am
I thought 7 included the deubgger as well. Perhaps not.
I have used Sylvan-Faust's tool as well as the regular one. Pain in the A** to get the DCOM working...
June 24, 2002 at 10:09 am
synched with the server. We have determined (Another thread) that this takes some time when the system time is changed, so I suspect that the SQL Server "checks" the system...
June 24, 2002 at 10:07 am
One more comment here. I just got a new job, which required MCSE2000 or MCDBA. At least in the requirements listed. I got the job, but I do have to...
June 24, 2002 at 10:05 am
Use Andy's suggestion. Do not give out sa rights except as a test, and then immediately revoke them.
Steve Jones
June 24, 2002 at 10:00 am
Not pretty, but I'd create several stored procedures to handle the cases. Then use a master stored procedure to accept the parameters and then "call" the appropriate sp(s) for that...
June 24, 2002 at 9:59 am
count(*) usually pulls the count from sysindexes. There were problems with this being accurate in SQL 65 (possible 70). I think in 2000, this is accurate.
Steve Jones
June 24, 2002 at 9:55 am
Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?
Steve Jones
June 24, 2002 at 9:53 am
Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?
Steve Jones
June 24, 2002 at 9:53 am
If the log file doesn't shrink (after following both posts above), there is a script in the library here that will help.
Steve Jones
June 24, 2002 at 9:42 am
Can you connect via isql? Or Query Analyzer?
EM uses more than one connection and if you are single user mode, you cannot use this.
Steve Jones
June 24, 2002 at 9:40 am
June 24, 2002 at 9:33 am
And please follow up here. I (and others) are curious to find out what is happening.
Steve Jones
June 24, 2002 at 9:31 am
I agree a log would be the outage window, but keep in mind if you are out for longer than the window for a transaction log, you will need to...
June 24, 2002 at 9:28 am
Clustered index stores the data in the order of the index (physically). Nice for columns used in range queries (like dates). Only one per table as you can only store...
June 21, 2002 at 12:52 pm
Viewing 15 posts - 37,306 through 37,320 (of 39,456 total)