Viewing 15 posts - 36,946 through 36,960 (of 39,818 total)
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
SQL Server Agent is the equivalent of the NT Scheduler or the W2K Scheduled tasks. It performs things for SQL Server based on it's configuration.
An application can store data in...
November 6, 2002 at 10:20 am
not really. you need to "compile" the object, you cannot copy it. You could write some T-SQL to get the data from syscomments and then exec() this to compile it....
November 6, 2002 at 10:13 am
Returned in order of clustered index, could be desc.
Steve Jones
November 6, 2002 at 10:01 am
Have you enabled AWE? With more than 2GB, and when you enable AWE, you need to set the min and max for each instance. Otherwise, they will be sharing the...
November 6, 2002 at 9:44 am
You should be able to get this in Books Online. Sorry, don't have a copy lying around.
Steve Jones
November 6, 2002 at 9:41 am
Thanks for the update. The driver must not include those items in teh colletion.
Steve Jones
November 5, 2002 at 11:02 am
Might be attempting named pipes. Probably need to check clients for protocol bindings and perhaps sniff the network.
Steve Jones
November 5, 2002 at 10:54 am
Viewing 15 posts - 36,946 through 36,960 (of 39,818 total)