Brilliant! Thanks.

Did you use mono-space fonts then for the detail lines? If not, what method did you use to determine where an entry would wrap?

I'm good - thanks for the info and the chuckle.

Yikes - Dip, Dive, Duck and Dodge! Doesn't pay to leave the forums for a few hours.

Here's the scenario - I'm taking an existing procedure that historically examined each...

That's how I was going to approach it, just wanted to see if there were other options. Thanks for the feedback!

If you need to see "into the database", you can create a snapshot of the mirror. That way you can query the data to prove it's in a state...

Another option is to change the keyboard scheme to SQL 2000. Tools, Options, Environment, Keyboard - top of the dialog. I'd grown so accustomed to the shortcuts in...

Try changing the parameter name

From

comm.Parameters.Add("newscat", SqlDbType.Int);

To

comm.Parameters.Add("@newscat", SqlDbType.Int);

To verify, if you have a development server with admin rights, you can perform a trace to examine the calls as server receives them.

Try sp_refreshview.

sp_refreshview [ @viewname = ] 'viewname'

From BOL :

Updates the metadata for the specified non-schemabound view. Persistent metadata for a view can become outdated because...

For simplicity, try the EXCEPT operator

SELECT * FROM Table_A

EXCEPT

SELECT * FROM Table_B

That was my first guess. Can anyone confirm?