Viewing 15 posts - 3,496 through 3,510 (of 18,926 total)
Does the other server allow remote connections and RPC? That might be the cause of that error.
But I've had that error and it doesn't look anything like...
August 9, 2011 at 1:41 pm
@SQLFRNDZ (8/9/2011)
GilaMonster (8/9/2011)
suhailtajraja (8/9/2011)
interview
What the interviewer was trying to ask, almost certainly, was for the names of the two pseudo-tables that are visible within triggers and nowhere else.
A google search...
August 9, 2011 at 1:40 pm
chandan_jha18 (8/9/2011)
GilaMonster (8/9/2011)
Use profiler, use Statistics IO, use...
August 9, 2011 at 1:37 pm
GilaMonster (8/9/2011)
Use profiler, use Statistics IO, use statistics...
August 9, 2011 at 1:35 pm
CptCrusty1 (8/9/2011)
I'm putting this aside as it's apparent I'm spinning my wheels, making little rocks out of big rocks, trying to drain the...
August 9, 2011 at 1:33 pm
chandan_jha18 (8/9/2011)
August 9, 2011 at 1:31 pm
@SQLFRNDZ (8/9/2011)
If you are working on 2008 versionyou can make use of this dmv in the script
sys.dm_resource_governor_workload_groups
See the comment lines in the above script
Tx I forgot I'm...
August 9, 2011 at 1:28 pm
@SQLFRNDZ (8/9/2011)
suhailtajraja (8/9/2011)
I am referring to system tables accessible from DML triggers. please name them.
SELECT * FROM sys.objects WHERE type='S'
Execute this on a any database you are reffering to...
August 9, 2011 at 1:27 pm
chandan_jha18 (8/9/2011)
Ninja's_RGR'us (8/9/2011)
Do you have the new execution plan? At least we can see how we can help...
August 9, 2011 at 1:22 pm
OP started a new thread for the new problem. Please forward the discussion here : http://www.sqlservercentral.com/Forums/Topic1157186-1292-1.aspx
August 9, 2011 at 1:19 pm
P.S. Try to not start too many threads at the same time. It just fragments replies and waste everybody's time.
August 9, 2011 at 1:18 pm
What happens if you turn them off again?
August 9, 2011 at 1:17 pm
Ninja's_RGR'us (8/9/2011)
This sounds like an interview / exam question.
What did your research find out, where are you getting stuck and where do you need o go...
August 9, 2011 at 1:16 pm
Catastrophic failure pretty much means hardware failure.
I'd look at the windows event log to find more usefull info.
That's how far my expertise goes into this domain. Might be time...
August 9, 2011 at 1:15 pm
suhailtajraja (8/9/2011)
I am referring to system tables accessible from DML triggers. please name them.
ALL OF THEM.
Check the link I posted, they are all listed there.
You might get more usefull help...
August 9, 2011 at 1:11 pm
Viewing 15 posts - 3,496 through 3,510 (of 18,926 total)