Please do not cross-post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=308126

from the books online

Schema Locks

Schema modification (Sch-M) locks are used when a table data definition language (DDL) operation (such as adding a column or dropping a table) is being performed....

How are you accessing the table (form, stored procedure, table view)? Does the linked table points to the sql 2000 table?

See if there are dependent objects generated. In that case you can execute the script per object.

add another ' for every '

select * from employeedetails

where edescription='employee name is ''john jackson'' and state is ''ca'''

You could change the table to a view and write the appropriate instead of triggers.

I don't have experience with sql 2005. Have you tried the sql server best practices analyzer? http://www.microsoft.com/downloads/details.aspx?FamilyId=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

Raid 5 is generally slower for writes, so I wouldn't recommend it for tempdb.

My server has the os on a raid 1,data on raid 10 and logs on raid 1.

Are you altering the view using query analyzer, enterprise manager,...?

What error do you get?

There isn't a performance hit (or a small one) to have multiple databases. This changes when they are on separate servers. In that case sql server might decide to pull the...

SELECT @fullname = (ISNULL(LastName,'') + ', ' + ISNULL(FirstName,''))

NULL+something=NULL

I've enabled the following traceflags so the deadlock situation appears in the logs

dbcc traceon (1204, 3605, -1)

go

dbcc tracestatus(-1)

go

http://support.microsoft.com/kb/832524/

an extra vote for Andrew's solution since it allows index usage

is connection pooling on/off?

We had troubles with connection pooling off resulting in error messages like server does not exists... because the machine couldn't generate connections fast enough (or something alike)

functions on columns that participate in the join can make the optimizer decide not to use an index (not sargeable)

like convert(varchar(10),mydate1,102)=convert(varchar(10),mydate1,102)