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 [...]
|
||||||
|
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 [...] |
||||||
|
Copyright © 2010 SQL Server, SQLPS, and Life - All Rights Reserved 257 queries. 0.605 seconds. |
||||||
Recent Comments