Viewing 15 posts - 8,206 through 8,220 (of 9,715 total)
First look up CREATE LOGIN, CREATE USER and sp_addrolemember in BOL (Books Online). This will give you all the syntax you need.
Dynamic SQL is the act of putting SQL...
November 5, 2009 at 6:34 am
The problems with any backup tool is that if it breaks or you lose your license, you have all these backups you may not be able to restore if the...
November 5, 2009 at 6:28 am
One by one? Ah, you need to be more creative. @=)
If you can only "fix" certain users, try putting the specific logins in a table on a DBA only database...
November 5, 2009 at 6:01 am
Thanks, Gail. I'm patient and any new links you have would be greatly appreciated. FYI, looking at your very first link above, I found my answer.
The transaction log has...
November 5, 2009 at 5:34 am
I'm sorry, but I'm still not clear on what you want to accomplish. Could you be more detailed?
November 5, 2009 at 5:22 am
Not quite sure what you're asking. Do you mean you want to create a trigger that looks at the input before anything happens so you can verify there's no SQL...
November 5, 2009 at 5:02 am
You're going to have to write up a script.
The way I do it is to have my restores created in jobs. After the restore step, I have a script...
November 5, 2009 at 4:58 am
mahesh.vsp (10/31/2009)
In such cases, do we need to go for only...
November 4, 2009 at 12:28 pm
GilaMonster (10/27/2009)
As for documentation, I doubt there's a msdn article that tells you what will happen if you do something that you're never supposed to do.
I'm not looking for "what...
November 4, 2009 at 12:23 pm
Gail,
Do you have documentation (or links) you can point to that refer to this? Or is this just a "general knowledge" thing that everybody knows but isn't actually documented?
I ask...
October 27, 2009 at 5:33 am
mahesh.vsp (10/27/2009)
Data Transformation services.
My question is , i dont have any dts packages created pointing to my application database.
Still it is...
October 27, 2009 at 4:19 am
The Upgrade Advisor should NOT be run the day of your migration. It should be run at least a week *before* your migration (several weeks, if possible). If the Upgrade...
October 27, 2009 at 4:14 am
GilaMonster (10/26/2009)DBCC UpdateUsage and sp_updatestats do completely different things. Are you thinking of UPDATE STATISTICS vs sp_updatestats?
I plead the "Monday Mornings" as my excuse.
Yes, that's what I meant. DOH!...
October 26, 2009 at 6:59 am
Neither really is better than the other. The issue with Detach / Attach, though, is if you forget to make a copy of your files, you can never "roll back"...
October 26, 2009 at 6:58 am
I knew I forgot something. The stats update. VERY IMPORTANT when upgrading from SQL 2000 to either 2k5 or 2k8.
Thanks for the reminder, Gail.
ravikanth - Reasons why you don't want...
October 26, 2009 at 4:58 am
Viewing 15 posts - 8,206 through 8,220 (of 9,715 total)