Viewing 15 posts - 36,856 through 36,870 (of 39,903 total)
In SQL Server 7 and 2000, a debugger is available in Query Analyzer.
Steve Jones
December 22, 2002 at 9:42 pm
Agreed. Compared to some other vendors that shall go unnamed, the support is premium.
Another vendor experience (not good) prompted me to write this one.
Steve Jones
December 21, 2002 at 10:54 pm
Good points. I might also add that more developers need to learn humility and learn to detach themselves.
I too often find developers who commit to a plan without being willing...
December 20, 2002 at 9:48 am
I do what Antares suggested when I want to track changes.
Triggers on system tables are not guarentted to fire.
Steve Jones
December 19, 2002 at 3:55 pm
Not a bad solution. I've done something similar, but I let each server query itself and store the results in a table. Then I have a master server that queries...
December 19, 2002 at 3:52 pm
The formats are different, but I'm not sure if that was your issue.
I generate a unique filename each night so I always know which backup I've got stored in the...
December 19, 2002 at 11:31 am
No info, but with a buffer problem like this, I'd call PSS. Perhaps take another backup, try to BCP out the data in the table, drop, rebuild the table, then...
December 19, 2002 at 9:54 am
Was wondering about that post.
I think this is where what we do is more of an art than a science. Each work is unique (to a large extent) and works...
December 19, 2002 at 9:50 am
I track changes:
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
December 19, 2002 at 9:44 am
Two different things. Logically. The PK is the unqiue identifier for the data row. A unique index preseves uniqueness in the column.
Physically they are implemented the same.
Steve Jones
December 19, 2002 at 9:40 am
I concur with Scorpian.
Steve Jones
December 19, 2002 at 9:36 am
I'm not sure how this can be done. If dbcc errorlog doesn't work, then you may just need to cycle the server.
Sorry, don't have a v6.5 server to test with.
Steve...
December 19, 2002 at 9:30 am
I've seen that too, though it's changing. More and more I'm seeing tech pros paid more than their manager. Comes a limit, however, since managing entails more responsibility at some...
December 18, 2002 at 4:52 pm
Viewing 15 posts - 36,856 through 36,870 (of 39,903 total)