Thanks for the feedback!

Here's a tool for this job: https://scriptsqlconfig.codeplex.com/

BTW, it can script more than just linked servers.

Always On is a commercial name for a set of High Availability features that include Failover Cluster Instances and Availability Groups.

The main difference is that a clustered instance has the...

Great catch!

What do you mean "trim is not happening"? Do you still see the whitespace chars? Are you sure it's a whitespace? It could be any other non-representable char: check what...

Yes, log shipping requires a copy of the whole database and cannot be filtered.

Back to replication, with "readonly" you mean that you set "Synchronization direction" to "Download-only to Subscriber, prohibit...

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1679290.aspx

Jeffery Williams (4/22/2015)

---

spaghettidba

ARE YOU KIDDING ME RIGHT NOW??? Dude if you were here I would hug you and give you a big sloppy kiss (glad your not here)..

It worked!!! ...

Alternative method:

DECLARE @AlterSQL nvarchar(4000)

SET @AlterSQL = 'EXEC ' + QUOTENAME(@DestinationServerName) + '.' + QUOTENAME(@DestinationDBName) +'.sys.sp_executesql N'' ALTER TABLE '

+ QUOTENAME(@DestinationSchemaName) + '.' + QUOTENAME(@DestinationTableName) + ' ADD ' +...

Jeffery Williams (4/22/2015)

---

This did not work or I don't know the context in which to use it.

I am setting the statement to a variable. then executing that variable.

Example:

DECLARE ...

Actually, to run in the context of a particular database, you can issue:

EXEC MyDatabase.sys.sp_executesql 'MyCommand'

You need something to differenciate the MAX and MIN row in some way. I added a column to show which aggregate is used.

Your sample data in a consumable way:

DECLARE @sampleData...

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1679271.aspx

Try this:

EXEC ('ALTER TABLE Node ADD ImportIdentity int') AT LinkedServerName

Ok, thanks, much clearer now.

You could use log shipping with standby[/url] to create a redonly copy at the reporting site. Would this work for you?