Eric M Russell (3/20/2016)

---

The only users who automatically have access to all databases are members of the SYSADMIN role. For non-sysadmin users, you must create their account in a database....

What else is going on with the database? Replication? Log Shipping? AlwaysOn?

The sledgehammer approach is to try changing to SIMPLE recovery but that could create a ton of work for...

They are going after the Oracle on Linux market...smart.

http://www.itwire.com/opinion-and-analysis/open-sauce/71927-why-microsoft-is-porting-sql-server-to-linux.html

Hi Boris, Thanks for the kind feedback.

I would like to help but must admit that I am woefully ill-equipped to write VB.net code these days. I am sorry but...

Ed Wagner (3/8/2016)

---

Orlando Colamatteo (3/8/2016)

---

Re: sp_change_users_login, from the Books Online article:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

Wow. That seems analog to washing and vacuuming a car, never changing the oil...

Re: sp_change_users_login, from the Books Online article:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to...

First Bing result took me to SO

http://stackoverflow.com/questions/21774545/ssis-using-parameters-in-oracle-query-using-attunity-oracle-datasource

then to this nice blog about Data Flow source, but the same approach applies

http://sornanara.blogspot.com/2013/11/ssis-use-dynamic-sql-in-oracle-source.html

You're welcome. Thanks for the feedback.

dndaughtery (3/4/2016)

---

Hey guys, can someone point me in the right direction on how to create a sql command in an ssis variable and pass that into an Attunity Oracle data...

Sort of off-topic but I love the way Microsoft develops their...

niladri.primalink (3/4/2016)

---

Hi Thanks for your reply...

It is absolutely the same I am looking for. Thanks a lot. I will update the table from cte. Is there any chance to delete...

drew.allen (3/4/2016)

---

I'm very cautious about automatically updating records like this, because there is so much variation for entering the same information. For instance, addresses with apartment numbers. If...

A word of caution, this query will not perform well over large datasets. Your data needs to be processed in a partitioned fashion (by OfficerID, FirstName and LastName) and then...

In SSMS on Server1 try connecting to these and let us know:

Server2,1433

Server2,49156

Server2,49162