Check this good discussion here:

http://www.sqlservercentral.com/Forums/Topic446308-360-1.aspx

Try to GRANT VIEW SERVER STATE and VIEW DATABASE STATE Permissions

Do you see any performance issue on the Box with counters at 0.

did the admin did a HOT INSTALL for the memory(ONLINE), or did he Shutdown the box and install...

What authentication are you using, Windows/SQL or both

Also is the target Database in SINGLE user Mode or something.

There could me many things to consider.

Change the MSDE account in services to run as Administrator or under a ADMIN account.

Go with the first approach of changing the size of datatype, but avoid using MAX it is a BLOB type equivalent to text in earlier versions.

so use it carefully as...

Wilfred is correct.

But incase you are not worried about the REf int. and Just want to rest the count, Turn the identity off-> save the table--> turn the identity back...

check this out:

ODBC Connection Pooling Counters in Performance Monitor and ADO

http://support.microsoft.com/kb/q245543/

well that is the reason the DBA's are on job.

Do you have the backup of the master database, from the server.

You should have regularly scripted out the logins for backup.

Well...

ok here goes, check if this is useful and change it to suite your needs or let me know:

declare @tabname_var varchar(25)

declare @sqlstm varchar(4000)

declare @dbname_var sysname

Declare dbnamecur cursor for

select name from...

Try the command outside the Database:

Use master

then the restore command.

Is your Job executing a SP of if it contains a T-sQL, you will have to build the Logic inside the Code and check for Time.

Or use can experiment with...

Check if a Excelsheet with same name is already present or a EXCEL file with same name.

try this:

SET ARITHABORT ON

SET ARITHIGNORE ON

Also check to verify those are not heap tables. (with indid=0)

the Heap tables cannot be de-fragmented, by the DBCC commands.

There are other ways to take care of the heap tables.

Select...

Are you sure this is not a Hardware Issue. Network Card, or need to check the disk I/O. Run a perfmon and look at values for DISK I/O and Also...