your settings for CDC were probably set to keep data for 100 years or something,a nd now you are seeing some performance inpact;

I setup CDC on a few tables, but...

arbcoll (10/10/2012)

---

Back to the issue SSC Veteran reported on the second post of this topic, I had the same experience - lost my 2 day work after an autorestart during...

instead of returning a zero when there's an error, just throw a sqlexception, and that will return the full error message, so you can track it down completely.

if it's a...

yeah i strugged thru the broken DDL as well;

unfortunately, becuase you have no true relationship to the two tables, you have to make assumptions to get teh data to work...

I've got a CLR i created that does a proof of concept reading of mail from a POP3 server; i'm slapping together an article for SSC on it;

The problem ...

i believe you need to script out the jobs, and find and replace the old server name with the new server name; As I remember it, the jobs have the...

darthurfle (6/28/2013)

---

Hi Lowell,

I am not trying to make the solution harder. It is a real world situation.

The table in question is a SAP ECC Add-on "standard" table that establishes relationships...

you want to use raiseerror as a progress indicator from some dynamic SQL, is that it?

here's one example that would be appriate in a cursor loop, does this help?

--print error...

ok i still don't understand the issue i guess; I think you are over complicating things too much.

correct me if i am wrong, but you need to delete ALL data...

or grab them all in one data set, duh, i should have posted this first!

SELECT object_schema_name(object_id),

object_name(object_id),

DEFINITION

FROM sys.sql_modules

ORDER BY object_name(object_id)

halifaxdal (6/28/2013)

---

Currently I am using the following code to read all content of sp or fn and it works in most cases, however, it does return more than one rows...

hopefully you'll get a stack of options;

Here's one: this procedure returns a table of HTML-formatted information that documents some server settings, and object details of the currently scoped database:

Link To...

tstagliano (6/28/2013)

---

Thanks for the information but i dont what the table to be a temporary table in the tempdb database. I need it to appear in the ConstarOLAP_PROPHIX_FactDB where...

as long as you declare a temp table before the EXEC command, any other queries would have that table in scope, and can insert into it (same for permanent tables)

so...

Maddave (6/28/2013)

---

Can you change the SQL server to run under a dedicated account rather then system account? Then you should be able to set up the share to have write...