So, am i correct in saying you can execute this from SSMS query window but...

All pirates should find their own treasure 😀

or just maybe research a little more 😉

can you supply a little more info on exactly what you're doing and any errors you receive

There are a couple of options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION. Both acquire no page or row locks when reading, check BOL for more info on these.

the second script bombs as there is a table missing.

Have you considered implementing a more suitable isolation level?

seesachinjadhav

build yourself a couple of virtual machines and get yourself going from there. See my guide starting at the following link[/url] for more help.

If you wish you may...

There's a lot of good information regarding SQLIO, check the following Microsoft KB link for more info

Greg Milner (4/10/2012)

---

The operating system returned the error '5(Access is denied.)' while attempting 'DeleteFile' on 'G:\MSSQL\Backup\RestoreCheckpointDB10.CKP'.

--------------------------------------

(2) Checked security on all the folders and shares involved in...

You're welcome, I hope it helps.

Mohammed Imran Ali (4/10/2012)

---

The new partitions when they are created gets its own filegroup and is placed...

jgflufg (4/10/2012)

---

Hi ,i have 3 node cluster and 3 sql instances installed .

All sql disks are mount points(system,temp,data,log).The mount point disk for system dbs for all sql instances is...

sqlfriends (4/10/2012)

---

So when you say your rename server, you do both rename computer name then use sp_dropserver and sp_addserver to rename SQl server name, correct? then after both done,...

Lynn Pettis (4/10/2012)

---

Perry Whittle (4/10/2012)

---

you also need to take and restore at...

you'll need to work with your domainetwork admins to ensure everything is set up correctly

If you have a SQL server MYSERVER with named instance INST1 you may only change the server name. The instance name will remain as it was installed like so

MYSERVER\INST1 to...

Divine Flame (4/10/2012)

---

Perry Whittle (4/10/2012)

---

So, if you have a public network connection with IP 192.168.1.30 and a secondary backup network with IP 10.10.10.30 and you copy backups to the backup...