Went for none of the above as I thought SQL would fall over on 'column'...

No problem!

Yep, perfectly possible.

The deployment target is set in the solution settings - open the solution in BIDS and right click on the Solution in the solution explorer, and select Properties....

Hi Kevin,

Compression was introduced with SQL 2008 so I'm pretty sure your database isn't compressed.

I think your best course of action is to take a backup and then compress the...

You'll need to use the ALTER SCHEMA command to change the schema, a rename won't work.

My query along those lines goes via the sys.indexes table:

FROM sys.objects o

INNER JOIN sys.indexes i ON i.object_id = o.object_id

INNER JOIN sys.partitions p ON p.object_id = i.object_id AND p.index_id = i.index_id

Note...

I nearly kicked off at that, but managed to click off the page in time 🙂

Absolutely robbing a living he is.

Cheers Scott, I did it by eye & calculator so I'd trust your...

arrjay (9/30/2014)

---

V. strange. I have tried changing the field lengths from 320 to MAX (is this what you mean by changing the table options?), this fixed the problem but...

I'm...

Koen Verbeeck (9/29/2014)

---

arrjay (9/29/2014)

---

OK, thanks for the advice. Are we saying that without making significant structural changes to the table I won't be able tot increase the number of...

ChrisM@Work (9/29/2014)

---

arrjay (9/29/2014)

---

Thanks but I can't change what is already there. I can update the field I have referenced but a structural change would take too long to get...

Can you provide the full error message, and the configuration values you've set in Database Mail (excluding any sensitive data of course)?

Thanks

Some info here on an (oddly identical) post from 18 months ago...

http://www.percona.com/forums/questions-discussions/mysql-and-percona-server/11217-corrupted-innodb-table-crashing-mysql-instance-how-to-recover-table

If the table was being truncated and there's no FK's referencing the table, could you not just issue drop...

What datatype is CS.Value ?

If datetime/smalldatetime then simply

SELECT CONVERT(varchar(10),CS.Value,101) AS [BeginningDate]