Viewing 15 posts - 8,746 through 8,760 (of 13,469 total)
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...
September 15, 2010 at 2:34 pm
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...
September 15, 2010 at 11:16 am
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...
September 15, 2010 at 7:20 am
Craig Farrell (9/14/2010)
But but Lowell, If Iz answerz I kin haz internets cookie! Right? Prize iz internetz cookie?
ok Craig, YOU get an internet cookie:

for varunkum:
No cookie for you!

September 14, 2010 at 7:11 pm
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,...
September 14, 2010 at 6:21 pm
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...
September 14, 2010 at 2:25 pm
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...
September 14, 2010 at 2:16 pm
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...
September 14, 2010 at 2:08 pm
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...
September 14, 2010 at 1:40 pm
you'll want to use a case statement:
select
CASE
WHEN thumbid=0
THEN 'false'
ELSE 'true'
END as...
September 14, 2010 at 11:36 am
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...
September 14, 2010 at 11:26 am
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...
September 14, 2010 at 10:51 am
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...
September 14, 2010 at 10:17 am
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...
September 14, 2010 at 10:08 am
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...
September 14, 2010 at 9:48 am
Viewing 15 posts - 8,746 through 8,760 (of 13,469 total)