how to find out who disabled sql agent jobs?

what do you mean by sqlagent jobs?

Is it about any perticular job or complete sql agent?

Whatever the case check error logs...

"you must resolve any issues with the previous operation that failed"

that is the only assumption I have from this error.

it seems like there was some installation in past which required server reboot and was not done.

I think reboot will resolve this problem.

lot of articles available on BOL for upgrade.

Also if you expecting the integer value to be return then why you creating your @..... as char type?

if its numeric then what do you mean by

Else 'July.F1007'.

not sure but could be the reason.

you can justify by giving the data like :-

1) how important your database performance and role fo tempdb in this.

2) performance comparison by putting the temdb log on another drive...

so whats stopping you to do this....

if account you want in sql then create sql account else windows account and give required permission to that specific account

FROM Sales where Sales.SERVICE = SERVICE.SERVICE or sales.service is null

OR if it different table then

FROM Sales where Sales.SERVICE = SERVICE.SERVICE or SERVICE.service is null

no problem....just bit more explanation with code what I was saying earlier...

in bat file

for /f %%G in (serverlist.txt) do sqlcmd -S %%G -E -i serverversions.sql

or if the...

my personal view.....

first check your database that which are the tables consuming most of the space. google it, you will find the query how to find the tables sort by...

try this:-

select convert(char(8),getdate(),102)

you can delete all the data by comparing to temp table and then as temptable have unique record you can import it back to original table

something like

select * from table...

once you get the serverlist in text file then you can use that to check server version and other details by running query which you will run on any specific...

i am not talking about replication monitor, i said activity monitor where you can see if any process is still running for replication