Viewing 15 posts - 37,081 through 37,095 (of 39,944 total)
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
You can if the tape device is attached to the server. Not sure of scripting this. I think you would need to use the GUI to attach and read from...
November 4, 2002 at 11:10 am
Viewing 15 posts - 37,081 through 37,095 (of 39,944 total)