The Helpdesk For I.T. Administrators
The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes in the database are first saved to the transaction log, before being updated in the main data file. The transaction log file can allow a database administrator to recover a database back to a …
A Microsoft SQL database consists of at least two files, a data file (.mdf) and a transaction log file (.ldf). The data file contains all the data for the database, as you would expect. The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes …
Ever wanted to know what stored procedures exist on a database, but don’t have access to the SQL managment tools? The script below will produce a list of all the stored procedures on the current database. SELECT Name AS StoredProcedureName FROM sys.objects WHERE type=’P’
The Microsoft SQL Browser Service is a service that runs on a machine that has Microsoft SQL Server installed, and provides information to clients about the SQL server instances installed on the PC. When you are connecting an application to a SQL server, generally the software has the capabilities to send a broadcast query out …
If you are running a Windows 2008 server, you may come across a service called the Windows Internal Database (Sometimes referred to as “SQL Server Embedded Edition”, or see a reference to a database called MICROSOFT##SSEE and be wondering what it actually is, and how can you connect to it. This “how to” article describes …
If you are installing Microsoft SQL Server 2005 onto a Windows XP machine, you may find that you get an error 1603 when it comes time for the MSXML 6 components to get installed. It has been found that this issue is caused by installing Windows XP Service Pack 3, on a machine that already …
Ever wanted to know what triggers exist on a database? The script below will produce a list of all the triggers on the current database, and also what table they are linked to. SELECT Name AS TriggerName, OBJECT_NAME(parent_object_id) AS TableName FROM sys.objects WHERE type=’TR’