ok fine, i created some sample data and table

if object_id('dataset') is not null drop table dataset

create table dataset( file_no int , fromD int , toD int)

insert into dataset

select 101, 1101,...

Hi sir,

Please post some sample data along with schema as given in the following Jeff's post

http://www.sqlservercentral.com/articles/Best+Practices/61537/

That would help us a lot..

Guyz any updates on this?? do u guys needs more info on the error, i can give..

select * from sys.syslanguages where langid = @@langid

nice question sir

@Grant, even i faced similar result as results... when i run the code as a step in sql server agent, i am not getting the error **AT TIMES**... but when...

I guess u did not look up at the "Messages" tab in the Results Pane..

For those intending to get...

Thanks guys for ur quick reply.. but i get the following error code when i tried running the query

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC...

Thanks vyas for the reply.

My DAT file is very huge. Contians more than 5 million rows. So do u think i can import whole of the data into that one...

@Imu92, thats what i suggested as a fix, but as it is involving a lot of changes in a lot of changes, we are reluctanct on that!

@Gail, as u said,...

THanks for the replies guyz.

I already thought of doing the checking the table count, as chiragNS said, but the catch is Process 1 deals with 10 tables and PRocess 2...

Can u pls specify what u mean by "move"?? do u want to create all of the SPs present in DEV machine to the PROD machine??

oh thanks so much Steve.. but the FileListOnly gives a huge number of columns.. i need only the physical and logical file names..can i get it alone?

Try this one!

DECLARE @WORD VARCHAR(500)

SET @WORD = 'ss.t@test.com, a.b.ssl@test.com,ss.t@test.com, s.m@test.com, ma.ram @test.com,mk.p@test.com,ss.t@test.com'

SELECT REPLACE(REPLACE(@word,'ss.t@test.com,',''),',ss.t@test.com','')

Inform us if it works!

Cheers!

[Edited to remove the white spaces in the REPLACE]

Thanks for the...