I think the large table will be locked while the new column is added. Try it for yourself on a test server, and see what locks are acquired. ...

Happy to help. You can make it a bit neater by putting the CASE logic near the top:

...

SET @carage =CASE

-- don't need to cast as int because that's the...

Kalpana

If you specify your service account in SQL Server Configuration Manager (instead of in the Services applet), the correct permissions will be assigned. I don't know how they suddenly...

Comparing any value to NULL will return False. Please will you show us your query?

John

Edit - I think I see what you're trying to do. Will this work?

WHERE...

Yes, your code appears to assume that the row that was inserted is the one with the maximum PAT_ACCOUNT_MANAGER_ID. Even if that column had an identity property, that would...

I would guess that you're using different network libraries on the two OSes and that's responsible for the difference. Different settings will be used depending on your network library,...

Please will you post the CREATE TABLE and CREATE TRIGGER statements for the table and trigger?

Thanks

John

OPENXML is one way of doing it. There are others.

John

I believe so, but there's only one way to find out for sure. Do you have a test server?

John

You can check for yourself.

SELECT TOP 100 *

FROM dbo. LoadMedicationsGP

It should work.

John

SELECT

Price

FROM

PHistory

WHERE

Product_Reference = 100014

AND

Change_Date = (

SELECT

MAX(Change_Date)

FROM

PHistory

WHERE

Product_Reference = 100014

AND

Change_Date < 20070906

)

Of course, you may get into trouble if the price changes more than once on the same date.

John

SELECT TABLE_SCHEMA + '.' + TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES

John

Some vendors are happy for you to do this; some aren't. At the very least, you should monitor performance and, where necessary, tweak the indexing or suggest changes to...

3312K still isn't huge - only 414 pages. But best advice is to make sure every table has a clustered index, with exceptions to that rule clearly documented. ...

Well, a page is 8KB, so it's easy to calculate.

For large tables, you want fragmentation to be as low as possible. If you rebuild all the indexes on such...