has the drive been added as a dependency to the application group where SQL sits?

Remove the sets from your sp_send_dbmail call, also read the documentation on the procedure, it will tell you how to make a successful mail call.

http://msdn.microsoft.com/en-us/library/ms190307.aspx

Jeff Moden (2/1/2013)

---

anthony.green (2/1/2013)

---

ChrisM@Work (2/1/2013)

---

Or this:

SELECT

T1.IDCUST,

T1.IDINVC,

T2.AMTPAYM,

TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)

FROM MyTable1_ARIBH T1

INNER JOIN MyTable2_ARTCP T2

ON T2.IDCUST = T1.IDCUST

AND T2.IDINVC =...

ChrisM@Work (2/1/2013)

---

Or this:

SELECT

T1.IDCUST,

T1.IDINVC,

T2.AMTPAYM,

TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)

FROM MyTable1_ARIBH T1

INNER JOIN MyTable2_ARTCP T2

ON T2.IDCUST = T1.IDCUST

AND T2.IDINVC = T1.IDINVC

WHERE T1.IDCUST...

Convert the column before doing the ISNULL check

ISNULL(CONVERT(varchar, datecolumn),'')

You will need to convert the column to a string.

If you tell SQL to use '' as a datetime column you will get 1900-01-01 as that is the default date...

If your major focus is 2008, do the 2008 certs, if its 2012 do the 2012 certs.

While the exams are expired in July, your qualification doesnt expire with it if...

Something like this?

SELECT

T1.IDCUST,

T1.IDINVC,

T2.AMTPAYM,

Dev1.TotalPayment

FROM

MyTable1_ARIBH T1

INNER JOIN

MyTable2_ARTCP T2...

No. The backup is compressed, not the database, the data in the database still occupies 42GB its just the backup can be compressed due to factors in the compression...

If the log shipped but didn't restore, just issue a manual restore with standby / norecovery depending on the logshipping setup.

If a full backup has happened since the tlog deleted,...

If the FTC / FTI is already created, then the only way I know of to move it to a different file group is drop and recreate.

If it never grows more than 25gb dont set it to 50GB your wasting 25GB of space that will never be used. Set it to something like 30GB so...

Probably executed really quick as there was no free space in the files so there was nothing to shrink.

1. Not unless you created a full backup after changing to full...

When you create the full text index, use the option I detailed to tell it where to put it.

You can do it by going into the properties and changing the filesize of the files to something more sensible than leaving it a a stupidly small size that will...