you'll have to create something in code or in CLR;

the ability to READ emails ( the read receipt IS an email)

was removed when sp_send_dbmail was introduced;

so there is no...

sure, you can do it two ways;

the BEGIN...END block can contain more than one command, and the ALTER TABLe command can take a comma delimited lit of columsn tadd:

IF EXISTS(SELECT...

CB the UPDATE function is really misleading; it doesn't tell you if something changed or not(which is what you intuitively assume based on the name)

it returns true or false if...

ok Craig, YOU get an internet cookie:

for varunkum:

No cookie for you!

we do not do homework.

if you have a specific question, let us know, but the literal copy and paste, without any input on what you tried, what you think,...

ok, any operation which changes the definition of the audit table should be rolled back anyway, should it not? changing THAT specific table is NOT a legitimate change, as it...

to use the alias of your calculation, you have to wrap it up as a sub query; otherwise you would have to use the full calculation inline

this is what you...

you error is really minor; a case can only have ONE "ELSE" statement:

CASE

WHEN Code Between 1 and 24

THEN Hours

WHEN Code Between 26...

it seems to me that the only error that could be raised that would crash the trigger would be the renaming of the table the trigger uses, right?

why not add...

you'll want to use a case statement:

select

CASE

WHEN thumbid=0

THEN 'false'

ELSE 'true'

END as...

i've been lucky, not having to do vb6 for a while as we switched over to .NET, so this is untested.

i think your issue is an error is raised (file...

interesting use of a check constraint to make a table read only;

could there be a trigger on the table that is also preventing your modifications? depending on the loging in...

in that case, if you cannot access the server's C:\Temp folder as in your example, you'll have to use some intermediate item...a vbscript, your own program, etc to connect to...

for SQL 2005, you'll need to open the SQL Server Configuration Manager, i think:(not the Surface Area Config)

from there, you can assign which port the instance will listen to in...

the server thinks C:\ drive is it's own drive....

to write to your PC, you need to use a UNC path:

\\YOURPCNAME\c$\ImageFolder

that might not work if the account that the SQL Service...