My first thought on this was triggers not handling multi row, but it is clear that there are two separate inserts here so I am starting to think probably not...

Very odd behaviour.

When you say as one batch I assume you are highlighting both insert statements and submitting that way.

Can you put a GO between them and then run the...

The exact code you are running would certainly help. Also have you checked for any triggers on the table - if you are inserting multiple rows in one statement and...

Can you confirm the data type of the column startTime please? - Best to post th eentire crate table statement.

Also is the asp page connected to the same database -...

There is a possibility of a lot of discussion being prompted here, but in my view (as in Philipps above) there is no good reason to use an "id" column...

You have run in to what may seem odd, but is correct (and I believe documented) behaviour.

The problem can be seen in any subquery when the inner query refers to...

What you ar easking is way too broad a question for a simple answer on a forum I am afraid.

What i would suggest to get you started:

Read all the...

Very true - I was thinking a less severe (and unlikely!) such as an index page simply not having an entry for the row in the data page or something...

If the collations match and the data is really the same then I would start to suspect a corruption somewhere, so details of all indexes and the execution plan to...

Have you checked both installations are running with the same collation? This looks like it could be something like a case sensitive collation on one and a case insensitive on...

I think you will find this is simply down to the speed of moving the data from the server to Management Studio. If running locally you have probably connected using...

The result will be ABCD (ie four rows with an implicit distinct from the union, or you could use union all if you do not want the implied distinct.

Not sure...

My bet would be one (or more) of the variables is NULL, and any operation that concatenates NULL with another value will return a null, hence the entire expression is...

No, SQL Server has a fixed 8k page size.

Why did you want to alter it?

Mike John

I think you want the "tooltiptext" property of a textbox. This property contaions an expression that defines the text to display when the mouse hovers over a field.

Mike John