You could query the remote registry for the instance names:

reg query "\\SERVERNAME\HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL"

If you need to find the ports the services are listening on...

reg query "\\SERVERNAME\HKLM\SOFTWARE\Microsoft\Microsoft SQL Server"...

Hey, come on it's not the DBAs or the Programmers that are the problem, it's the Project Managers that we should be worried about, those good for nothing....:-D:-P:w00t:

I am glad...

You may need to install the new ODBC drivers for SQL 2012 from http://www.microsoft.com/en-gb/download/details.aspx?id=36434

It will install a new ODBC driver called "ODBC Driver 11 For SQL Server" which you could...

Hi,

You can use an expression on the "Format" property of the text box:

= IIf(Fields!Proposal.Value>1,"F0","F2")

The numeric part of the format code is how many decimal places to include.

See here for more...

Jeff Moden (12/17/2013)

---

mister.magoo (12/17/2013)

---

Good day Threadizens 🙂

I have written an article (my first) on how to get help with SSRS reports.

It was inspired by Jeff's classic "Forum Etiquette: How to...

thomashohner (12/17/2013)

---

Thank you so very much, I also imagine that performance will suffer some and I will try to work on that. Luckily this wont be run often, more of...

jeganbenitto.francis (12/16/2013)

---

Thanks MM!!..

This works fine... But only problem is ,xml is just a column in my table.

Can you please tel me how can a i create a function for this...

That should catch the error happening, but it's not going to pass an error on to SSIS unless you specifically return an error code and handle that - wouldn't...

Good day Threadizens 🙂

I have written an article (my first) on how to get help with SSRS reports.

It was inspired by Jeff's classic "Forum Etiquette: How to post data/code on...

declare @xml xml = '<CountCheck>

<CT U="346" E="123" />

<CT U="345" E="123" />

<CT U="456" E="123" />

</CountCheck>'

declare @e_value int;

set @e_value = 123;

select nd.value('@U','int')

from @xml.nodes('/CountCheck/CT[@E=sql:variable("@e_value")][last()]') x(nd)

The reason you are not getting the program flow you want is because this statement happens after the error but before you check for an error:

INSERT INTO @T

...

Thanks for updating us with the actual location, always nice when that...

I don't ever...

That is not what I said and it...

mqy37 (12/14/2013)

---

Hi, please somebody help me with this store procedure. I am very confused. This is a CLR stored proc. I understand the basic is using a vb 'RODAssembly'. But...