November 2006 - Posts

• Using the catalog views to see table permissions

  I was needing to get an idea of the permissions that had been granted in a couple of databases the other day, and being the GUI novice I am, couldn't find what I wanted easy enough (if it even is in there.) So, I hunted around in the system views to see Read More... Posted Saturday, November 11, 2006 10:51 PM by drsql | 2 Comments Filed under: SQL Server, Catalog Objects

• A script to check for the existence of data in tables or views

  This is the second time I have needed this, so that elevates it to blog status (code for mine and your reuse being the second most important reason I blog. The most important one is the notoriety, glamour, and big bucks :) I have a database that I have Read More... Posted Friday, November 03, 2006 9:55 PM by drsql | 1 Comments Filed under: SQL Server, Catalog Objects

• PASS is coming up really soon

  Will you be there? I will be, in case you haven't read my blog before. And you should be too. PASS is not only fun (nice parties, gatherings, and lots of nice people everywhere) but educational. For the price you pay, you will learn something, no matter Read More... Posted Wednesday, November 01, 2006 10:36 PM by drsql | 0 Comments Filed under: PASS