Viewing 15 posts - 1,291 through 1,305 (of 1,583 total)
One more thought: while I am redoing this for the broken DB, should I blow away the current log shipping setup for the database? If I don't the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 10:43 am
Thanks for the replies everyone...this is what I thought :crazy:
So I'll have to copy up and then restore the latest full backup to the secondary server (which will take about...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 10:40 am
Yes there is ample space.
That's what I was afraid of...having to restore from a full backup and basically starting over with logshipping from that database...can I restore just...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 10:03 am
I'm with Jared. Clearly a permissions problem but am out of ideas :crazy:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 1, 2011 at 1:03 pm
Wow....4 posts hit this before I was able to post mine...I must be typing too slowly today!!!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 1, 2011 at 10:30 am
You shouldn't change the size of your LDF files. Typically you set your LDF file to a specific size to begin with to allow for rapid/sudden data movements/transactions and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 1, 2011 at 10:29 am
It depends.
Normalization is one of those things you want to have in a RDMS but can be its design can overkill if you don't anticipate or you know for certain...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 1, 2011 at 9:48 am
No..I am not able to access any linked server unless I create the linked server connection directly on sql server installed on my laptop.
I am getting a little confused....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 1, 2011 at 9:35 am
Lowell, I have no doubt that the origination of the SQL I posted was derived from this website 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 2:35 pm
Where WHILE loops benefit the most over cursors is being able process a batch of records in each iteration versus cursors only allowing one record per iteration. But since the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 2:33 pm
Awesome, glad I was able to help. The HTML output is nice for audits too 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 1:56 pm
Sorry if I asked this already...but what's the version of your laptop SQL running? And are all 3 OS's 32-bit? I don't suppose your laptop is running 64-bit is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 1:36 pm
Try this link
In the first article you should see a list of all the current DMV's broken down by category
All joking aside, you can use this TSQL (snagged from my...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 1:34 pm
What is best to rewrite the below query instead of using temp table or cursors
Do you have specific concerns with using the temp tables? Or are you seeing some...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 1:10 pm
Really? I have linked servers set up with users that do not exist on the source server. Isn't the source simply passing whatever credentials you tell it to?
I didn't phrase...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 12:55 pm
Viewing 15 posts - 1,291 through 1,305 (of 1,583 total)