yes, if it take off the alter statement. I dont see master, msdb etc.

But with the alter statement in there, it tries to run it against master first.

dont undertstand.

still thesame, it tries to run on the master.

I did a truncate and that was all I done. Didnt run a delete.

I know SQL will not allow you to reduce size from GUI, but there must be a...

DB Size 99984.25 MB

Unallocated space 89150.41 MB

I need to be able to reclaim all that unallocated space as these was space allocated to tables before, which I have now deleted.

Cheers

DB is in simple recovery mode.

Hi Roy,

I'm just curious, how do you go about benchmarking I/O stats, can you give me some pointers plz. I have use SQLIO and thats it, as the Disks are...

ALZDBA (6/18/2009)

---

- I haven't seen a grant exec to a certificate. :unsure:

- if you drop a proc, all related grants also vanish !

What you might do is :

1) create a...

As you can image, in a Dev environment its better to drop/re-create to proper version it and also the timestamp on crdate as well on sysobjects is sometimes useful.

Alter would...

Its not created using impersonation, its just created as standard create proc. One option is to include a grant permission on the create script for the creation of the object,...

Thanks for the reply, but doesnt thesame rule apply if the Clustered index was on an integer column ?

thanks for the info, I have just sent you a PM.

cheers

Roy Ernest (5/27/2009)

---

I have seen these dead locks when we had a lousy server. At that time what we did was change the clean up job schedule. This reduced it...

right, so there is no solution for solving deadlocking on replicated articles.

Roy Ernest (5/27/2009)

---

Since this is a reporting server, I do not think there would be much data updated. So the begin tran and commit tran would not be an issue....

Vinay Thakur (5/26/2009)

---

use snapshot isolation level. *This require more tempdb.... manage tempdb carefully.

1. Try to make the distributor job at least for 15mins.

2. *Snapshot isolation will take care of...