There are many T-sql scripts available online to do the same.

http://www.sql-server-performance.com/articles/dba/job_report_p1.aspx

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/

just to start with a few.

No there will be no problem, infact it is advisable to do so, even with Databae logs.

only if you are on SAN with RAID 10 will it really make a...

check this out:

http://www.sqlservercentral.com/articles/Administration/longrunningjobs/1897/

and

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1302809,00.html

looks fine.

Also check to see on the SQL instance that the user is shown with proper kerberos auth in sys.sm_exec_connections.

There coule be a SPN issue here:

Check this out for Quick answer: http://blogs.msdn.com/darwin/archive/2005/10/19/482593.aspx

select * from sys.dm_exec_sessions

select * from sys.dm_exec_requests

select * from sys.dm_exec_connections

you can join these 3 to filter more info, but connections and sessions should retuen you whats needed.

Or sysprocesses.

Best definition will be here:

http://sharepoint.microsoft.com/Pages/Default.aspx

Do you mean , you are updating the value directly in the system tables. if yes: this is not advisable and should be dne through the Job properties only. as...

Does this user own to db_owner schema. according to your text, it sounds it does...

you will have to transfer the db_owber/dbo to some other user and then the user can...

you should be able to create a new column and make it identity and primary key:

Question: will this default your existing primary key column and uniqueness..

ALTER TABLE ABC

ADD NEWCOL int...

Personal Advice: Take a Chain saw and you know what to do:

Now Serious: Cant you get rid of any historically records/data into a seprate database.

or you can create multiple...

Or this:

Almost the same as above Query, but this will give you the column names as UPPER CASE in the result set:

select 'sp_rename @objname='+''''+Table_name+'.'+column_name+''''+', @newname= '+upper(''''+column_name+'''')+',@objType='+''''+'COLUMN'+''''

from information_schema.columns

http://support.microsoft.com/?id=955706

http://msdn.microsoft.com/en-us/sqlserver/bb895958.aspx

and CU=Cumulative Updates

As i dont know the complete details as yet but here is a attempt:

Was this workiing ok before this:

did you move the databases over to new server Or did you...

I see you aare at SP2.

you can try applying any CU. or SP3 there are many resolved issues available after SP2.

read through the issue List before making the attempt.