CREATE TRIGGER TR_PROJECT_UPDATE ON [dbo].[tblProject]

FOR UPDATE

INSERT INTO [dbo].[tblProject_audit]

(Field1,field2,....)

SELECT

CASE

 ISNULL(INSERTED.FIELD1,unplausiblevalue)=ISNULL(DELETED.FIELD1,unplausiblevalue) THEN unplausiblevalue /*not changed*/

 ELSE DELETED.FIELD1 /*old value*/

END AS FIELD 1

,

CASE

...

FROM INSERTED INNER JOIN DELETED ON INSERTED.PK=DELETED.PK

WHERE ISNULL(INSERTED.FIELD1,unplausiblevalue)<>ISNULL(DELETED.FIELD1,unplausiblevalue)

OR ...

you...

Can you post vstr?

Usually there exists a function Replace in Asp, ...

It also depends on how busy the server is.

Have you applied service pack 3 or higher to your sql server?

Windows 2003 won't let remote computers connect to unpatched sql servers.

I have no clue, recently someone asked the same for warnings.

You can raise a custom error with RAISERROR but the original error will be sent also (I presume).

Does the application...

Accoring to the books online, error 208 = invalid object name

Are you specifying the owner of the stored procedure when executing it?

Like

EXECUTE dbo.USP_TESTING

instead of EXECUTE USP_TESTING (looks for an object...

can you remove the @ at

cmd.Parameters.Add("@login", SqlDbType.NVarChar, 255) ...

I guess ado adds it by itself.

there is a "split" function in the scripts section that is able to split a string in seperate items

A stored procedure could

1) insert the splitted items in a temporary table

2)...

Without affecting the final result -> means the same result at the end  <> the same path used to get the same result.

inner join only red and marbles-> collect all marbles from...

till I find some reference

The reason why a restriction on the join probably performs better because it eliminates (some) rows SQL server has to retrieve / compare. This results in...

you can put the anti-open in the autoexec macro

If this one exists, it will be executed first.

Have a look at securing Access sites how about to hide the main...

In that case, contact the creator/vendor of the application and have those errors checked on severity.

Happy to help

1) Is there a firewall in between (like xp sp 2 firewall)?

2) Can you connect via ipadres\instance name?

hmm

normally a fresh install of sql server allows buildin administrators (local administrators of a pc) to login via windows authentication.