Viewing 15 posts - 18,016 through 18,030 (of 22,214 total)
Nuts. I might have been premature in posting to Connect. I finally found another reference:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351548&wa=wsignin1.0
I'm testing removing the certificate now.
March 13, 2009 at 8:20 am
I posted it to Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=423249
You can vote on it, set the priority, add your comments, especially since this is your issue.
I'm going to keep hacking at it as time allows.
March 13, 2009 at 8:14 am
I hit the same issue. I went back to retest and now I'm hitting the issue on the test database, where I didn't hit it before...
I'm trying to track down...
March 13, 2009 at 7:59 am
I think that's a torn page error. Try running a consistency check on the source db.
March 12, 2009 at 5:27 pm
Bob Hovious (3/12/2009)
Congratulations, Gail 🙂 And congratulations also for being Geek of the Week.http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/
Yeah, congrats.
I confess I saw a tweet from someone over there...
March 12, 2009 at 5:20 pm
Lynn Pettis (3/12/2009)
GilaMonster (3/12/2009)
Lynn Pettis (3/12/2009)
I have to agree as well. I'd love to get Babylon 5 on DVD.http://www.amazon.com/Babylon-5-Complete-Television-5-Pack/dp/B0001M3MXY/
I just sent "she who must be obeyed" the link you...
March 12, 2009 at 5:18 pm
GilaMonster (3/12/2009)
Alvin Ramard (3/12/2009)
Did you notice that was the OP's first post?
Yup. It factored into my decision to 'challenge' him. I'm curious how he's going to reply.
Rule 1...
March 12, 2009 at 5:17 pm
GilaMonster (3/12/2009)
Bob Hovious (3/12/2009)
I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.
It's available on...
March 12, 2009 at 5:15 pm
Yep. Just did. Works great. Turn on encryption on one machine, including setting a certificate and enabling it on the database. I ran a backup from there that was encrypted....
March 12, 2009 at 11:03 am
You want to use the datepart function. You can look it up in BOL for all the permutations, but it basically works like this:
SELECT DATENAME(yyyy,'3/12/2009') AS 'Year'
March 12, 2009 at 9:24 am
MS says that less than 1000 pages defragging won't help... that might be true, but if it's less than 8 pages, you can't defrag at all. Setting a fragmentation percentage...
March 12, 2009 at 9:21 am
The structure and the query are the driving factors. You've got an open-ended query with no well defined WHERE clause, so it's going to be hard to index it properly,...
March 12, 2009 at 6:05 am
dmoldovan (3/12/2009)
Grant Fritchey (3/12/2009)
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
Is this true...
March 12, 2009 at 6:00 am
This seems to work. Set it to off, backup the database with a new backup and you should be able to restore to another server without the need for certificates.
ALTER...
March 12, 2009 at 5:42 am
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
March 12, 2009 at 5:37 am
Viewing 15 posts - 18,016 through 18,030 (of 22,214 total)