SQL Server Archives - Page 322 of 393 - SQL Authority with Pinal Dave

SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

July 19, 2008

Service Broker, SQL Error Messages, SQL Scripts

If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL…

SQLAuthority News – Updated My Personal Book Mark Pages

July 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA

It has been long time since I have updated my personal book mark list. I have just refreshed it. You are all welcome to checkout my personally picked articles. SQLAuthority Best Articles SQLAuthority Favorite Articles I often visit above two links to read my selected articles. If you have any…

SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting

July 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP, SQL User Group, SQLAuthority Author Visit

I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meeting and meet all the fellow developers, DBAs and members. Location : 401, TIME SQUARE,…

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…

SQL SERVER – Deferred Name Resolution

July 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…

SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

July 14, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Data Storage

Previously I wrote about SQL SERVER – 2008 – Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see…

SQL SERVER – 2008 – User Account – sa or sysadmin

July 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Security

Just a day ago, I noticed ‘sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ‘sa’ account. ‘sysadmin’ is actually replacement for legacy ‘sa’ account. ‘sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It is recommended to all the users who switch to SQL Server 2008 to start migrating to ‘sysadmin’ from ‘sa’.