I was able to get your suggestion to work on VS2005 on a different box.... THANX!!!!

jude

Thx

I was trying to use VS 2005 & when I try to create a new package it throws "object reference not set to an instance of an object"

Do I need...

Great, thank you much!!!!

Now I feel really dumb, but what is "CampaignID" ?

I want to send 100 different emails (Notifying customers of a change) & yes, the word document will be on the Sql server.

thx!

The first part of my problem is still an issue.

The certificate thing was a result of the profile not being set as default = Y

Now i messed around and am receiving an error message " Cannot send mails to mail server. The remote certificate is invalid according to the validation procedure"

Great, thanx!

Ah, I see. I just wrapping my mind around a stored procedure using objects from another database.

thx

Unfortunately it's not in the same database, I am retreiving cross database references & it's actually going pretty good with you help.

Can I bother you one more time (I hope)

Pulling...

Actually this suggestion;

"select

charindex( col2, 'dbname.dbo.'),

substring( col2, charindex( col2, 'dbname.dbo'), 30)

from myTable

"

is Great!!!

thx so much!

Also, this is just a big text column & sometimes starts with an Inner Join dbname.dbo.xx_xxx_tbl & I don't want any other characters before or after, I just want to...

Yes, column2 is pulled from another table, but I only want the part of the string that contains dbname.dbo.xx_xxx_tbl no matter what position is exists in the string.

Hope this makes...

dependencies across databases; xxx_xxx_proc references 1 table in the database it lives in and als refers to a table in another database. How can i list all dependencies of...

btw, sorry if the format of my post isn't good, but I wanted to replicate what the big string looks like in my table. Also, if you know of...