Viewing 15 posts - 5,731 through 5,745 (of 9,253 total)
forsqlserver (4/11/2012)
Hi,Thanks,
I am using XP_CMDSHELL.
On running: Exec XP_CMDSHELL 'c:\te.bat';
It continuosly goes to executing query state.
So, am i correct in saying you can execute this from SSMS query window but...
April 11, 2012 at 5:10 am
asranantha (4/10/2012)
if u know answers plz tell me
All pirates should find their own treasure 😀
or just maybe research a little more 😉
April 11, 2012 at 5:00 am
can you supply a little more info on exactly what you're doing and any errors you receive
April 11, 2012 at 4:58 am
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.
April 11, 2012 at 4:56 am
the second script bombs as there is a table missing.
Have you considered implementing a more suitable isolation level?
April 11, 2012 at 4:21 am
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...
April 11, 2012 at 3:35 am
There's a lot of good information regarding SQLIO, check the following Microsoft KB link for more info
April 11, 2012 at 2:53 am
Greg Milner (4/10/2012)
--------------------------------------
(2) Checked security on all the folders and shares involved in...
April 11, 2012 at 2:50 am
Mohammed Imran Ali (4/10/2012)
Thanks Perry for the article.
You're welcome, I hope it helps.
Mohammed Imran Ali (4/10/2012)
April 11, 2012 at 2:46 am
jgflufg (4/10/2012)
All sql disks are mount points(system,temp,data,log).The mount point disk for system dbs for all sql instances is...
April 11, 2012 at 2:38 am
sqlfriends (4/10/2012)
April 10, 2012 at 11:39 pm
Lynn Pettis (4/10/2012)
Perry Whittle (4/10/2012)
jitendra.padhiyar (4/10/2012)
Yes Pettis,I selected the option " Restore With Norecovery" during restore of db. But still the same status.
you also need to take and restore at...
April 10, 2012 at 5:01 pm
you'll need to work with your domainetwork admins to ensure everything is set up correctly
April 10, 2012 at 4:59 pm
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...
April 10, 2012 at 4:45 pm
Divine Flame (4/10/2012)
Perry Whittle (4/10/2012)
April 10, 2012 at 4:30 pm
Viewing 15 posts - 5,731 through 5,745 (of 9,253 total)