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...

Here is other way of doing it

DECLARE @WORD VARCHAR(50)

SET @WORD = 'FA885A0/FA094V0'

SELECT SUBSTRING(@WORD,1,CHARINDEX('/',@WORD)-1) FirstPartofString, SUBSTRING(@WORD,CHARINDEX('/',@WORD)+1,LEN(@WORD)) SecondPartofString

Lynn Pettis (11/11/2009)

---

Does this code help you?

declare @MyDate datetime;

set @MyDate = getdate();

select convert(varchar(30), @MyDate, 113);

select case when datepart(hh, @MyDate) > 12 then replace(convert(varchar(30), @MyDate, 113), cast(datepart(hh, @MyDate) as varchar), cast((datepart(hh,...