vishal.gamji (8/18/2010)

---

Have you stored procedure (that lists the drop down values) take a default value of 'ALL' and when the input is default 'ALL' it should return everything. Configure your...

Vincy-856784 (8/10/2010)

---

Do you have Mixed Security Mode enabled or just SQL Security Mode?

If you have mixed mode and you're the Administrator (windows) for that server then you don't...

Adiga (8/10/2010)

---

I hope you have the logon credentials of the SQL Server Service Account. If the service account has interactive logon privilges, logon to the server with the Service Account...

I think I have missed this link......Thanks A Lot for your help, now I am able to decrypt the views.

Henry Treftz (7/28/2010)

---

There are some scripts out there that claim to do it as well as at least one third party application.

Do a google search on

decrypt sql 2005 stored...

You Need to run Below commands after renaming the Server B to Server A

sp_dropserver 'ServerB'

sp_addserver 'ServerA’, 'local'

select @@servername

Chris Morris-439714 (7/26/2010)

---

-- create sample data

DROP TABLE #Sample

CREATE TABLE #Sample ([Instance name] varchar(60), [Verified Name] varchar(60))

INSERT INTO #Sample ([Instance name], [Verified Name])

SELECT 'USMKESQLPRD001\SQL001', NULL UNION ALL

SELECT NULL, '' UNION ALL...

Wrong one

Sorry...not null values its showing no values.

ColdCoffee (7/26/2010)

---

Dint this work for you?

Select instancename,verifiedname from table where instancename is not null and verifiedname is not null

As it seems as simple, i guess i am missing something.....

Below is the Original result:

Instance name Verified Name

USMKESQLPRD001\SQL001 ...

Can any Body please help me in this ?

Your help much appriciated....

Animal Magic (7/20/2010)

---

create table testcharindex

(Name varchar(50),

HasSpace bit default(0)

)

insert into testcharindex (Name)

select 'Morris'

union

select 'Taylor'

union

select 'Two names'

union all

select 'Taylor ' -- Notice the trailing space

select * from testcharindex

--not using trim

update testcharindex

set...

Can you please provide me the sample script for it ?

Thanks for the response...at last i got a response..

🙂