That is possible that the firewall needs to be changed. SQL Server communicates on 1433 and 1434, so you might need them opened. Are you accessing the SQL server on...

I've had strange jobs like this as well. Some type of bug is all I can figure. There is a "run once" option, so be sure that isn't checked.

Other than...

Very good, there are two functions suser_name() and suser_sname() that return different values. Both are affected in SQL2K by Setuser.

Do you have any additional extended stored procedures or other software on your sql server? If you don't and can't isolate to a particular process, you need to call Microsoft...

I hope you're not really using XP, that's a big problem right there.

I definitely get values for these columns. I'd suspect something is wrong...

There might be one in the script library, but what you're asking for is a role. That's why roles exist and why you should use them.

http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp

I'm not sure you can tell on the 10sec mark, but you could setup a 2nd job to run and check the output from sp_help_job for your specific job having...

Depends on what you want. I've tended to include the used and free amounts and a change from the previous day so  I can see if things are growing abnormally.

what's...

If you don't need password recovery, there is an encrypt() function that does a one way encryption.

There isn't a way. however you can generate a script to do this automatically.

declare mycurs cursor for

select name from sysobjects

 where type = 'p'

 and name not like 'dt%'

declare @nm varchar(50)

 , @cmd...

They shouldn't be sa. Since I assume you will refresh QA fairly often, give the developers db_owner in the dev database, and when you refresh QA, have a script that...

There is no integration with EM. The only way I've been able to do this is remove rights from the dev server and designate someone to make changes. This way...

Not sure what you mean. What's "BIG" and "One Day"? Can you provide some actual dates with examples? I suspect you want to use a CASE statement, just not sure...

I usually grab the sp completed, and stmt ending events, check the duration and do a count of the instances and go from there. I think the standard template that...

glad I could help. When you see something strange like this with an index, constriant, etc. Often it's bound to another object.