Everything you mentioned is exactly why i try to donate some time here and help people.

I've sometimes put in a lot of time creating a solution on a topic...

I've...

the error seems pretty clear to me:

does your process expect to insert...

yes it's possible; you can create a CHECK constraint that uses a user defined function, that say returns 1 or 0 if the criteria is valid or not.

with DDL and...

create a new table with the appropriate primary key or unique constraint.

insert into that new table grouping by the the same appropriate primary key or unique constraint criteria from the...

even if you have a default constraint in place, if you have a data access layer that explicitly sends NULL to be the column value, then NULL it shall be.

defaults...

microsoft supplies a proc named sp_help_revlogin here that scripts out sql users with hashed passwords, for importation onto other servers.

you'll need to grab the right version off of the MS...

for that i think you'll have to search and read a bit for yourself: it's far to much for a forum post to highlight for you.

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008R2

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2012

format 108 givesw the time including seconds, includingpreceeding zeros, so you could do a substring/left of that:

SELECT LEFT(CONVERT(VARCHAR,getdate(),108),5) --09:10

Edward-445599 (1/17/2014)

I was wondering what is the best way to change context within a DB.

For example you could have a simple script which restores a DB you might have something...

actually, using the content id (cid:) is the right way.

by leaving it out, you are just taking advantage of some email clients smart features of filling in missing tags, the...

dateadd is not deprecated.

glad i could help a little bit!

let us know how it goes or if oyu need another pair of eyes to look at the issue.

since you know the 53 tables, and you know the date, i think this is just a big UNION query:

SELECT 'Table1',count(*) FROM Table1 WHERE CreateDate > '2014-01-01' UNION ALL

SELECT 'Table2',count(*)...

edit: since you don't have access, you couldn't use execute as, sorry.

this solution might depend on whether your application maintains a dedicated connection or just connects and disconnects as needed...