Viewing 15 posts - 30,226 through 30,240 (of 39,763 total)
Mirroring is at the database level, so you'd need the Database Master Key, not the Service Master.
December 17, 2007 at 10:52 am
It's cut off in the searches, and I agree. It's annoying. It is in the title of the browser if you open it and it's also in the forum view...
December 17, 2007 at 10:52 am
Search is so-so, but it's there for you to find things. We use Google search, so their hints will work here.
The "Active Threads" on the left menu shows you threads...
December 17, 2007 at 10:48 am
I agree with Gail and I might break these out to a few separate traces (object changes v access) to deal with the data.
Be sure you have a good...
December 17, 2007 at 9:01 am
Are you upgrading to SQL 2005? There is an upgrade advisor you can run to help with this.
The database size is large, TBs of data, so I'm not sure that's...
December 17, 2007 at 8:59 am
Please don't cross post. This is being answered here: http://www.sqlservercentral.com/Forums/Topic433813-338-1.aspx
December 17, 2007 at 8:57 am
December 17, 2007 at 8:55 am
Very interesting, and I have ideas, but they're probably ones you've thought of and since I don't have any direct experience with something this scale in 2005, I hope someone...
December 17, 2007 at 8:54 am
Yes, use the ATTACH_REBUILD_LOG option (look it up to be sure I'm write) with the attach command.
December 17, 2007 at 8:48 am
Or just the first part as a test.
December 17, 2007 at 8:47 am
So is a spare fuel bucket in the back now an "open container" 😉
December 17, 2007 at 8:46 am
It's all multiple choice, so you don't have to write syntax from memory, but you do need to be able to recognize what a statement is doing.
I believe you...
December 17, 2007 at 8:35 am
First you need to post in the appropriate forum to get a response. This isn't a DTS issue. I'll move to the 2000 forums.
Second, not sure what is wrong here....
December 17, 2007 at 8:33 am
First, using SA and a blank password is asking for trouble. Even for testing, set up a real login and user with rights to the table.
Second, it's asking for a...
December 17, 2007 at 8:30 am
Good points, though I guess you could do what many people do and put in 2 columns in pictures and join one to either table. You'd be wasting a column,...
December 17, 2007 at 8:28 am
Viewing 15 posts - 30,226 through 30,240 (of 39,763 total)