what does your connection string look like?

are you putting servername-comma-port in the connection string? i know it's common for people to use a semicolon by mistake.

for example

Private Const...

uggh; looks like you are doing something in a trigger(inserting/updating into another server?) that should be done in a service broker, or a schedule job that would do...

I'd blame the application that might be inserting rows into the table; chances are the code is inserting a default of zero from the application, which is outside of the...

not sure about the trigger being what you want to do or not...

it should be an instead of trigger and not a FOR/AFTER trigger, i think

a float cannot have an...

jpomfret7 (2/13/2013)

---

Good Morning all,

I'm looking for a tool that would allow me to group objects together and assign permissions based on those groups. Such as Joe gets rights to all...

I'd go with the powershell as well, but here's one more alternative:

I've used SQLRecon in the past, which is free and did the job for me, but was last...

side note to mister.magoo: which SSMS add on is that that lets you group totals from the results grid?

CTE with variables? sure, it's just like any other SELECT statement WHERE SomeColumn = @Param is certainly valid; just declare the variables before teh CTE, adn make sure you end...

newbieuser (2/12/2013)

---

Thanks a lot Lowell. CTE works perfect. This sql is run within a loop in a program and it is causing performance issue.. I have created a topic(Remote Query...

UT excellent job with the DDL and sample data;

does this give you the results you are looking for?

SELECT

ID,

TTYpe,

TTime,

COALESCE(NULLIF(TFunction, ''), TStatus) AS...

bah the above won't work because of the local table.

divide and conquer is what you'll need to do i think.

i would try to use a CTE that gets just the...

amybe...but the problem with open query is your command has to be a static string...no variable, or concatenation of stirngs plus variables are allowed.

how would this worl for you:

SELECT *...

at least viewing the estimated execution plan would give you a ballpark number;

it works for me fine when i use

EXEC(@ViewStr)

--or

EXEC sp_ExecuteSQL @Statement = @ViewStr

I don't think you need the parameters in the EXEC anyway;

the string passed doesn't have...

i believe that unless you have started your instance with trace flag 1807, the server can only attach databases that exist on local, and not network storage.

the trace flag is...