Viewing 15 posts - 37,261 through 37,275 (of 39,511 total)
Do you want these in separate columns? IF so, this doesn't make sense unless it is the distinct (size, color, width)
select distinct productsize, productcolor, productwidth
will give you this. If you...
July 2, 2002 at 9:58 am
I believe the only way to remove SP1 is a reinstall (detach dbs, uninstall, reinstall, attach). Not sure about SP2.
Steve Jones
July 2, 2002 at 9:52 am
AFAIK, you cannot backup to a remote tape. Can you backup to a drive on the tape server and then use the Backup utility to get these files?
Steve Jones
July 2, 2002 at 9:48 am
I'd guess network issue. Could be versioning.
Is there a reason you don't use DTS?
Steve Jones
July 2, 2002 at 9:43 am
What is SQL 97? SQL Server 7.0?
From BOL:Number of pages used for miscellaneous server purposes (including procedure cache).
This is the def for the stolen pages. If you have only 2...
July 2, 2002 at 9:41 am
This causes the maintenance plans to fail and is a known issue. Follow Andy's advice.
Steve Jones
July 2, 2002 at 9:35 am
Tend to agree with Andy. Large queries are problematic in that you cannot limit the CPU devoted to the process and this can "lock" the box. It will come back...
July 2, 2002 at 9:32 am
You'd have to use xp_cmdshell and call isql/osql to pipe to a text file, use DTS, or bcp.
Steve Jones
July 2, 2002 at 9:28 am
There are some posts here. I noticed a delay in SQL Server getting the update, I think 40 sec on SQL 2K, W2K.
Search these forums and you'll see a thread.
Steve...
July 1, 2002 at 12:36 pm
In past versions, I used to do this, but only if the SQL Server is STOPPED. IF the SQL Server continues to run, then you will probably not be able...
July 1, 2002 at 9:16 am
Should be fine. If you need to grant permissions to everyone, you will need to reenable it.
Steve Jones
July 1, 2002 at 9:14 am
Glad you liked it and thanks everyone for the comments.
I've got part 2 out now and have a part 3, which addresses some header comments in the next part.
Steve...
July 1, 2002 at 9:05 am
Thanks for all the comments. This is something that I have found helpful as well and hopefully others will adopt something similar to standardize their environments.
Steve Jones
July 1, 2002 at 8:54 am
Viewing 15 posts - 37,261 through 37,275 (of 39,511 total)