How to: Create a Publication and Define Articles (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms151160.aspx

How to: Create an Updatable Subscription to a Transactional Publication (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms152769.aspx

Its festival time & most of the members are on vacation. Please have patience. They will revert to you soon.

You can use following with 2 Cautions:

•OPENROWSET / OPENDATASOURCE can be used to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is explicitly...

Please alter your PK index.

IGNORE_DUP_KEY = { ON | OFF }

Specifies the error response when an insert operation attempts to insert duplicate key values into a unique index. The...

Didn’t get you. Please elaborate the term ‘Documentation’.

Please verify your steps with following.

Performing File Restores (Full Recovery Model)

http://msdn.microsoft.com/en-us/library/ms190710.aspx

So, I attempt to restore the older filegroups and at the same time I want to have the transaction that...

Using sp_executesql

http://msdn.microsoft.com/en-us/library/ms175170.aspx

sp_executesql (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188001.aspx

Please notice ‘Step 11 - Accessing the Encrypted Data’ in the article given below.

A user need to have permission to symmetric key and certificate to decrypt data, if they still...

Nice Article Greg!

I think it would be good if you quote it as a bad practice for ‘Sorting Data based on Column Ordinal Position’. I understand you just wanted to...

Santa is searching for his reindeer...

Try following...

CONVERT(nvarchar, DecryptByKey(@caseid)) AS test

For More: http://msdn.microsoft.com/en-us/library/ms181860.aspx

This is SQL Server Forum. For your requirements we might come with some solution but its applicability to Oracle is doubtful.

Please post your question in Oracle forum.

Transaction Log mismanagement could be a reason but I won’t jump on that unless I am confident that ETL code is optimized. Most of the times bad code is the...

Saggy (12/25/2011)

---

Hi Guys.......

1. What is statistics and how to see statistics through command ?

Also how to update statistics and when to update statistics also let me know if...

dfrome (12/25/2011)

---

The date's aren't unique, if the datapoint is minute data, then it's possible to have 65 (or more) dates in an hour, a 1 hour (00:00), 4 15min (with...