Viewing 15 posts - 36,331 through 36,345 (of 39,771 total)
Is the data in a temp table? Do you mean to select back from the temp table? Or select a series of fields from a table based on what the...
May 15, 2003 at 9:56 am
It's kind of complicated what you are describing and a little confusing. A diagram would help, /images/networkimg.jpg. I changed a few names and for the linking tables, you don't need...
May 15, 2003 at 9:51 am
Actually, I believe you need a CAL OR a licensed "seat" on the server.
Steve Jones
May 15, 2003 at 9:31 am
Haven't seen this. Have you tried dropping and rebuilding the index? Dropping and rebuiling a clustered index on the table?
If it persists, I'd call MS before you experience data loss.
Steve...
May 15, 2003 at 9:13 am
Sorry, haven't upgraded analysis services, but we have upgraded numerous v7 servers and they work great. I'd take a full backup and then run the upgrade and you should be...
May 15, 2003 at 9:11 am
Thanks for the comments. I didn't get into the performance aspects since I haven't actually done the testing. We have genrously received a license from MS (thank!) for W2K3 here...
May 15, 2003 at 9:09 am
If you don't want to change the owner, in the database | users, select the user name, right click, properties, then select the db_owner role.
Steve Jones
May 14, 2003 at 11:41 am
This is personal, i.e. a desktop edition. It is not for lots of people to connect to and run queries. It's mainly for developers working on their machine.
You need to...
May 14, 2003 at 11:30 am
May 14, 2003 at 11:28 am
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
Viewing 15 posts - 36,331 through 36,345 (of 39,771 total)