What is your VM (Virtual PC/Server or VMWare)? Virtual PC/ Server allows the NIC to be seen back and forth between the host and VM. It seems like...

Nothing to...

You're welcome

Hmmm...And I thought EAV meant Extremely Abominable Virus 😀

In practical terms, what you get are nightmarish queries with...

One last one to try - have you tried connecting as 'SA'?

MrT-SQL (1/18/2010)

---

Thanks for the reply Steve.

3 it is, just thought it best to check, sometimes you cant see the...

MrT-SQL (1/18/2010)

---

For anyone who is interested I came across this;

As my decision was being influenced by the volume of NULL values, it helped to clear a few...

NP.

Sidebar - Option 2 poses potential performance problems with it too. I have seen bad implementations of this that killed the database.

Off the top of my head - no. I would need to Google it. During audits in the past, we have had a publication of Mandatory controls issued...

Exact same question as another user posted. Interesting Coincidence.

Answer:

Grant CREATE PROC to a role. Put Users in that role.

Grant ALTER SCHEMA on the schema(s) that the Users need to...

Grant CREATE PROC to a role. Add Users in that role.

Grant ALTER SCHEMA on the schema(s) that the Users need to modify stored procedures in to the role.

Grant VIEW DEFINITION...

No additional ideas. Just a comment. I would go with option 3. This one seems to make the most sense.

This article describes some things you can do.

http://www.mssqltips.com/tip.asp?tip=1416

Toad is a tool that could work for you. Roy's suggestion is an excellent one.

As for the command line option...

There is the DAC.

http://msdn.microsoft.com/en-us/library/ms178068(SQL.90).aspx

If you can login with a SQL account though, then you would not need the DAC.