Viewing 13 posts - 1 through 13 (of 13 total)
The SPID in the nonyielding message is 0.
We sent our logs and dump files to Microsoft, and are waiting for their support.
Did you hear back from Microsoft? Did they resolve...
July 23, 2008 at 12:05 pm
We had a similar situation with one of our clients. We are not responsible for their databases but we helped them out. Here is what happened:
It was a SQL Server...
July 14, 2008 at 10:00 am
Thanks GilaMonster and John Rowan!
December 4, 2007 at 8:51 am
Steve Jones - Editor (12/3/2007)
You can limit Profiler to one database, even one type...
December 3, 2007 at 4:49 pm
noeld (12/3/2007)
U (12/3/2007)
noeld (12/3/2007)
U (12/3/2007)
December 3, 2007 at 4:05 pm
noeld (12/3/2007)
U (12/3/2007)
December 3, 2007 at 3:58 pm
I don't mind running Profiler in a Dev environment but when there is a problem in Production environment I would rather prefer a tool that will quickly capture and show...
December 3, 2007 at 3:47 pm
The "Maintenance Plan" in SP2 CTP is still having problems and not anywhere close to the way it used to work flawlessly in 2000. Here is one example..
February 21, 2007 at 9:01 am
Under the execution plan, for "stream aggregate" the value for "Estimated number of executes" is 1. So, I am assuming the subquery is getting executed only once. I hope I...
September 22, 2005 at 9:03 am
Jeff,
I tried it without the outer parenthesis but it gives exact same error. I also tried single quotes around osql but it also gives the same error. It is frustrating...
January 17, 2005 at 9:50 am
Thanks Kenneth.
I am having problem wrapping a dos script around it. Do you have an example of dos assignment?
Here is what I have tried to do but it gives...
January 14, 2005 at 10:22 am
Going one step further, any ideas as to how a text search can be done in SQLServer? For example, I have two tables:
t1 (n1 numeric, col1 varchar)
t2 (n2 numeric, col2...
April 30, 2004 at 3:32 pm
Thanks! Any ideas as to whether the same solution can be used in other databases like Oracle, MySQL, DB2?
April 30, 2004 at 3:01 pm
Viewing 13 posts - 1 through 13 (of 13 total)