I am attaching a zip file with a proc that will script out all your tables, including the triggers on the tables. If you just want triggers you can...

Have you checked the SQL Server Errorlog, the SQL Agent Errorlog and the Windows System and Application Event Logs? Is there anything in these that could identify the problem.

Is...

Although you can uninstall any service manually, if you do this you may cause the owning service to break. You may also void your support agreement. ...

You most likely need to rebuild the operating system.

If all you have on the server is SQL 2005, you could install W2003 R2 Std 64-bit and SQL 2005 64-bit. ...

You do not personally have to request the locks. SQL Server does this for you automatically.

It is best wherever possible to let SQL Server manage all the locking, or...

Database statistics only need to be updated when the new values would be statistically different to the old values.

The statistics are used by the optimiser to determine the...

All systems that allow multiple update access to the same pool of data and implement transaction integrity use locks. The physical implementation will be different according to vendor, but...

I have attached an extract of an install guide I am working on. This covers the Windows authorities needed by SQL Server, and the process of creating proxy accounts.

I...

Try to isolate the problem.

Can you log into SQL Server using SSMS? Can people use other applications on this server?

If you can log on to SQL Server outside of...

If the service account running SQL Server has the Windows 'perform volume maintenance' right (see Local Security Policy), then SQL can use 'instant file initialisation' (see BOL) and the growth...

It is very unlikely that merging the procs will improve performance.

You should analyse what each statement is doing in the procs, to see where the delays are happening.

As a wild...

If you are installing SQL Server on a Domain Controller, you must do the job with domain Admin rights. This is in BOL somewhere...

If you install on any server...

I would strongly favour separate tables for each language. That way you do not have redundant columns for languages you do not use. You can also specify the...

If you are rebuilding all indexes then you don't need to reorganise them - you are just duplicating work.

If you rebuild a cluster index then its stats are automatically updated....

I would not call Shared Memory a network protocol. It is a protocol to access SQL Server locally, but not a protocol to access SQL Server over a network...

If...