September 2007 Blog Posts
Have you ever been troubleshooting a SQLNS instance and noticed the status code column in some of the views and underlying tables? For example, the NSSMTPNotifications view has a column named DeliveryStatusCode with a values that range from 0 to 6. But what does that mean? What does a value of 6 actually tell you?
Fortunately, the SSNS database contains tables with status code descriptions. Try running the following query in your application database. Note: you'll need to replace dbo with the appropriate schema name.
SELECT * FROM dbo.NSNotificationDeliveryStatusCodes
Figure 1 shows the results. You can see that a value of 6 in...
Recently, a client asked that I grant database access for several of their new employees. The client uses SQL Server 2000 and has an Active Directory in place to manage domain users and resources. Windows Authentication is used almost exclusively in this environment.
As I dutifully created the new Logins, granted access to the required databases, and assigned the users to the appropriate database roles, everything went as expected - that is, until I got to the last two employees on the list. As I attempted to create a new Login for those two employees, I received the following...
Although much of the prefacing information about the query optimizer's use of statistics to determine the best way to resolve a query are applicable to SQL Server 2000 and 2005, the script that I included in my last post to determine that last time that the statistics were updated was specific to SQL Server 2005. The sys.indexes view does not exist in the prior version of SQL Server.
I've updated, or rather backdated, the script to work with SQL Server 2000. (It still works under SQL Server 2005).
SELECT o.name AS Table_Name ...