Very interesting. What frequency to you roboot your box. I'm going to have to go back and look to determine when was the last time these boxes where...

You might consider using the undocumented extended SP "xp_readerrorlog" for reading the ERRORLOG file.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I think ISS reads the ERRORLOG file looking for "Login succeeded for user" messages to keep track of the last time a user logged in. Anyone could just do...

Might try something like this:

create table week_day([Date] datetime,

Id...

I think you can use the WSCRIPT SHELL object to do asynchronous processing of SP's. Here is a simple example to demonstrate what I am talking about. This example creates...

Here is two different ways to do that.

create table test(Name varchar(10))

insert into test values('Bill')

insert into test values('Tom')

insert into test values('Dick')

insert into test values('Harry')

insert into test values('Greg')

insert into test...

I would use sp_help_revlogin. Here is a KB about that sp.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

you will need to configure sql agent mail to accomplish this. Check out KB article 263556.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

One option would be to execute the stored procedure via OSQL and then use the -o option to output the results to a file.

You can also get the output into...

After a little thought I think you can use the WSCRIPT SHELL object to do asynchronous processing of SP's. Here is a simple example to demonstrate what I am...

Thanks for the reply. Already knew about the SQLAuditor tool. Was hoping to see if there might be others out there on the market. Does anyone else have...

Have not played with this much, but I think for the jobs you can make them owners of the jobs. By doing this they should then be able...

I agree the best answer would have been UPDLOCK, but that was not an option. Since B only specified a UPDATE locking hint, it was incorrect, since there is...

You need to make sure that both the right and the left are using the some collation when comparing. Here is an example that works, because the column on...

try this:

create table t(x int,d int)

insert into t(x) values(1)

insert into t(x) values(2)

insert into t(x) values(3)

insert into t(x) values(4)

select * from t

declare @x int

set @x = 0

update t

set d=@x,@x=@x+1

select...