use linked servers and then u can include the table in your query using the 4 part naming convention i.e. LinkedAgencySvr.AgencyDb.dbo.SomeTable

you do not need to store the connection strings in...

remove [xmlns="http://holoncorp.com/xml/EDIFACT/D96A/INVRPT" xmlns:v3="http://holoncorp.com/xml/EDIFACT/D96A/INVRPT">]

from your xml file.

when i tested i managed to load but i had nulls in some columns, so  you might want to check your schema file

or you could consider using Ajax in your web app.

I would suggest

• One table for the providers
• A table per category with a column for the xml content
• use xml indexing

you are doing the correct thing, just run you script as normal and close it when you are done. Or  if you want to save the script goto [File ->Save As]

If using QA in SQL 2000, then you need to set your output to text. i.e.

Tools > Options > Results

On the dialog box select [Results To Text] on the...

in the BI Dev Studio there is an option to use the import and export wizard. This is the fastest way I have found to create a package that copies...

please do not double post your issues.

when creating you auto script you also have to consider whether you are auditing all the columns in the respective tables.

you mixed up on

inner join sysusers u on u.id = o.uid

supposed to be

inner join sysusers u on u.uid = o.id

-------

Select u.name as schemaname, o.name as TableName, x.Name as...

I am still convinced the problem is not with your sql but with outlook, try sending an email to one of your yahoo or hotmail accounts and see if there...

thanks Mark i will try that

i have been hunting for that one as well. i don't think it exists. I have become very good at the Ctrl + R (LOL) even with my eyes closed

Create View

goto

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=351149

create a job with your chosen schedule and then call a stored proc which uses sp_send_dbmail to send your mail