Thanks for the reply Lance

Well the error that I receive is so-known "CREATE Table Permission Denied on db ..." error.

Even if the user is explicitly states [dbo].[table_name] it is...

If I understood right;

you can change the SQL service startup account. In SQL 2000 EM right click on related SQL Server, open properties, go security tab, change "Startup service account" to...

Maybe helps

http://support.microsoft.com/?kbid=814572

Lee,

in short without "sa" developers can make no harm on the productional dbs. Additionally if the DBA's let the developers play with productional dbs then this security "gap" cannot be...

Hi Lee

Firstly: what are the concerns that you have with SQL MS 2005?

Secondly: If your developers were using isqlw for developing sp's then why not to use SQL MS...

In our shop we are two DBA's who are responsible for almost everything that is related to SQL somewhat. Administration, optimising, T-SQL coding and helping developer to code SQL etc. If...

Try dropping and re-creating the stored procedure. It strange but sometimes it works. Don't forget to back-up permissions.

Hi John!

We have faced that kind of problem once and we fixed it with hardware vendor. I think it's not a bottleneck but something related with your disk controllers. Apply...

The best way that I know is to use a trace to capture all the executions, but it costs you know

Well EdVassie you are right in some sense

Sometimes you really want to get-rid of the extra load that are caused by sysadmin guys

I think If you are DB-ADMIN on that machine (which makes you responsible for every heartbeat that machine does) then it sounds very logical that you should be localadmin on...

Glat to hear that you recover

Must be a tough stress though

Thanks Ryan!

It a good idea to use sql_variant indeed. I suggested the developer to use sql_variant and she stated that her resultsets has different number of columns

Thanks John,

I wish I could do that but the stored procedure is compiled by another developer and cannot be changed for this purpose.

Additionally the resutset structure is not just...

Is it possible that you accidentally restore over your existing master db? Since you are saying that you can see the "jobs" (as they are stored in msdb) and no...