Another possible solution is a CLR stored procedures that instanciates a connection without enlisting in the current DTC context.

Paul White has a nice blog post on the subject here. Look...

Might be worth noting that heterogeneous replication is an Enterprise-only feature, so be prepared to spend big bucks.

I suppose...

-- READ SYNONYMS FROM DATABASE 'C'

DECLARE @DATABASENAME sysname;

DECLARE @sql NVARCHAR(max);

SET @DATABASENAME = 'C'

SET @sql = N'

SELECT ''CREATE SYNONYM '' + b.NAME + ''.'' + a.NAME + '' FOR '' +...

I checked my SSMS 2014 and I don't have that font.

I think that only "modern" fonts (truetype and cleartype) are in the list and only a small subset of "legacy"...

In Reporting Services you have subscriptions for that.

Here's a quick how-to video: http://technet.microsoft.com/en-us/sqlserver/dd420576.aspx

kiran.rajenimbalkar (5/9/2014)

---

First SQL that u provided me yesterdy it was creating the synonym script then I have to execute that synonym script in the perticular database.

Just provide me how to...

You will have a set of statements to execute, then you need a cursor to iterate them and execute one at a time.

DECLARE @DATABASENAME sysname;

DECLARE @sql NVARCHAR(max);

SET @DATABASENAME = 'master'

SET...

Try something like this:

select COUNT(*) AS Cars,

SUM(CASE WHEN Color = 'Blue' THEN 1 ELSE 0 END) AS Cars_Blue,

SUM(CASE WHEN Color = 'Red'...

Nope. I was referring to a post that Steve deleted today.

It contained a...

Use dynamic sql.

It won't work: the synonyms are already there.

Where do you want to create them? A different database? A different server?

Weird. Can you post the code?

The creation of the linked server fails for some reason.

You didn't post the actual error message, so it's nearly impossible to give sensible advice.

Don't use maintenance plans. Index maintenance and integrity checks are performed in an unreasonable way.

Use Ola Hallengren's maintenance solution instead.