Viewing 15 posts - 2,131 through 2,145 (of 6,216 total)
Mark, I think the low replies is a combination of timestamps not being used as much as identity, and no one else having seen the problem.
For MS, you can find...
May 15, 2003 at 4:19 am
Do you have the table open somewhere else? If SQL needs exclusive access to make the change, it'll sit there until it gets it.
Andy
May 15, 2003 at 4:15 am
Probably depends on what you're working with. OpenXML is a pretty valuable construct. I don't use For XML as much, but I do mostly desktop stuff, not web, so maybe...
May 14, 2003 at 5:10 pm
May 14, 2003 at 2:04 pm
Sometimes the process hangs up. Look in task manager, see if you have sqlmaint running. If so (and no other plans running) kill it. Then try the job again.
Andy
May 14, 2003 at 1:13 pm
May 14, 2003 at 1:08 pm
Drop the user from the db. Then run:
sp_addalias 'dbo', 'whatevertheloginis'
If you put the user in db_owner when they create objects they will be prefixed with the login unless the script...
May 14, 2003 at 12:41 pm
You have to first connect to the db, using either trusted or sql login, then execute the approle proc. That turns off permissions associated with the original login as far...
May 14, 2003 at 7:02 am
I'd like to hear the result if you figure it out.
Andy
May 13, 2003 at 4:51 am
A variation of detach/copy/attach works well. Trick is to make the new server have the same file locations as the original. Install SQL, put the master in the same location...
May 13, 2003 at 4:09 am
The user is orphaned. Look at BOL for info on sp_change_users_login, or you can do a search here on the site for tons of related articles and posts.
Andy
May 12, 2003 at 6:12 pm
Just do the alter, it don't affect replication. If the column was published, you'd have to drop the subscription and remove the column from the article, change it, add back,...
May 12, 2003 at 9:09 am
I always start normalized, then if I find a problem I can't solve using that structure I look at alternatives. In the scenario you describe, an indexed view might be...
May 11, 2003 at 6:25 pm
You can avoid the exec altogether if you just put all the column values as paramters to the proc. You could also handle the backup work by putting a trigger...
May 10, 2003 at 5:16 am
Select * can be bad, it depends. If you're only returning a few rows that isn't nearly as bad as if you're returning 10k rows. It could be laziness, or...
May 9, 2003 at 4:53 pm
Viewing 15 posts - 2,131 through 2,145 (of 6,216 total)