I'd agree with what's listed above. The mirror database is not accessible while mirroring is running.

I still think that disclosing more is better. Everyone will likely have some security issues, and filing them, along with some details, brings some knowledge that others can use. Especially...

I do tend to get permission, or more often, notify someone that I am planning a change. If for nothing else, if I make a mistake, I want to ensure...

I agree! 😀

The backup file isn't changed. What happens when you do the restore is that the mdf/ldf/ndf are created as sparse files. All reads from these files are redirected to the...

I've turned the kids onto chorizo here, and that's supplanted bacon most of the time.

I found this one, but only in L. I need a XXL.

http://compare.ebay.com/like/220414998857?ltyp=AllFixedPriceItemTypes&rvr_id=122730417474&crlp=1_263602_263632&UA=%3F*F%3F&GUID=60410c241280a02652f10851ffc94969&itemid=220414998857&ff4=263602_263632

Apologies to anyone that feels I crossed the line into too much advertising. I was asked to write something on this product, and I think I failed to editorialize on...

The same functionality, AFAIK, continues in SQL 2008. If you have those fields and insert too much data, it gets truncated.

We understand your situation. I think most of us have...

You need to write some code.

Query sys.server_principals for users, write a loop or cursor with the results, build an ALTER LOGIN script from there.

http://msdn.microsoft.com/en-us/library/ms188786%28v=SQL.100%29.aspx

I'm not sure what you mean. 10 varchar(2000) in one table still wouldn't have more than 8k in the row since that's a 2000 limitation. You can convert to varchar(max)...

If this is a one time thing, or rare thing, you could use the data import wizard in SQL Server to do it. Otherwise, I agree with Paul's advice. Openquery...

One more thing on the iPad/iPhone. There are quite a few libraries doing electronic lending of materials. Mine uses the Overdrive Media Console, which registers to my account. I can...

Yes, sorted in that order. The data is stored like that on pages.

Note that page splits happen all the time, updates cause them when the new values don't fit on...

Brandie Tarvin (8/10/2010)

jcrawf02 (8/9/2010)

I think one of those has...