Viewing 15 posts - 256 through 270 (of 1,518 total)
Perry Whittle (7/23/2011)
Marios Philippopoulos (7/22/2011)
July 25, 2011 at 7:49 am
Chuck Hottle (7/22/2011)
July 22, 2011 at 1:51 pm
It looks like I am not able to capture the sproc name in the [executing batch] column if the individual SQL statement is submitted as dynamic SQL.
All I get is...
July 22, 2011 at 12:35 pm
Chris Harshman (7/22/2011)
INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id
LEFT...
July 22, 2011 at 10:49 am
GilaMonster (7/21/2011)
Please note: 3 year old thread.
I'll open a new post.
July 22, 2011 at 8:19 am
Would the query below work?
I'm looking for long-running queries that are currently running on the server, not a historic analysis of those stored in the cache.
Queries are ordered by...
July 21, 2011 at 1:22 pm
Perry Whittle (7/18/2011)
are you aiming at just user created database roles or fixed roles too?
Both.
July 18, 2011 at 9:34 am
What you wrote earlier makes sense. I'm using this comparison in a production vs. D/R environment analysis of settings.
When a DBA attempts to synchronize D/R role mappings according to production...
July 18, 2011 at 9:33 am
Any input anyone?
July 18, 2011 at 8:29 am
Where do the warnings come from?
Can you also provide the actual message?
Also, assuming you are on a physical (not virtual server) what is the Available Memory In Task Manager?
July 5, 2011 at 2:14 pm
opc.three (6/21/2011)
June 21, 2011 at 9:27 am
opc.three (6/20/2011)
What version is the OS is running on the remote server? What version is the database instance?
Thank you for responding.
OS is on Windows 2003 R2, SP2
sql is on SQL...
June 21, 2011 at 9:09 am
I actually found a link that is quite relevant to what I am trying to do, which is to script out all report subscriptions and non-default execution settings and redeploy...
June 20, 2011 at 8:44 am
quan23 (6/20/2011)
The PolicyRoot field in the catalog table defines whether an...
June 20, 2011 at 7:58 am
Viewing 15 posts - 256 through 270 (of 1,518 total)