You mean you dont have permission, to grant permissions to others?

have your DBA grant sysadmin rights...where and if needed.

to continue with what Steve suggested....

If 3rd Party tools are not available, build your own and very accurate health check system with perfmon.

include the SQL counters for growth, fragmentation, backups,...

one .exe file? are you calling an application? not sure what you are up to...

but....

In BI, add a process task, and point it to your .exe

save package into SSIS, and...

once again, msdn has the answer!

http://msdn.microsoft.com/en-us/library/aa258803(SQL.80).aspx

"Permissions

DBCC SHOWCONTIG permissions default to members of the sysadmin fixed server role, the db_owner and db_ddladmin fixed database roles, and the table owner,...

2009-11-19 17:36:28.870 spid153 The client was unable to reuse a session with SPID 153, which had been reset for connection pooling. This error may have been caused by an earlier...

I am assuming you upgraded on the same server like you mentioned?

One question, maybe it doesnt mean anything, just a guess...

Did you leave your databases as level 80,90 compatibility? or...

is your DB 15gb and log = 148? or the ther way around?

either...

Definitely, just as long as you buy my plane ticket - from South Africa 😀

http://www.sqlservercentral.com/Forums/Topic538856-149-1.aspx#bm539530

run this first:

=========

DBCC SHOWCONTIG (table_name,index_name)

GO

=========

note the fragmentation and scan density.....

The execute;

==============

DBCC DBREINDEX('table_name',index_name,54)

==============

see any difference in logical frag and extent scan frag?

is your scan density = 100% ?

is your "Avg Pages...

Have to agree with Elliot on this one..

Have your server/network engineers assist you with the permissions on the folder, rather than making it more complicated for youself.

Also consider hosting the...

Hi, you've got quite a few options...

1. Maintenance Plans

2. Schedule a TSQL task job with relevant BACKUP.... code...

3. Build a SSIS package with the backup tasks.

Here you go...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp

if that doesnt make any sense to you yet, post again, with you table and column names, will assist you gladly.

regards,

try:

ALTER DATABASE database-name SET MULTI_USER

http://www.microsoft.com/express/sql/download/