I've seen the military approach.

I've heard a story about NASA spending millions to develop a pen that would write in space. The Russians provided their cosmonauts with pencils.

The military...

Are you the system administrator?

Get the system administrator to create a copy of that user explicitly for testing.

As I said, this is a long winded approach. Use EM to...

I think alot depends on the size of your organisation and the culture.

In a small to medium organisation it is possible to get to know most of the developers. ...

If you are using Windows Authentication then you have to log in as that user.

If you are using SQL Authentication then Open SQL Query Analyser and connect to your database...

Don't forget the licensing issues!

If your database is serving and internet/extranet/intranet then you will be using per processor licensing hence doubling your costs.

What about single point of failure principles? ...

I simply don't trust back-ups.

The only problem I have with differential back-ups is what happens if one of your backups corrupts?

OK, I know that 99 out of 100 times this...

I use Source Safe to store the scripts for all my objects. As the scripts are simply text files this causes no problems.

In terms of debugging SQL I tend...

I experimented with query hints on tables because I had a large batch job that is only run when no-one else is on the box.

The original query showed up a...

You would be better off finding what it is that causes the locks and modifying the stored procedures accordingly.

In addition to the points raised by Chris Cubley I should like...

As far as optional arguments/parameters is concerned, if there are a large number of them then I switch to using ORs simply because writing a SQL stored procedure that produces...

I would suggest that this is a documentation issue and development practices issue.

Unfortunately, once an organisation grows beyond a certain point formal documentation and methodologies become a necessity rather than...

Sorry, the forum interpretted my HTML entities m etc

Yes you can spider dynamic pages. We use Thunderstone's Webinator as a search engine with a database driven content management system.

One way of blocking the harvesting of e-mail addresses...

You really get a feel for the performance downside of dynamic SQL if you develop web applications.

In most cases the difference in cost between dynamic and static SQL is very...

As I am running the personnal edition of SQL Server on my laptop I have a sneaking suspicion that the error is caused by a conflict between other software running...