If not WIX, is there any other software that would be a better or easier option?

thanks,

_UB

What about exception handling?

If the upgrade fails at any step, how do you rollback? Is it handled by InstallShield or the Sql Scripts?

thanks,

_Uday

I do not understand the question clearly....

Are there any non-displayable (or special) characters added to the address column

_Ub

middletree (7/22/2009)

---

Someone managed to get some SQL injection going, and our database has...

Thanks a lot for your suggestion.

I am not sure if that's possible, but I'll try it as soon as I get access.... sometimes things happen slow here.

Roy,

Thanks for the great article. Steve pointed this article out to me as I was looking for some info on general database safety. http://www.sqlservercentral.com/Forums/Topic754288-146-1.aspx#bm754352 I have a question though.

In...

Thanks Gail and Steve.

Gail,

Database keys are stored in the database, but Service Master key is Instance level, right? And if there is a way to tie the instance key to...

Thanks Gift Peddie. I'll look into it

From msdn:

SQL Server Express uses the same reliable and high-performance database engine as the other versions of SQL Server 2005. It also uses the same data access APIs such as...

UDF...mmm.... did not know that was possible. I'll try it.

Update: I wrote a trigger to accomplish this, but I'll try UDF, just to test.

Thank you GSquared. I was starting to have the same opinion.

thanks,

_Ub

GSquared,

Okay may be the code gives an incorrect view of the problem I am trying to convey. I want the INSERT transactions to be audited from any user.

My understanding...

Gail,

But the problem is .... the record gets inserted into Patient table and z_audit_Patient table.

thats the puzzling point for me?

This is what I am trying to do.

We have a Patient table, when users try to INSERT records into it a TRIGGER is fired that INSERTS a copy of the...

Not quite.

I think I do understand the chain of permissions in the case of Stored Procs or Views or (SProcs with Dynamic Sql).

As far as I recollect, TRIGGERS run under...

For Sql Server 2000 and Sql Server 2005 (with Compatibility mode 80) you can insert into table.

But the select fails with the said error.

Sql Server 2005 (with Compatibility mode 90),...