The condition is still

If you update or delete where col1 is one or five then rollback the transaction ?

The current code wants that one of the records contains col1=1 or 5,...

CREATE TRIGGER TR_TEST_MANDATORY ON dbo.TEST

AS

SET NOCOUNT ON

IF EXISTS(SELECT col1 from inserted WHERE col2 = 'mandatory')

--IF EXISTS(SELECT col1 from inserted WHERE col1 in ('one','five'))

BEGIN

ROLLBACK TRANSACTION

END

Does in only have to be 1 level deep?

SELECT TableA.ID,TableA.ParentId,TableB.ChildName

from TableA Parents

LEFT join TableB Childs

on parents.id=childs.parentid

order by parentname,childname

(still needs some testing)

You're welcome.

If you connect to the windows xp from another computer you may run into the maximum allowed inbound connections of windows xp: http://support.microsoft.com/?scid=kb;en-us;314882

Windows home:5

Windows pro :10

The optimalisation job is problably DBCC REINDEX (hold locks)/DBCC INDEXDEFRAG(online)  (keeping indexes in shape, fills log quite nicely) en perhaps sp_updatestats (for a better query plan).

Log backups can be done...

I have no experience with switchboard but they look like forms with button. When clicking on a button it opens a new form (see the visual basic for applications code)....

You mention the transaction log becoming full. Does it grow in small enough increments. Is the initial size large enough to prevent shrinking/growing.

During the optimization job, is the database mode...

Does sql agent have sufficient permissions to access the file(s)? Does it have the same network administrator permissions?

Could you repost the picture/description? My browser displays a red cross instead.

Relax

Have a look at http://www.granite.ab.ca/access/autofe.htm for possible ways of automatically updating your access-versions.

At work we have a table with program versions. At startup the Access application verifies its current version...

Something like this?

/*WILL hold names of linked servers*/

CREATE table #linkedservers

(

SRV_NAME sysname NULL /*Name of the linked server. */

,SRV_PROVIDERNAME nvarchar(128) NULL/*Friendly name of the OLE DB provider managing access to the...

run sp_server_info @attribute_id =2, that attribute tells which edition of sql server you are connected to

You can fill the server variable with a loop. (cursor) SET @ServerID=@OtherVariable

Can you write a couple of statements of wanted output for the statement to execute?

You can use bulk insert also. It's only named bcp-file (c:\bcptest.txt) because I've exported the data with bcp.