Thanks,

You are right- Goggle search for SNAC returned a lot of funny stuff.

We actually used probably something similar- Sql Server Native Client OLEDB provider-

simply add "Failover_Partner" (for mirror DB) keyword...

If you need to switch partition to another table (e.g. move data to archive) keep in mind that source and target tables should be in the same filegroup. That means...

Gail,

Just curious, what does SNAC stand for?

Thanks,

Just to confirm what Steve said- as per MS:

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

"A passive server does not need a license if the number of processors in the passive server is equal to or less...

Thanks Leo,

It seems I can not avoid shrinking

I am afraid there is no option ( I certainly can be wrong) in restore statement (I just double checked BOL) that allows you retrieving free space during DB restoring....

Sorry I did not get what "session" means?

First, table 350 GB size was truncated, then using RedGate Sql Backup I made backup (around 50 GB size), then using RedGate...

Sorry, probably was not clear.

After shrink and backup/restore I certainly got 50 GB DB

(as 350 GB unallocated space gone during shrink).

I am wondering why before shrink backup file with size...

It seems I found already answer-

besides editing noiseENU.text file in sql server directory another file should be edited- noise.enu in windows/system32. And it works. :-)Thanks

You are absolutely right-

while configuring System DSN do not check "Disable Transaction Support" under Flag 3.

Thanks a lot 🙂

Yep, probably we can find some way around but still I would like to find the reason for Update/Insert failure while Select works fine. Thanks for response, Andy

Great thread- helped me to create linked server (mysql 5.1 to Sql Server 2005 64 bit Enterprise),

thanks. I mean select data from mySql (request from sql server) works like a...

Bartek,

I followed the way Nick explained in his message.

Additionally 1) I added new table with product (or customer) color map; 2) created function to convert rgb color to hex (SSRS...

Thanks, Steve.

I know that one can restore 2005 backup to 2008 (but not opposite?)

but my main concern was regarding different Editions, I mean Standard to Web

(as I know for Mirroring...

Dave,

As you pointed you have " a hot stand-by server that has all of my mirrored dbs", that means your server should have Standard or Enterprise Edition installed, i.e. you...