LOL you're right I was over complicating it... DENSE_RANK worked just peachy.... I admit I didn't know about the dense_rank function ... *blush*

Don't worry, those aren't the actual names of...

Ugh I have no idea how to do that. 🙁

Hey guys I have another question:

Finding V-40949 Talks about implementing a third-party tool or some other sql server method of monitoring security-relevant configuration settings to discover unauthorized changes.

What do you...

Awesome thank you.

Oh and can I ask you.... how do you perform the STIG? The download is just XML files and there aren't any real "instructions". I was user stigviewer.com to grab...

Well I'll be ... oye why don't they have that in the main SQL 2008 FAQ ... THANK YOU! I'm assuming the 2012 STIG is a lot friendlier than...

Haha ok - as long as "SQL needs these" is a valid argument I can put that in the system security document. Cause yea, I really didn't feel like...

Thank you for putting it into GB for me... I gets it now. 🙂

Ok thanks, sorry for the late reply.

How big is nvarchar(max)? I know it says 2 to the 31st power or something... but I'm a dumb dumb and I don't...

Or I was just thinking (could it be this simple?) ... if I just created a table that was like this:

Row_id Issue_num ...

It is a transactional system with reporting capabilities. The front end code updates tables directly most of the time. There are some instances where it calls stored procedures...

Thank you for the response, can you explain the "instead of" triggers you mentioned? How exactly would that work?

This is a web based application with a ColdFusion front end. There is 1 database. Users log into the system via the front end and all actions are...

I only use Maintenance Plans for backups (data and transaction log) as well as file cleanup. They work pretty well for that. (For what I need anyways).

I also concur...

Awesome answer thank you very much! Its great to me that even with working with SQL for so many years that there is always something new for me to...