Viewing 15 posts - 36,286 through 36,300 (of 39,717 total)
Keep in mind that the plan goes to all servers. It is not "customized" for each server, otherwise you would not use master/targets.
Pick either "User Databases" or "System databases" and...
May 14, 2003 at 10:05 am
We are mainly an internal SQL Server shop, but moving towards DB2/UDB. Our software (which we sell) is being pushed on DB2 mainly for marketing reasons. I've got an article...
May 14, 2003 at 10:01 am
Can you post some data examples. Your explanation seems confusing.
Steve Jones
May 14, 2003 at 9:52 am
If this is SQL 7 or 2k, you don't want to alias. That was a prior feature in v6.5. In 7 ro 2k you would probably want to give them...
May 14, 2003 at 9:48 am
Is this MSDE? Can you give the whole output of SELECT @@version?
Steve Jones
May 14, 2003 at 9:37 am
SQL basically consists of INSERT, UPDATE, DELETE, SELECT. In the original language, there were only 12 words.
Now there are TSQL extensions and the reserved words are in books online if...
May 13, 2003 at 10:12 am
It's a tough question. Not sure that indexes count towards the statistics, but knowing the laziness of programmers, I doubt it.
Steve Jones
May 13, 2003 at 9:44 am
A view is built on the fly, so it is not "stored" anywhere. It is resolved and referenced at run time.
During an update, this is just like a query against...
May 12, 2003 at 5:29 pm
I too use Litespeed and have been doing so for quite a few months. We've substantially reduced the backup sizes and tapes required with this product.
We also have a...
May 12, 2003 at 9:27 am
May 9, 2003 at 10:02 am
You can schedule the script or program using SQL Agent. Set the job step up as an Operting System command.
Alternatively, you can run a task using the AT command or...
May 9, 2003 at 10:01 am
We do this all the time for EOL servers and use the method that Allen mentioned. We perform the following:
1. Run full backup from source machine, restore on new machine....
May 9, 2003 at 10:00 am
Glad it helped.
BTW, an update: I spoke with someone on the internet who has done more testing and my inference that xp_msver was being called for @@Version is incorrect. There...
May 8, 2003 at 3:24 pm
May 8, 2003 at 3:21 pm
1. no
2. you can "fake" this by storing them in a table and using @@spid to track them to a user.
Steve Jones
May 8, 2003 at 3:17 pm
Viewing 15 posts - 36,286 through 36,300 (of 39,717 total)