SQL Server DBA Links and Articles > SQL Server Articles

Articles | Categories | Search | Syndication

Articles from SQL Server Configuration

How to purge sysxmitqueue table in msdb - SQL server 2005

How to purge sysxmitqueue table in msdb - SQL server 2005
407 Views
0 Comments

SQL Server Configuration

If your msdb database grows huge - it is because of sysxmitqueue table.

SQL Server Default Port Number

SQL Server Default Port Number
149 Views
0 Comments

SQL Server Configuration

Microsoft SQL Server Default instance listens on TCP port 1433. Named instances of the SQL Server Database Engine and SQL Server Mobile are configured for dynamic ports, which means they select an available port when the SQL Server service is started. When connecting to a named instance through a firewall, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.