Viewing 15 posts - 36,766 through 36,780 (of 39,818 total)
Thanks for the update.
So the issue was lack of disk space? On the paging file?
Seems like a memory issue, like you don't have enough memory available at that time for...
December 23, 2002 at 11:10 am
Never setup an operator as a person.
Setup a distribution list in Exchange and use that as the list in SQL. Prevents points of maint if the dba changes. The network...
December 23, 2002 at 11:08 am
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
Viewing 15 posts - 36,766 through 36,780 (of 39,818 total)