Viewing 13 posts - 1 through 13 (of 13 total)
We had the same problem with a 12GB server - I'm extremely surprised that this particular hotfix isn't more widely cited, since it seems to cause a lot of problems. ...
November 3, 2006 at 11:07 am
Ed-
Thanks, this is consistent with what I understood. Is it true to say that enabling /PAE in the BOOT.INI is pointless unless you enable AWE in SQL?
Also, I was under...
August 15, 2006 at 10:10 am
Mike-
Thanks very much for the feedback. Your code is a lot cleaner than mine but I think I discovered the source of the problem after doing a little more googling. ...
January 20, 2005 at 7:37 am
I've considered it, but at that point I'd rather just write it as pure VBScript that uses WMI to get the info and ADO to update the relevant fields in...
January 10, 2005 at 9:06 am
I've contributed a script to SQLServerCentral that allows you to import event log entries from network computers using LogParser (from Microsoft's IIS Resource Kit). Just do a search for LogParser...
January 5, 2005 at 11:04 am
I contributed a nifty stored procedure that uses LogParser to import EventLog data -- take a look. Just do a search for LogParser and the script will be in the...
January 5, 2005 at 10:54 am
Douglas-
You're spot on -- thanks! You are correct, my query is incorrect -- it should have included something like AND Item = queue.Item in the subquery. The real query is...
October 26, 2004 at 11:44 am
I'd be careful with the wisdom of writing a universal stored procedure, but one way to get your current database is:
SELECT db_name(dbid) FROM master..sysprocesses WHERE spid=@@SPID
October 25, 2004 at 1:14 pm
Nigel -
You *are* my hero -- that was perfect.
I touched up your procedure a little -- my processing isn't as sophisticated as yours, but it's a lot simpler...
November 6, 2003 at 1:46 pm
I've started using RAISERROR a lot more than PRINT. If you use it with severity of 10 (rather than severity 16, which most people use to raise ad-hoc errors),...
August 3, 2003 at 3:59 am
Linked servers are generally the way to go -- I've found them flexible and efficient over the years. If you're averse to linked servers, you should look in BOL...
August 3, 2003 at 3:54 am
That did the trick, Mark -- thanks!
August 3, 2003 at 3:47 am
Good article and thoughtful responses -- one topic not covered: as a consultant, I write a lot of TSQL scripts and have been playing around with different file headers...
August 16, 2002 at 1:21 pm
Viewing 13 posts - 1 through 13 (of 13 total)