None that I am aware of.

I will take an example to explain the warning.

Suposse you have a table - Employee and a SP AddEmployee. AddEmployee just inserts a record in Employee table and hence...

You dont need 2 different IF ELSE as the value of @keyid doesn't depend on the value of @ParamHome.

Also,you don't need 2 different select statements for @ParamHome = 'ALL' and...

As steveb mentioned, you have to change the (default) location and name of the mdf, ldf, ndf file during the restore.

if your using T-SQL then check the syntax of 'RESTORE...

You can make use of String function CHARINDEX along with SUBSTRING

Take a backup and restore with a different name

Are these packages migrated from DTS(2000) to SSIS (2005 - .dtsx)?

Try sp_trace_create and sp_trace_setstatus, this might sort out your problem. Please refer to BOL for syntax and usage.

Are you also known as hemant789 who posted the same question (word to word) in the following post:

http://www.sqlservercentral.com/Forums/Topic636110-8-1.aspx

:hehe:

Try the following link on MSDN forum:

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/28eeb603-1607-4b56-9461-3c0502cbec9c/

Already answered by Nitin 🙂

linked server is one of your options

passing parameters is not possible if you want to execute the batch file by double clicking it.

Alternatevely, to get the current directory use the %CD% variable. This is how you...

I don't think this is possible without creating a new table.

If someone knows the solution then I am also interested in it

Don't know about mails through SSAS 🙁