Viewing 15 posts - 36,901 through 36,915 (of 39,769 total)
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
If you cannot figure it out, pls post the exact errors.
Steve Jones
November 5, 2002 at 10:26 am
There is a "most popular articles" under the Articles link (under resources).
Steve Jones
November 5, 2002 at 10:10 am
Not sure how buffer cache can go over 100%. Have seen other %'s, like CPU, etc go over when there are multiple instances.
CPU will fluctuate, especially with large queries. No...
November 5, 2002 at 10:04 am
Agree this is an issue. Fighting a number of inherited accounts whose passwords haven't changed. #$%$#^#$ developers claim it can't be changed.
Send a password lockout and expiration policy to sqlwish@microsoft.com....
November 4, 2002 at 1:24 pm
Viewing 15 posts - 36,901 through 36,915 (of 39,769 total)