Normally you can't remove a login when it owns some objects. (Test it first.)

You will need to install the oracle drivers on the sql server machine. A restart of sql server is than necessary.

Can't find the microsoft page immediately.

a list of performance differences:

http://www.sql-server-performance.com/q&a98.asp

Enterprise edition is required for clustering, built-in logshipping, access to more cpu & memory.

Under what account is sqlagent running? Local system account (no network) or another? Does it work if you give the command instead of the job?

Why are you resorting to administrative...

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.