When you use a Linked Server in a trigger you're starting a transaction on the remote server within the context of an already running transaction in the local server...which requires...

Please post DDL, DML to create sample data, expected results and what you have tried so far.

get-SqlServerList returns the instance name as part of the results. All I see you need to do is connect to each instance returned by that call and select the Edition...

sravnmaganti (7/5/2011)

---

can any one explian why i am getting this error..........

Package Validation Error (Package Validation Error)

===================================

Error at Data Flow Task [OLE DB Destination [5779]]: Column "creation_tm" cannot convert between unicode...

Why?

You could put the call to your SSIS package in a SQL...

As an alternative for you and others dropping by you can also fully qualify your proc reference like this:

SET @DUMMY = 'EXEC ' + @DB_Name + '.sys.sp_grantdbaccess ' +

...

You can use this when assigning the value to the column in your UPDATE statement:

destination_column_name = CAST(source_column_name as XML)

It's risky to run with the default SQL Server max memory setting (unlimited). Please have a look at this article: http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

Yes, but I am not sure what WC is referring to. I can't make a connection as...

Query from original post reformatted:

SELECT TOP 1

h.Invoice_id AS Invoice_Id,

h.IssueDate AS [Invoice Date],

h.Optional_1 AS [Division Buyer],

...

Please post DDL, DML to create sample data, expected results and what you have tried so far.

SQLkiwi (7/5/2011)

---

Just so we're all clear on this, I'm interested in how you justify things like attending the summit to the person paying. I have heard of some people...

beejug1983 (7/5/2011)

---

This stored procedure will fix the orphaned users, if i am not wrong but what about the permissions and rights of those database users which were on production and...

I can't help thinking about how this query might have been faster on the old hardware given the same plan (can you confirm the plan looked the same on the...

Ninja's_RGR'us (7/5/2011)

---

Gianluca Sartori (7/5/2011)

---

Ninja's_RGR'us (7/5/2011)

---

Gianluca Sartori (7/5/2011)

---

Looks like an estimated plan...

However 4 MLN rows from both tables is a huge load. I suspect it would run much better with a...