ugg that is tough; you might even have columns that don't store the the number as a varchar without dashes 9and leave the presentation layer to dash-ify it, or even...

you are correct;

there is no way to rename an instance; you have to install a new one with the new name, and drop the old when when you are ready.

davas (11/29/2012)

---

Thank you both for your quick replies! I've created a clustered index and now the table reports as being 600MB as expected so that's great.

Just wondered why the sp_spaceused...

A HEAP table (without a clustered index) has a table size which includes the space of all the deleted rows, that ever existed, EVER.

so if you insert and delete a...

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...