Viewing 15 posts - 16,066 through 16,080 (of 39,824 total)
In that case, if someone mucked with system tables, you probably have the right approach. I might suggest the bcp method, which has worked well for me.
I would script out...
May 13, 2011 at 9:28 am
You should restore the full, then try log 1, then try log 2. It may not need log 1, but SQL will let you know. No harm done in trying.
Actually,...
May 13, 2011 at 9:08 am
Hugo Kornelis (5/13/2011)
In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the site thinks I am wrong, because both...
May 13, 2011 at 8:57 am
I'm a little confused. If you know what permissions are needed, can you not just add them to the existing database? You'll need to add them to the new database...
May 13, 2011 at 8:54 am
Brandie Tarvin (5/13/2011)
Why am I not surprised over the quibbling on the QOTD?I really wasn't trying to trick anyone. Honest.
I have to admit the "can" threw me when I...
May 13, 2011 at 8:50 am
OK, I went back and forth on "can" myself. I ended up leaving it, but I can see that it in fact may (no pun) have created more confusion.
So,...
May 13, 2011 at 8:42 am
Short answer, natively, no. You cannot restore with less than the size that existed for the data and log files at the time of the backup.
There are third party solutions,...
May 12, 2011 at 10:54 am
LOL, feels like it's a few months late. It's May 12, and while we've had snow in Mar (and June), we've never had a blizzard. This is the biggest storm...
May 12, 2011 at 9:34 am
deanroush (5/12/2011)
May 12, 2011 at 9:24 am
Glad you liked the question. Easy question if you know the min issue, otherwise, hope you learned something.
May 12, 2011 at 9:22 am
Alan Vogan (5/12/2011)
In SQL Server, we can't split a table across filegroups. Or can we?
I was just asked that question! The idea that was being tossed around was...
May 12, 2011 at 9:21 am
So it's a snow day here, kids off from school. I've already fired up the tractor, been up and down the driveway twice to plow out and the road once,...
May 12, 2011 at 9:19 am
SQL Server has no knowledge of IE, so don't get caught up there. Whether you are connecting from a C# Windows Form app, WPF, Silverlght, etc., you are making a...
May 12, 2011 at 9:13 am
I'm still not clear on what is happening in the Citrix environment and what is the concurrency setup.
Can you run a Profiler trace when you get back to this tomorrow...
May 11, 2011 at 4:49 pm
You could store something like this in the registry for each user, under their own key structure.
In terms of being separate for each user of a PC (multiple possible users),...
May 11, 2011 at 2:52 pm
Viewing 15 posts - 16,066 through 16,080 (of 39,824 total)