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...

as suggested,

don't assign the id until the end of the registration process....if they don't complete it, you don't save to the database; use a placeholder like ID: Pending if you...

well, stating the obvious, it depends on what the trigger does;

triggers that are jsut sending emails because a new record was added can be replaced witha job that...

i agree with Vivek; if the goal is to copy everything, there are easier ways to do it;

if the goal is to increase your experience with bcp, just as a...

Brandie

It's been a while, but i thought at one point only the registered version fo WinZip has command line options? or is it a seperate application that comes with...

====edit====

where is my jump to conclusions mat? i read like the first few words and made an assumption, sorry...

looking at your post in detail now...now i see it's why the...

nope, the font is not dynamically exposed either, even though a richtextbox is being used to display the data;

about the only thing you could do is use a try catch,and...

if you are talking about the color of the results in the message panel in SSMS, the only thing you can change is the font size and font type; the...

the convert finction has an optional parameter when you convert to varchar specifically for formatting things to dates;

you want to use the 112 format stype:

SELECT CONVERT(VARCHAR(35),@date,112)

in your specific example, it's...