Got it..

Below query works.:-)

SELECT @SourceFolder = '"L:\SQL2008_Backup\Full Backup"'

Hi grahamc,

Thanks for your replies.This is not meeting my requirment.

What i am trying to do is, i am trying to automate script execution.

Here i am logging the error of...

grahamc (11/30/2010)

---

the problem with pushing the CMD output to variable is that the output is generally more than 1 value (IE. multiple lines or "rows" in SQL Server)

Had a similar...

Hi ,

Please find the script below.

SET NOCOUNT ON

DECLARE @ServerNamesysname

DECLARE @DBNamesysname

DECLARE @SourceFoldernvarchar(500)

DECLARE @OutputFoldernvarchar(500)

DECLARE @ScriptNamenvarchar(500)

DECLARE @ScriptFullPathNamenvarchar(500)

DECLARE @Cmdnvarchar(1000)

DECLARE @Postinyint

DECLARE @Order ...

Hi Sadequl Hussain,

Thanks.Very use full script. I have 1 question. how can we capture the output of the result file to and variable?

Regards,

Vijay Singh.C

Thanks alot buddy:-)

Regards,

Vijay

Ya i have the DB backup for both the database.

Hi Pradeep,

Below is the query :

SELECT db_name(st.dbid) DBName,

...

Thanks for the updates..:-)

When i saw the Cache i got SPs with multiple cache plan even after not changing the SET options.

Is there any other way to avoid this?

Thanks,

Vijay...

Hi,

Thanks For the Quick reply.:-):-)

The below code also works fine which is from MSDN.

SELECT CONVERT(VARCHAR,CAST(25000000 AS MONEY) ,1)

Thanks and Regards,

Vijay Singh