Whenever you face this kind of problem , re-login into it.

It means you...

Set Statistics IO ON

exec your Sp

Set Statistics IO OFF

in which column you have UNIQUE index ?

Thanks a lot.

below link help me

http://support.microsoft.com/kb/918992/

one thing i noticed that it encode the password in hexadecimal codes

while the normal script out method encode it in "unreadable" characters.

CREATE LOGIN [MyLogin] WITH PASSWORD=N'ól?¨?&²??Ç[WÆ?$R¬sjµDúöÚ+pÇ', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

ALTER LOGIN [MyLogin] DISABLE

i just created a login in one server and pushed it in another

and when i try to...

can you do a test for me ?. just create a sql auth. login in one instance and migrate it to another one and then try to login with...

Refresh means resetting the password with same characters.

Here i am talking about sql...

DECLARE MC CURSOR READ_ONLY FOR

SELECT [Str]FROM #Windows_Auth_Orphan_User

OPEN MC

FETCH NEXT FROM MC INTO @cmd

WHILE (@@fetch_status <> -1)

BEGIN

IF (@@fetch_status <> -2)

BEGIN TRY

PRINT @cmd

Execute (@cmd)

END...

One questions, is this problem occuring from last couple of days or earlier was it running...

There are chances that tables from that database involve in busy/heavy transactions.

Greg Edwards-268690 (3/3/2010)

---

I'd think it would be safer to script out the permissions for the old account, then modify for the new account and run, and then after testing, delete...

yes Grant is right.

Execution plan will give clear picture.

can you post table schema and execution plan?

Hunterwood (3/2/2010)

---

Here is one way to solve the problem:

declare @str varchar(200)

set @str = 'Apple, Banana,Orange, Pinapple, Lemon'

declare @result table (string varchar(100))

declare @start int

declare @end int

set @start = 1

set @end =...