Sorry, I can't figure out what your question is?

That sure doesn't look like an error..?

I suspect that this has more to do with the client settings than the server's.

Try it like this:

WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')

SELECT

DB_NAME(qp.dbid) as 'database_name'

,REPLACE(SUBSTRING(st.text, PATINDEX('%CREATE %PROCEDURE%', st.text), 100), CHAR(13) + CHAR(10), ' ') 'Stored Procedure Name'

,REPLACE(

SUBSTRING(

st.text

,(qs.statement_start_offset/2) + 1

,((case qs.statement_end_offset when -1 then datalength(text)...

I am not sure that we can help you very much without more details or a more concrete example/question.

I can say however that in general, SQL Server does not push...

My guess would be that it has to do with security issues and configuration.

What industry are you coming from? Did they have DW templates there? I ask only because I have seen very few DW templates and I would be very...

Really?

"Here's 120+ lines of SQL. What happens if there's an error on Line #45?"

Brutal. Seriously.

Methew (5/21/2012)

.DAT files can only be opened by the application that created them. There is no indication which application created the file and there is no need to open .DAT...

I'm not sure, but I think that that message is complaining about not being able to load the driver/provider required by the connection string and/or the source file. Since...

Are there any other SQL Server instances on these two servers? Is it possible that you are actually connecting (or trying) to one of them and that SQL instance...

It's in the Client Tools SDK. This link explains how to install it: HERE

Formatting:

declare @Sectionid int=1984

DECLARE @Assessments nvarchar(max), @Total nvarchar(max)

SELECT @Assessments =

STUFF(

(

...

Not my point. My point is that you should include the rules to your game with the...

RBarryYoung (5/21/2012)

Windows has a software firewall built into the OS. You need to check that on the Server that is running your SQL Server...