are talking about a Restore?

is this an SQL Server to SQL Server Transaction or is any other kind of linked server involved?

1. if your software is using set language or any other Function depending on reginal settings you have the answer for your first question.

2. You should check with ISDATE the...

As a practice I tend to set tempdb as the default database for all logins

 Just my $0.02

True You can simplify the above with a Numbers Table, Some People use  views with union all and CHECK_SUM_AGG and so forth. I just posted the Idea on how to...

So how did you make him change his mind about that??

I never said I was able change his mind 

Did you included the SINGLE quotes as they were written? (no space between them)

Can you PRINT what @sql variable looks like, just before the EXEC(@sql)?

using Print @sql

Select  T1.Pkey

FROM

(Select  PKey,

  CHECKSUM( SUBSTRING( Col_ntext, ( 0*4000 ) + 1, 4000 ) ) + -- Use As many as your max( DataLength ) tells you

         CHECKSUM( SUBSTRING( Col_ntext,...

can you post what

select  convert( varchar(20),@FromDate 120),  convert( varchar(20),@ToDate 120)

Returns?

2.

No need for Dynamic ex:

SELECT p.ID_i,PracticeNo_vc,Error_vc

FROM tbl_Message m

     join

     tbl_Company...

This reminds me of a previous boss who all the projects we had were Priority 1

create proc1

as ...

create proc2 ..

as

exec proc1  --- Inner call

...

I have a solution (Not really sure about the good Part )

Do you need to do this on a whole table ( like...

Oh and one more thing you shouldn't be using dynamic SQL when you don't really need it!

SET @strSQL= @strSQL + ' AND SubmissionDate_dt BETWEEN '''  + convert( varchar(20),@FromDate 120) + ''' AND ''' + convert( varchar(20), @ToDate,120) +''''

Several things

1.

SELECT TOP 1 TD.*, P.*,

  (SELECT UID FROM dbo.GetSpecifiedSlumpInfo(P.RegionID, TD.SpecifiedSlump)) AS UID1,

  (SELECT UID FROM dbo.GetSpecifiedSlumpInfo(P.RegionID, TD.SpecifiedSecondSlump)) AS UID2

FROM tblTruckDocket TD

LEFT JOIN tblPlant P ON TD.PlantID = P.PlantID

The Highlighted...