Were the test performed straight on the server (to eliminate network congestions)? Can you conduct some more tests ( about 1000...).Were there any caches freed (DBCC FREEPROCCACHE)? Statistics are up...

I'm lately facing locking too. For one particulary table it was solved by changing the clustered index.

There is an option hidden in outlook to automatically wrap lines longer than ... for unformatted email.

Can be found at extra->options->email-layout->message layout->internet layout->Options for unformatted text->automatically wrap when line is...

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/