I'll try the powershell approach and report back.

Hmmm yeah thats a good idea. I could include the embedded html and the file in every email. I could also check the length of the string and if it...

Perhaps this...

INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)

SELECT

RIGHT('000000' + convert(varchar(6), PartNo), 6),

0,

0,

RIGHT('000000' + convert(varchar(6), PartNo), 6),

0,

10,

1,

null

FROM

dbo.Purchased

WHERE RIGHT('000000' + convert(varchar(6), PartNo), 6) NOT IN

(

SELECT PartNumber FROM dbo.Purchasing

)

Oh thanks, that's simple, somehow I never used WHILE before.

This syntax is not allowed with xp_smtp_sendmail.

@message = @string + @string2

I'll seems like I will need to migrate...

Yes if you could help me generate the string that would be appreciated.

I want to try something like this so I can determine if xp_smtp_sendmail will accept something greater than...

Also. Can anyone help me purposefully build a string greater than 8000 characters?

I imagine I need the LEN function and some type of loop...

>>Can the references be set up during the import as in a package or is it done after getting the data into the database?

Either way is possible. You can have...

Along with virtual servers come virtual ethernet adapters, virtual switches, virtual ports, etc. If enabled there can be an entirely separate virtual networking structure. Your virtual host may be inaccessible...

This seems to indicate that when using the migration wizard you can go directly to the msdb database or dtsx file.

http://msdn.microsoft.com/en-us/library/ms143496.aspx

Since you can't see the files I...

If you search this site for 'Search DTS for string' you'll see several leads.

Is this a a 2000 server or a 2005 server with legacy DTS packages?

Also keep in mind that you can export the packages to xml files and then do a search/replace using a text editor and then re-import. Perhaps this could help depending...

>>Here's my situation: I have to refresh table data nightly; however I need to leave everything else (procedures, views, stored procedures) intact.

Maybe you can script out all the views and...

Is there an existing application or reporting tool that already is writing or retrieving data against the data?

If so you can run the SQL Server Profiler tool to see what...

Thank you both. This has been educational and I have been able to unequivocally demonstrate to my very expensive and supposedly enterprise-level vendor that their product is just not very...

Thank you so much. A few more questions if I may.

Am I correct in thinking that this character may not show up, that is be visible, in a normal text...