Viewing 15 posts - 36,841 through 36,855 (of 39,720 total)
Wrote about this recently:
http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp
Steve Jones
November 14, 2002 at 10:36 am
you are welcome. It's one area we need some more articles to let people know how easy it is. Glad it worked for you.
Steve Jones
November 13, 2002 at 4:41 pm
There isn't a good way in SQL to script out everything. There are ways to get at the data, but no easy way to script them. Is there a reason...
November 13, 2002 at 10:25 am
Thanks. It is simple, but you might end up digging around and no one wants to do that in a pressure situation.
Glad you like it and hopefully this is an...
November 11, 2002 at 9:25 am
Not sure if this is a huge problem. Could lead to some confusion and Brian has good points. In general, if you do not need a stored procedure executed from...
November 8, 2002 at 9:33 am
November 8, 2002 at 9:26 am
November 7, 2002 at 11:09 am
the inputbuffer has the values for each user. Not for the database. Guess you could query sysprocesses to find out who had the last query (there's a timestmap in here)...
November 7, 2002 at 10:12 am
Haven't seen one. I'd follow the logical steps. Backup dbs (be sure these are on antother server or tape). Detach dbs, upgrade, reattach.
Might need to reapply SPs, but I...
November 6, 2002 at 2:31 pm
create trigger mytrigger on mytable for update
as
update database_02.dbo.Table1
set myfield = i.myfield
from inserted i
Steve Jones
November 6, 2002 at 2:27 pm
November 6, 2002 at 10:35 am
xp_fixeddrives?
Steve Jones
November 6, 2002 at 10:32 am
changed @size to bigint, get different error. Tried numeric, error. Float returns null.
Expect that the drive size (in bytes) exceeds the int range. Not sure why bigint doesn't work.
Steve Jones
November 6, 2002 at 10:29 am
Is this a SonicWall Pro? Used one with no real issues. Be sure the client isn't trying NetBIOS as Brian suggested first.
Steve Jones
November 6, 2002 at 10:26 am
Viewing 15 posts - 36,841 through 36,855 (of 39,720 total)