Thanks Jack,

I have read the referenced article in MSDN and successfully configured to pass the Parent pkg variables to the Child pkg.

The straight link is : http://msdn.microsoft.com/en-us/library/ms345179(SQL.90).aspx

Thanks,

[font="Comic Sans MS"]Vampire[/font]

@tnolan

Below is the output of the query:

Sorry that i couldn't post the query results as a grid, but i did my best to ensure its readability.

I have disabled my...

@Sayfrend

I disabled the firewall and restarted SQL Agent also..but of no use.

The ping results of Smtp.Gmail.Com is pasted below:

ping Smtp.Gmail.Com

Pinging gmail-smtp-msa.l.google.com [209.85.147.109] with 32 bytes of data:

Request timed out.

Request timed...

Hello @sayfrend,

I used those instructions and configured Gmail...however, when i tried sending a test mail,it failed.

Below is the DBMail log entry:

Message:

The mail could not be sent to the recipients because...

@Dugi

Thanks for your tip..it worked. Am now able to login. However,I have my SQL Browser running earlier too...

I earlier used this command to connect to DAC as Admin..but couldn't

...

Brian,

I guess I dig grave for my own SQL Server :crying:

I have executed this trigger on a SQL Instance .\Inst1 and now it is not allowing me to connect from...

Thanks for the post Brian.

However, I am stuck with few issues. Hope you could throw some light on them and clarify .

1. I executed the Step to insert <local machine<...

@chileu17

That script is meant for KATMAI ( SQL 2008 ).

Cheers,

[font="Comic Sans MS"] Vampire[/font]

[font="Comic Sans MS"]Good Work Satyanarayana..

Its working fine and easy to use. However, it would have been even good if you had provided with sample Servers.txt file, because you havent mentioned...

Thanks for the post as i hav been searching for a solution of similar kind.

However, I am left with a doubt after reading this post...

As...

Thanks for Clarifying us Carl,

I have verified and found that if the Sproc is already constructed with an INSERT INTO stmt then our attempt to Insert the records into a...

Thanks Christhopher .

I came to this conclusion after I struggled to capture an Output from a System Sproc into a table for my analysis. Consider the below code,

[font="Comic Sans MS"]

CREATE...

[font="Comic Sans MS"]@Vladan:

I guess we can't Insert the records returned by a SProc Into a table . Sql Server doesn't allow us to capture the rows returned by a Sproc...

[font="Comic Sans MS"]Thanks for the solution , this post really helped me as I too faced with the same problem.

Recently i moved the System Databases from their default location and...

Hi all,

Can some one give me solution for my problem...

Problem:

I have few SQL servers.. I need to design a DTS package that connects to all these servers and fetch the...