is there a downloadable demo of this, even crippleware for using only the Adventureworks db or something?

this sounds too good to be true, so I'd like to see it form...

for me, i use a rule of thumb of 10% of the mdf size as the needed log size, but the correct answer is "it depends".

If your database is in...

you didn't print the actual error, so this is just a guess: the error was constraint name "pk_username_profile " already exists

search your script for pk_username_profile and see if it...

J this thread was the most valuable thing of the week for me; i learned a lot. thank you very much.

I had to change your udf very slightly; i converted...

J that got me looking in the right direction;

for whatever reason, my dll's class name is a little weird; i used hte deploy option, and then when i scripted the...

J i've got a question for you regarding deployment;

i created a new VS project named "MyCLRProjects, and added only your Partial Public class as an example;

it compiled, and i was...

do you still have FTP access to the root of your web site? can't you download the suite of pages, as well as the mySQL database and rehost it somewhere...

Maxthere is not a ton of options,as you've identified;

the parameter @recipients,@copy_recipients and @blind_copy_recipients for sp_send_dbmail is a varchar max, expecting a semicolon seperated list of recipients;

if all the recipients can...

bigclick (5/25/2010)

---

.... Unfortunately this is an old legacy system where the database isn't controlled by the company ....

oh yeah I've suffered through that same situation before, I feel for...

this should be a lesson to never store...

proof of concept for Steve's idea;i thought that was kind of neat:

--results:

Status cnv ...

first, i would suggest not killing any connections, whether you know they are in use or not.

just because they 've connected for a long time, does not mean they are...

without dropping it, the calculated column would need a different name; it depends on what you really need;

since I would prefer not to delete delete data by dropping a column,i...

looks very easy to re-format; all four values appear...

ugg; one-time imports are sometimes the most time consuming...can we see a row or two of sample data? enough to make a format file so you could test a bcp...