Viewing 15 posts - 7,036 through 7,050 (of 7,187 total)
What is error 322? If it doesn't exist then you won't be able to generate it...
John
June 21, 2006 at 3:12 am
I don't know what you mean when you say you can't regenerate the event IDs. Are errors 322 and 17052 user-defined? I can't find them in Books Online.
John
June 20, 2006 at 7:31 am
Different names for the same thing. If you go to Enterprise Manager and "delete" a user, SQL Server actually runs sp_revokedbaccess in the background to accomplish that.
I think your problem...
June 20, 2006 at 1:52 am
Burhan
If you are using SQL Server 2000 and Windows 2000 or 2003, there is an icon in Control Panel called SQL Server 2000 Licensing Setup. I think with Windows NT...
June 20, 2006 at 1:38 am
Yelena
If you save your trace direct to a table then the RowNumber column will be there automatically for you.
John
June 20, 2006 at 1:29 am
Rob
Use the dtsrun utility. You'll find the syntax in Books Online. You may decide to bundle all the DTS packages into one so that your accountants only have to press...
June 19, 2006 at 9:13 am
Burhan
Go to Control Panel and open SQL Server 2000 Licensing Setup. This will display the licensing mode and quantity you have currently, and allow you to make changes.
John
June 19, 2006 at 9:09 am
OK, I've read your original post a bit more thoroughly now. You're wondering whether the guest user has been deleted. We always delete it from our user databases, and even...
June 19, 2006 at 2:22 am
Yelena
To sort chronologically, use the RowNumber column. This is incremented for each event, including logins and logouts, as they happen (at least that appears to be the case in my...
June 19, 2006 at 2:10 am
Steve
It's not clear what you're asking. It sounds as if you've renamed a file or folder and now you can't get a particular service to start? Is that right? If...
June 16, 2006 at 9:05 am
This is just a shot in the dark, but are any of the objects in the source database owned by my_user? Then, when it tries to create them at the...
June 16, 2006 at 9:01 am
Are you saying that the snapshot completes successfully but then replication stops after three hours?
If you are saying that, is it exactly three hours every time? Have you checked the...
June 16, 2006 at 8:44 am
If you're looking for point-in-time, save your trace to a table called TraceTable and run this:
declare @PointInTime datetime
select @PointInTime = 'June 16 2006 10:55:49.890 AM'
if @PointInTime < (select...
June 16, 2006 at 5:05 am
Yelena
Are you looking for the maximum number of concurrent connections during a period, or the number of concurrent connections at a specified point in time?
John
June 16, 2006 at 2:47 am
Erde
Is it possible that when you hit 2090000 rows, your data or log file fills up and has to autogrow? If it is set to grow by small increments then...
June 16, 2006 at 2:30 am
Viewing 15 posts - 7,036 through 7,050 (of 7,187 total)