You have just quoted what you are...

Refactored it, but a bit messy on the email, need to format it how you want it to by building strings into variables, then passing that into sp_send_dbmail, but works,...

clayman (6/6/2012)

---

Good point but with a FK in place the op would have probably gotten an error msg while trying to delete? Anyway I'm a bit confused what he...

I use this to insert into a table every day the current used, free and total space. You could refactor it to use sp_send_dbmail and build up a message...

this link should give you the information you need

http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx

The size columns in the two views are in pages, so I assume you are multiplying them by 8, to get the size in KB then dividing by 1024 to...

does the below fit your needs? added the 0/1 column on the end to see the if its bit = 0 or bit = 1

declare @tab table (PERSON nvarchar(10),...

You have to be careful with playing with id columns, especially if you have foreign key constraints. Identity gaps are common in all databases, especially in transactional scopes where...

Highly useful is CTRL+R, especially when you have a...

Cliff Jones (6/5/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

I...

You need a full outer join.

declare @tab1 table (year int, week int, total_savings decimal(36,18))

declare @tab2 table (year int, week int, total_savings decimal(36,18))

insert into @tab1 (year, week, total_savings) values

(2012, 10,...

I would say this is down to different dateformats being set at the connection level.

One thing to check would be the language of the accounts in question as I am...

DOMAIN\USERNAME$ is the machine, so does the machine have access to SQL? Also what are the machines services running as which connect to SQL? Local System? If so...

you want sysaltfiles which is the 2000 equiv of sys.master_files

SELECT *

FROM master.dbo.sysaltfiles

Would be a case for a left outer join where mytable2.eid is null

select

t1.eid

from

mytable1 t1

left outer join

mytable2 t2

on

t1.eid = t2.eid

where

t2.eid is null

returns mytable1.eid 5 and 6