Viewing 15 posts - 37,096 through 37,110 (of 39,769 total)
Haven't seen this, but I have seem similar flaky installs with SQL 2000.
May need to contact MS for this one. Likely some registry issue.
Steve Jones
September 23, 2002 at 10:04 am
Try a clustered index rebuild. Might not be releasing pages. Haven't seen this, but I don't think I have anything like this in production.
Steve Jones
September 23, 2002 at 10:00 am
you need to run thsi from master, not the database. If you have EM open with the database selected, you are "using the database". You need to be connected to...
September 20, 2002 at 11:40 am
September 20, 2002 at 11:39 am
September 20, 2002 at 10:39 am
If I understand this, you have an identity column (EmpID or something) in a table that is a PK. You need to change these values.
What you might want to do...
September 20, 2002 at 10:34 am
rowcount or TOP will limit results, but this may not be what you need.
Steve Jones
September 19, 2002 at 12:26 pm
profiler shoudl show you what is passed to the server. That will tell you if it is sending the where.
For Perf mon, there is a great e-book for sale here...
September 19, 2002 at 12:21 pm
Setup a trigger to rtrim() the fields. But for CHAR, there will always be blanks.
September 19, 2002 at 11:15 am
It is possible. I'd use a .cmd file and make a shortcut to that. Also, better (IMHO) to use Windows Auth with this.
Steve Jones
September 19, 2002 at 11:02 am
Run some performance monitoring as well.
Steve Jones
September 19, 2002 at 10:56 am
Unfortunately, I haven't been able to get the extended properties in a query. The query above will give some stuff, but I think you will need a cursor and loop...
September 19, 2002 at 10:50 am
DST might be the easiest. Or use multiple steps. One to run the sproc. You might need to use xp_cmdshell running isql to create the ouptu file.
For the zipping, use...
September 18, 2002 at 2:43 pm
September 18, 2002 at 2:40 pm
Viewing 15 posts - 37,096 through 37,110 (of 39,769 total)