My understanding was that if someone reads a row in the database then this row is locked for the duration of the read and that if someone tries to update...

It could be that the default database for the ASP was changed.

Like is faster since it can use indexes. (with the wildcard at the right)

Left is applied to all records. (no index)

You're welcome.

Select distinct Have_Not_Type1.recID

From

(select distinct map.recID

from table1 map

left join table2 ON map.recID = table2.ID AND table2.type=1

WHERE table2.ID IS NULL

) AS Have_Not_Type1

INNER JOIN table2 Have_Other_type on Have_Not_Type1.recID=Have_Other_type.table2.ID

and (Have_Other_type.type =0 OR Have_Other_type.type=2...

Is your sql server set up to only allow Windows authentication, or Windows and SQL authentication?

In order to use windows authentication, you need to put the servers in a domain.

If they can't be in one, you have to use sql-authentication.

You can make some basic guesses which SQL statements are sent by using the sql profiler.

They delete from tables in the same order?

Any options specified update ... WITH ... ?

The error is caused by next run date which can be 0

a simple workaround

CASE

WHEN msdb..sysjobschedules.next_run_date =0 THEN NULL

ELSE cast(cast(msdb..sysjobschedules.next_run_date as varchar(15)) as datetime)

END AS next_run_date

,

since it are all inner joins, what about

SELECT d.item_number, h.order_date, h.order_number, h.invoice_number, d.order_amount

FROM factsql.dbo.sopinh h

INNER JOIN factsql.dbo.sopind d

ON d.company_number = h.company_number

AND d.order_number = h.order_number

AND d.invoice_number =...

Found a link of 2003 versions comparisions:

http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx

I believe the big difference is the amount of hardware it can address (cpu/memory/clustering)

1)you can change the timeout settings of enterprise manager in the Tools menu -> Options.

2)Is there a linked server in the query (default time out 600 seconds)

3)Enterprise Manager is quite...

That square could be a half line feed.

Are the textfile originating from mac or unix systems?

If you open the textfile with notepad,do you see the squares too?

Perhaps this script can help you out:

http://www.sqlservercentral.com/scripts/contributions/1301.asp

Mostly we create a Trigger on a table:

Table Original

Column1 (PK)

Column2

Table History

Column1

Column2

ChangedDate

ChangedUser

CREATE TRIGGER TR_ORIGINAL_INSERT ON dbo.Original

FOR INSERT /*INSERTS ONLY*/

INSERT INTO dbo.HISTORY

(column1,column2,ChangedDate,ChangedUser)

SELECT Column1,Column2,CURRENT_TIMESTAMP,CURRENT_USER

from inserted.column1,inserted.column2

Your application can read out the columns and concatenate...