Ideally, you want to go with Windows Authentication for all your users in SQL Server whenever possible. In the real world, most applications rely on SQL logins. So it happens rather frequently that when the password for a SQL login that is critical to an application is changed, that application breaks. Now, granted, if you are doing things [...]
|
||||||
|
Ah, the nuisances of AD and Kerberos. Whenever you change the service account on a SQL instance, you need to make sure that an SPN pointing to the SQL instance is in place for the Service Account. Otherwise, you might get the dreaded “cannot generate sspi context” error. To manage SPNs registered on your service [...] If you want to do transactional replication, all the tables in the publication need to have a primary key. Here’s a quick way to determine which tables have a primary key. This is the query for SQL 2005 and 2008: SELECT so.name AS TableName, OBJECTPROPERTY(so.object_id, ‘TableHasPrimaryKey’) AS HasPrimaryKey And here is the query [...] Ok. First post. Let’s see how this goes. So they’re called ‘Startup Options’ or ‘Startup Parameters’ interchangeably. I have no idea why. In this post, I intend to show you how to change these programatically (with a script). The example is restricted to one of the many Startup Options that SQL Server accepts. Here’s the scenario. You [...] |
||||||
|
Copyright © 2010 SQL Server, SQLPS, and Life - All Rights Reserved 257 queries. 1.055 seconds. |
||||||
Recent Comments