Viewing 15 posts - 5,716 through 5,730 (of 9,241 total)
can you post the table definition and the exact command you used to move the table?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 10:48 am
jitendra.padhiyar (4/11/2012)
I setup mirroring and can see "Principal, Synchronized" status of Primary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 10:43 am
sqlfriends (4/11/2012)
Thank you, I don't see change DNS name in the steps.
When you rename the Windows computer it should change this for you and update the account in AD.
An...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 9:43 am
beejug1983 (4/11/2012)
SELECT * FROM fn_my_permissions('sp_start_job', 'domain\ABC')
Even if I log on with other user who has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 8:15 am
sure, you just need to enable the database option
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 6:27 am
anthony.green (4/11/2012)
I was thinking of isolation levels at the connection level not at the database level.
You have to enable them at the database level to use them in the query.
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 6:16 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 2:53 am
Greg Milner (4/10/2012)
--------------------------------------
(2) Checked security on all the folders and shares involved in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 2:46 am
Viewing 15 posts - 5,716 through 5,730 (of 9,241 total)