SQL Server 2005 General DBA QuestionsPlease post SQL Server 2005 general DBA questions here.SQL Server 2005 - Database Expansion & Locking Issues- September 15, 2008 Hi AllWe have a SQL Server 2005 system which is going to experience major expansion in the near future - it currently has about 200-300 users, but due to a recent corporate merger, an extra 600-700 users have to be added.We did experience blocking issues and a high degree of lock escalation after the system&39;s initial roll-out on SQL Server 2000, 3 years ago: with such a big increase in the number of users planned, I&39;m concerned that we may run into a repeat of that experience.Can anybody..http://sql-server-performance.com/Community/forums/thread/151168.aspx Service Broker Error- September 12, 2008 Hi Freinds, Have any of you encountered this error while performing the following execution We are getting this ambiguous error in our environment. We would appreciate any help you can provide. ============================================DECLARE vConversation_Group_Id uniqueidentifier WAITFOR ( RECEIVE ...http://sql-server-performance.com/Community/forums/thread/151129.aspx Please help regarding my query- September 12, 2008 Hi Friends, The Test1 database configured log shipping which was stand by mode. Now I found the database is showing in Normal Mode it means someone has restored the database with recovery. My Query is - How can I trace the person or user who has restore convert the database normal mode. Please provide steps or method or idea regarding my query. I believe you people will help me reagarding my query. Please let me know if you have any doubt regarding my query.http://sql-server-performance.com/Community/forums/thread/151115.aspx Search for similar names- September 12, 2008 Hi All, I need a query to that will return similar names. For an example, if i search for mike, it should also return michael. Is this possible in SQL Server 2005 Thanks in advance.http://sql-server-performance.com/Community/forums/thread/151105.aspx Restoring Database - files to different location- September 12, 2008 Hi, We have a number of databses that we develop against on our local machines. We constantly swap our ".bak" files between each other, with latest schemadata etc...this is because most of us work off site, and have no network connection (so we can&39;t just have a development server) Some of us, have our default file location as D: others as C: etc... When we restore .bak files, SQL tries to restore the files to the location of the mdfldf files in the .bak file, however i want...http://sql-server-performance.com/Community/forums/thread/151104.aspx Heterogenuous Connection (HS ODBC)- September 12, 2008 Hi All, Is it possible to configure HS ODBC in a Named Instance of SQL Server 2005 Thanks and Regards,JHOYhttp://sql-server-performance.com/Community/forums/thread/151087.aspx List of users who have execute permissions on database- September 11, 2008 Hi All.. Is there any way by which i can get list of all usersave EXECUTE permissiosn on databasehttp://sql-server-performance.com/Community/forums/thread/151077.aspx Can SQL Server Profiler use to trace which filegroup is used- September 11, 2008 Can I use Profiler to trace which filegroup is used I&39;m trying to trace which filegroup is used for a table which is partitioned using partition scheme.http://sql-server-performance.com/Community/forums/thread/151076.aspx What Last_Batch means- September 11, 2008 Does only running a SELECT statemnet updates Last_Batch in master.dbo.sysprocesseshttp://sql-server-performance.com/Community/forums/thread/151065.aspx SSMS fails with "Property DefaultSchema is not available for Database"- September 11, 2008 Our developers gain access to SQL Server and specific databases via membership in Windows Groups. They recently reported that using Management Studio to view the properties of a stored procedure brought up the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available.http://sql-server-performance.com/Community/forums/thread/151059.aspx |