from what I have read I do not believe a DTS is supported in 2008 at all. All Dts's must be converted to SSIS's. That atleast is my understanding.

See now I get it. The solution is thankfully simple. you can setup more than one linked server to the same instance with different names. Set one...

I guess I am confused. On server AA you would add the security contest for BB. this would the the login for BB not the login for AA. ...

I am still not sure where your question is but I am assuming it is in the date portion of your query.

the following will return the quarter date. You...

you may still be able to open it you might try going to the folder in explorer and right click on the dtsx and select edit

If you saved it to your file system you should be able to open the dtsx file with visual studio. that is assuming you are using the BIDS version...

That is an extremely broad question? have you tried anything as of yet? do you have a specific question about a particular element? For example do you know how to...

I apologize I did not see the columns correctly and my code was based on the wrong ones.

did you merge this back in with Lowells query? I updated the part you want to pass but you still need the rest of the statement from lowells post.

having made a couple of changes to the single quote locations the following should work

'SET FMTONLY OFF; EXEC (declare @body1 varchar(4000)

set @body1 = ''New Website Product as of ''...

The probelm is in the Quotes. Take a look at the following Script as a test.

declare @body1 varchar(4000)

set @body1 = '''New Website Product as of ' + CONVERT( VARCHAR( 20...

There are many ways to determine what sessions are connected to a SQL Server and their may or may not be any helpful information that would determine the application the...

This is not tested but assuming by auto seed you are indicating that this is an identity column then I beleive the following trigger would work. Keep in mind...

assuming you want them in different columns then it would be something like this.

declare @dtlist table

(dt datetime)

declare @x int

set @x = 0

while @x < 12

begin

insert into @dtlist select dateadd(mm,@x,'01/01/10')

set...

Take a look at the server log and the following link. The error state may be able to provide more information.

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx