i needed to play with data.

Declare @tbl table ( main_text nvarchar(200), Without_Roman_values nvarchar(100),Roman_values nvarchar(50) )

insert into @tbl (main_text)

select 'BHUVH III'

union

SELECT 'DEXY V'

UNION

SELECT 'JACK TONY VIII'

update @tbl

set Without_Roman_values = reverse(substring(reverse(main_text),charindex('...

Try this SELECT [Transaction Id], [Begin Time], [UID], [SPID]

FROM ::fn_dblog (NULL, NULL)

WHERE [Transaction Name] = 'DROPOBJ'GO

above code can give you spid of user who dropped that

and then use...

Very few people from INDIA(Asia).:sick:

Did it get resolve ?

NO idea about that message

This link might help you http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.utility/html/utility/utility73.htm

Instead of using -n (native) datatype...

Always try to post exact error to get faster response :-).also post BCP query

yes it happened because of SP1 i think MS has fixed this bug iin SP2.

refer these links

http://www.windows-tech.info/15/4b5bdaab8e755fbe.php

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15824.aspx

http://dbaspot.com/forums/sqlserver-programming/350238-sql2005-sql-agent-error.html

Restore your database

Are you using Physical box only for sql server ? then you can go for MAX option but if not then i think it might not be a good idea...

Sorry i forgot to considered alias 😀 or something...

what would be the result when ID = 2 ?

first of all we...

Anamika (3/29/2010)

---

EXPECTED OUTPUT.

When i query on id 1 i should get

LEVEL1 2,3

LEVEL2 4,5

LEVEL3 ...

Can you post required columns for staffno for 1234 so that i can get rough idea/hint ?