If your issue is "just" needing to reduce backup times perhaps you could move your 95% static data onto one filegroup and the larger tables onto another filegroup(s) and use...

In addition to what Chris has said you may want to do this instead as it performs a bit better:

[font="Courier New"]SELECT

   *

FROM

   tblcaseinfo T

WHERE

   EXISTS...

Are all the databases are on the same server? If they was a different server involved I'd blame it on the server time zone setting, but I don't have...

I think you just need to do this:

insert into log values("C:\Documents and Settings\Desktop\New Folder (4)"+"substring(?,30,len(?)-30)")

The third parameter to Substring is length and using LEN(?) you are getting the entire length...

Are you able to connect to the data source using the report user name and password from elsewhere? or from another application on the report server?

You have defined a table valued function and to put it in a select list you want a scalar valued function. Be aware that using this will reduce performance....

You are the first that I know of. I was thinking about doing it on my dev server (64-bit), but now I think I'll wait until you are done.

Thanks...

Normally you allow the UI to handle formatting as they have formatting functions that are simple to use.

From BOL for converting money/smallmoney:

The following table shows the values for style that...

You would use the Hidden property under visibility. You could put an expression on it to set the value.

Prasanna,

SQL Server does not produce any trace events based on table columns. If you need to make sure you do not miss any data with a trace you need...

Based on this you...

Could you post the solution so if someone else has the same problem and finds this thread they'll know too?

Thanks,

I used to think the same thing. But I cannot find any documentation that states a RaisError at any level causes a rollback.

Here is all there is...

Do you mean you want to translate the data retrieved from the database into French?

First guess is that the Excel file is open.