Viewing 15 posts - 36,721 through 36,735 (of 39,771 total)
BTW, did find this, but it doesn't appear to work for me:
select serverproperty('LicenseType')
Steve Jones
December 23, 2002 at 11:06 am
Sorry for no answer. I looked around for this, but haven't been able to find a way yet.
Steve Jones
December 23, 2002 at 11:03 am
sort of. You can register an exteneded stored procedure, which will be a DLL, however, it will not be in the context of the trigger. It will be part of...
December 22, 2002 at 9:43 pm
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
Viewing 15 posts - 36,721 through 36,735 (of 39,771 total)