Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links

News

This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog
 




Archives

Post Categories

About me

September 2007 Blog Posts

SSNS Status Codes

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

posted @ Monday, September 24, 2007 10:09 PM | Feedback (0) | Filed Under [ Notification Services SQL Server ]

Error 15401 when creating a new Login

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

posted @ Friday, September 07, 2007 2:02 PM | Feedback (8) | Filed Under [ SQL Server ]

SQL Server 2000: when were the statistics updated?

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

posted @ Thursday, September 06, 2007 5:35 PM | Feedback (13) |

Powered by:
Powered By Subtext Powered By ASP.NET