Viewing 15 posts - 2,746 through 2,760 (of 3,232 total)
I don't think that I am 100% clear on what you are after here, but here's what I have so-far. The below table defs include the data from your post...
July 18, 2006 at 4:04 pm
Max Server Memory is an instace level setting. You could accomplish what you want by installing a second instance of SQL Server. Run the production database on one instance and...
July 18, 2006 at 3:33 pm
What Sergiy has given you will work for the same table. Just replace the work Table in the query (for both T1 and T2) with the same table name. This...
July 17, 2006 at 3:51 pm
Although it is not explicitly stated in BOL, I don't think you can change the owner to a Windows group.
July 17, 2006 at 2:01 pm
What do you mean by 'it doesn't work'? You say that you've tried to map the Windows group to DBO, what did you do to attempt the setup?
July 17, 2006 at 1:27 pm
You don't have to account for it, the JOIN takes care of that. Since you are joining on MF_ID = (list of ID's) the only way you would have a...
July 17, 2006 at 12:53 pm
You can do this all in one stored procedure without having to do the first select. Use a JOIN with a derived table so you don't have to do a...
July 17, 2006 at 12:15 pm
That's great as I was stumped. Anyway, I just wanted to point out an additional method for what you are doing. Check out COALESCE in BOL. It is easier to...
July 17, 2006 at 11:46 am
They are not checking the success/failure of sp_password before clearing out the password_change row. Sp_password has a number of validations that it runs before it changes the password. I would...
July 17, 2006 at 9:40 am
How did you migrate the data to your new box? It sounds to me like the nText columns for HTML and Textual in your Custom table are not truely NULL. ...
July 14, 2006 at 4:01 pm
You are using %s for your @spid1 which is an integer. Try using @d instead.
raiserror
('The user with login :%S , running the program : %s has been blocked...
July 14, 2006 at 1:32 pm
What exactly do you mean by 'can't restart the box'? The /3GB switch should be added into the boot.ini file, not as a SQL Server startup parameter. Adding it in...
July 14, 2006 at 1:21 pm
Thanks for brightening my day Andrew. The Chronicles of George is the funniest thing I've ever read, although I wish you had warned me that I would spend soo much...
July 14, 2006 at 11:56 am
Both Vladan and Tim have good suggeestions. The reason I asked my first question is because I had a couple of solutions in mind. One being the temp-table solution that...
July 14, 2006 at 9:07 am
The only real way to audit deletes would be to set up an audit table and use the DELETE trigger to populate it based off of the sysprocesses data. You...
July 13, 2006 at 3:32 pm
Viewing 15 posts - 2,746 through 2,760 (of 3,232 total)