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...

Have to ask, why would you want to to that?

😎

Happy Birthday Steve! I "celebrated" my 49th 2 weeks ago.

I have two dreams, one is to win a large Power Ball jackpot, and use a good chunk of that...

Okay, I am sorry if you aren't understanding what I am asking, but if the mainframe guys are FTPing files to your server, you have to have an FTP service...

No offense taken. We both just have different perceptions from reading the question at hand. When the question started with In SQL Server 2005, I just automatically eliminated...