Well MySQL 5.0 that is a free download from the mysql site supports stored procedures however there are syntax issues with respect to syntax's adopted in SQL Server and MySQL.

If you have scheduled a regular backup plan, the inactive transaction log is automatically truncated after the backup process is completed in SIMPLE recovery mode.

You should probably schedule maintanence plans on your database during weekends to shrink your log files on a periodical basis using DBCC commands.

Just as an alternate create a stored procedure and populate the values of the above sql code into a temp table and retrieve the data from the table and map...

Try Modifying your stored procedure to include a alias name for the field that is fetched using CASE

 " CASE

  WHEN description is null THEN #temp1.t_name

  ELSE #temp2.description

  END AS description

AS description...

Well I am not sure if I got your question right but you can try this.

CREATE

TABLE client

(clientID int

Thanks John for the quick reply, however my requirement is a little different, this I need for boot strapping databases at various locations and I will not have the source...

I don't think you can set the default value to '0' at the database level, either we need to write a iterative procedure that uses DBCC CHECKIDENT to scan through...

Yes, I got your point, I thought you were not able to place the database fields on the footer, yes placing a table , matrix or a list is not...

How are you passing the parameters to the report, if you are using a interface to call your report by passing the dates, its always advised to do the check...

I believe you can insert database fields in the Footer section. Is there any specific problem that you are facing in placing a database field in the footer area.

Check in case if the drive on which u are having the log files is compression formatted.

Basically, as you rightly mentioned there is no relationship between CategoryID on Category table and CategoryID on userCategory table logically since it is not possible to define a reference on...

There are definitely some performance issues with SP4 on SQL Server 2k, for more information please follow this link.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52230

Thanks

This Link from Microsoft Should help you with a work around for your problem

http://support.microsoft.com/default.aspx?scid=kb;en-us;305711

Thanks