Viewing 15 posts - 8,206 through 8,220 (of 9,713 total)
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
I haven't done migration to 2008 yet. However, from what I understand, the engine hasn't changed very much and 2008 supposedly allows a direct upgrade from 2000.
Look into Microsoft's SQL...
October 23, 2009 at 7:27 am
Cool! Glad you figured it out. @=)
October 22, 2009 at 3:50 am
Viewing 15 posts - 8,206 through 8,220 (of 9,713 total)