This means you already have...

When you use an IP address instead of the server name, SQLNCLI assumes TCP/IP is enabled.

Is there any particular reason why you're using Named Pipes and not TCP/IP?

PaulB-TheOneAndOnly (12/29/2011)

---

How about using coalesce?

create table #test(id decimal);

insert into #test values(1);

insert into #test values(2);

insert into #test values(3);

insert into #test values(4);

insert into #test values(5);

insert into #test values(6);

insert...

I'm officially confused. :ermm:

Time for a break.

You could set up a policy and raise an alert when the configuration changes. You can even prevent the change at all.

Duplicate post.

Replies here please:

http://www.sqlservercentral.com/Forums/FindPost1228255.aspx

DECLARE @abc TABLE

(

SerialNumber varchar (50)

)

insert into @abc (SerialNumber)values ('12345 0047225P1')

insert into @abc (SerialNumber)values ('00011 0055500ABC2')

SELECT

SUBSTRING(SerialNumber, PATINDEX('% %', SerialNumber) + 1, PATINDEX('%[^0-9][0-9]', SerialNumber) - PATINDEX('% %', SerialNumber) -...

I guess you will have to ask that to somebody who knows the business logic.

I...

That would be the best way. Talk to your admins, I'm sure you can set up something sensible.

After completion how can I disconnect...

mario.balatellii (12/30/2011)

---

create table abc

(

SerialNumber varchar (50)

)

insert into abc (SerialNumber)values ('12345 0047225P1')

insert into abc (SerialNumber)values ('00011 0055500ABC')

I am expecting a table with once column name account number and the result like...

NET USE X: \\servername\sharename password /USER:domainname\username

You mean TDE? No way. SQL Server handles that for you.

Any other kind of encryption is managed by the applications. Find the app that encryped the data...

You're not telling much about your data.

Can you post the table script, some sample data and the expected results based on the sample data?

Also, what makes P the letter in...

You would have to issue a NET USE command for the SQL Server service account.

Ugly and unreliable. Are you sure you don't have other options?

Michael Valentine Jones (12/29/2011)

---

Gianluca Sartori (12/28/2011)

---

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned,...