Sometimes, I think people think too hard with some of the questions.

😎

I will throw out my 2 cents. I'd be wary, very wary. Best thing you can do is get your vendor and Microsoft on the phone together and...

Unfortunately, the build numbers do not distinguish the different editions of SQL Server.

😎

What recovery model are you using on the database, and do you have a current backup (and if approriate, transaction log backups) from prior to the accidental delete?

😎

Scott,

This is the article that Jeff wrote and is a good place to start.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

😎

Not sure, but I think that there should be a clustered index on the temporary table as well. Not exactly sure which columns. Jeff Moden wrote a nice...

The trial edition is most likely the Standard Edition with a expiration date, which is not as powerful as the Professional Edition.

😎

Can't debug a stored proc in SSMS. You need, if memory serves, Visual Studio 2005 Professional or better.

😎

Could have also been caused by a network error. If you have the space on the server itself, it would be better to backup to disk locally, then move...

Using your temp tables from the original post, here is the code you are looking for.

with Controls (

ControlName,

HasAccess,

ControlType

)...

rian67 ,

Here is what I'd say. The development server needs to be controlled, and supported to fulfill the requirements of the development team. This does not mean that...

I have to agree with DavidB, setting up replication is not a developer task. It should be setup by the DBA. Too many things that need to be...

Is this nice data in a table already, or do you only have it in a text file?

😎

Why not? I don't think any of those require sys admin access to the entire system to be completed. I can see where adjustments might be required, depending...

Not saying application developers don't know how to work with SQL Server, they just don't always think about things the same way a DBA.

A DBA has a duty to protect...