Viewing 15 posts - 5,716 through 5,730 (of 7,168 total)
Syed,
Here is an article for your review. It will give you the information you need to determine which of your stored queries should be updated:
July 1, 2011 at 11:14 am
Tara-1044200 (7/1/2011)
July 1, 2011 at 11:01 am
That must be an issue with 2005 Agent because the setup works fine in 2008 Agent, i.e. it keeps going even after an error has occurred from not being able...
July 1, 2011 at 10:46 am
Rob Scholl (7/1/2011)
July 1, 2011 at 10:23 am
When there have been no updates or seeks on the index of course 🙂
Here is a quick proof that shows how to achieve that state:
IF EXISTS ( SELECT *
...
July 1, 2011 at 10:17 am
Jeff Moden (6/30/2011)
One more "extension" of the problem you posed. It's super easy to break out all of the individual parts of the path and number them. Shamelessly...
July 1, 2011 at 8:35 am
It may help us if you provided some sample DDL and DML so we can build a little test environment on our side. This way, with the sample data and...
July 1, 2011 at 8:23 am
Commercial offerings are scarce, and I think that's a good thing. There is only one book you really need, but it's not the one most people think of right away:
June 30, 2011 at 5:57 pm
Hmmm...I see x64 downloads.
Go here: http://support.microsoft.com/kb/2261464
...then click on "View and request hotfix downloads" at the top.
June 30, 2011 at 4:28 pm
Got it now 🙂
Use sys.sysprocesses for 2005+
June 30, 2011 at 3:24 pm
Craig Farrell (6/30/2011)
June 30, 2011 at 3:20 pm
Elliott Whitlow (6/30/2011)
Still, I want to know WHY..CEWII
Me too 🙂
June 30, 2011 at 2:54 pm
It's always 2, the id for tempdb, for me.
LoginName & NTUserName are proper which is nice. Maybe one of those could be used to infer the DB name, depending on...
June 30, 2011 at 2:53 pm
Excellent, you're very welcome 🙂
June 30, 2011 at 2:49 pm
That does not seem to work in terms of finding the correct database name. It always says tempdb for me 🙁
June 30, 2011 at 2:48 pm
Viewing 15 posts - 5,716 through 5,730 (of 7,168 total)