Viewing 15 posts - 36,856 through 36,870 (of 39,720 total)
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
Not my area for the eval. I deleted the white paper. I'd contact the company for more info.
If I get a chance to get in on the eval, I'll write...
November 4, 2002 at 1:20 pm
Reinstall the client tools. You likely have a bad install.
Steve Jones
November 4, 2002 at 1:14 pm
Make the changes and then click the Save Script button. The third icon from the left.
Save this and run it. Change the name of the table.
Steve Jones
November 4, 2002 at 1:12 pm
Viewing 15 posts - 36,856 through 36,870 (of 39,720 total)