for the individual emails, do they all have the same error message?

maybe something changed outside of your control, like a firewall blocking port 25 traffic, a DNS error or something...

any macro is going to have too many specifics...you have to build the macro before you can use it, and that...

have you looked into the built in Import Export Wizard, or SSIS or using a linked Server yet?

one of the many selections of the wizard is to chose an excel...

why not the two values in the same query? just an oversight?

select * from openquery([linkedserver here],

'select

name,

@@version

from sys.servers

where server_id =0')

what if your data is not in that exact format?

/*

--Results

First_Name Middle_Name Last_Name

Doe, John M.

*/

With [data$]...

rebecca.moore.ctr (11/28/2012)

---

Thanks definately useful but I was looking for a quick way to grab all the database code and put it into individual files. The purpose would be to baseline...

i found a few articles, all with explanations:

http://rusanu.com/2006/04/06/fire-and-forget-good-for-the-military-but-not-for-service-broker-conversations/

http://social.msdn.microsoft.com/Forums/en-AU/sqlservicebroker/thread/9ebba1ac-79b3-4eac-a2f6-41def13154cb

http://www.nootz.net/index.php/service-broker-fire-and-forget-messages.html

just reading up and want you to check the basics.

search the code and see if there is a {MyConnection}.Close, where {MyConnection} is the variable name for your Connection...it might be...

ok, does select * from table have any text or varbinary columns that are huge in size?

can you get teh actual exection plan and post it?

when that query is running,...

also post the query; you might have an accidental cross join or something, so your 150 rows is actually billions of rows by mistake.

a little peek might explain it better.

Brandie Tarvin (11/28/2012)

---

You can search stored procedure definitions by joining sys.objects to sql_modules and doing a WHERE clause with a LIKE statement on the definition column of sql_modules. That should...

but null is neither results nor not results, so it must be ok!

whoops! link fixed, i built the tag wrong, sorry.

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

you could also set the database to autoclose, and then check the sql server log to see if it was ever opened after you change the flag.

you'd have to make...

part two of the group of articles that cpn hector mentioned is doing it dynamically, when the # of values is unknown.

the link to part two is here:

Cross Tabs and...