Instant file initialisation requires that the account that runs SQL has permission to do volume maintenance.

Check the local security policy for the server, find the item 'Perform Volume Maintenance tasks'...

What error are you getting?

It's because the ownership chain is broken.

Assume a user that has exec permissions on a stored proc, but not on a table. The proc does a select on that...

icampbell (1/15/2008)

---

The table is created, then the data inserted from the view.

I have a seperate procedure that fires every minute that works for inserts.

However how do i do a triger...

That's a pretty massive request. Do you have any experience in doing any of that?

If not, I would recommend you look at getting someone in who does know how to...

Was my answer inadequate?

in sysprocess there is a column blocked which shows the processid of the blocking process.

What about using...

If you update a view, the table underlying that view is updated. You shouldn't need a trigger.

I'm not sure i understand what you're after.

If you query sysprocesses (select * from master..sysprocesses where spid > 50) you'll see there are four columns - blocked, waittime, lastwaittype and...

RPC Process? Did you identify that from profiler or from the deadlock graph?

Could you post the deatils that you have?

PRC calls are usually stored procedures. Means you'll have to dig...

You can use a normal temp table (#Tablename) as its visible in the procedure that created it, and any procedure or dynamic SQL called by that procedure.

A table variable has...

I had much the same problem some months back. Group of developers felt they were above the rules and were fiddling on Prod using a SQL account for a messaging...

The structure of the data and log files are the same for all the architectures that SQL runs on.

I've moved DBs (detach/attach) between IA-64 to x86, from x86 to...

You can't directly control it.

The cache remove occurs when SQL, for whatever reason, decides that the cached execution plan for the query its about to run is no longer optimal....

A heap can't really fragment. Since there's no defined order for the rows, pages are just added at the end of the chain.

What you can get with heaps is forward...

Firstly, see if anything's changed in tha last few days. Any code changes, large data loads, hardware changes, etc, etc

Rebuild the indexes if they're fragmented. If you do a rebuild,...