The proxy account can you not grant it access to the objects in question?

Or another way is to change the execution context of the TSQL statements so it is using...

I have never had tuning template, or any trace cause block on SQL Server. Yes SQL Server takes performance hit; but it doesn't shut down.

Maybe try running profiler with...

Hey,

Mind running CHECKDB and putting the output? The number being negative something is not correct about freepage information in the database. And in one case...

Hmm can't say i have it hang. The management studio has hang on me sometime but it ususally recoveres. Are you logging the trace data to a table...

Depending on your through put on SQL Server you might want to try capturing the log and running it through PSSDiag? It will tell you what queries are running...

I seen this a few times on the VM servers we have. In most cases it was I think network issue; the SQL Server profiler was collecting a lot...

SQL Server allows more then one admin connection; think about it in team of multiple DBA supporting large systems if only one admin connection was allowed / instance it would...

The I/O issue you are having is it with one table or multiple tables?

I/O can take long time to write in tables that don't have cluster indexes.

You might have a badly configured io subsystem; that is you might have one channel back to...

nathanielt (3/4/2009)

Note: When I add the user into the sysadmin server role, this error goes away, but I can only have 1 connection at a time, which is no good...

A long time; the Disk management guys at work told me it is usually a good idea to keep disks in chucks of 250GB .. easier to manage and scan...

Thanks ;-).

🙂

Mohit.

Hi Paul,

That is a great...

Hi,

I have many similar scripts like Lynn suggest I chained them into Stored Procs. I have a database created on each of the Servers called DBManagement;...

Hi Jeff :),

It's on its way, I been busy with my research on the Theises for Masters. I have next two weeks off work; I plan...