Viewing 15 posts - 8,206 through 8,220 (of 9,720 total)
And if this sort of thing will happen more than once, consider storing your .mdf and .ldf names in a table on a database that doesn't tend to get moved....
November 18, 2009 at 1:14 pm
Sorry, GSquared. I have an anti-ditto (of a sort) to your list.
RE: Indexing. Yes, index. But don't OVER index.
Pet Peeve = developers add an index to an existing table just...
November 18, 2009 at 8:49 am
Ah, I misunderstood your post.
Good luck with the battle.
November 5, 2009 at 7:44 am
If you're the network tech, why are you responsible for the log shipping? I would think that it (and testing backup software) would be the responsibility of the DBA team.
Unless...
November 5, 2009 at 7:01 am
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
Viewing 15 posts - 8,206 through 8,220 (of 9,720 total)