ABORT — abort the current transaction ALTER DATABASE — change a database ALTER GROUP — add users to a group or remove users from a group ALTER TABLE — change the definition of a table ALTER TRIGGER — change the definition of a trigger ALTER USER — change a database user account ANALYZE — collect […]

To check the timeout, look in the menu Tools – Options – Advanced. However, by default it should be set to 0, which means do not timeout <!– –>

From Query Analyzer run: SP_SPACEUSED <!– –>

Run from Query Analyzer: USE master SELECT name, DB_ID(name) AS DB_ID FROM sysdatabases ORDER BY name <!– –>

The Common Language Runtime (CLR) is the virtual machine component of Microsoft’s .NET initiative. It is Microsoft’s implementation of the Common Language Infrastructure (CLI) standard, which defines an execution environment for program code. The CLR runs a form of bytecode called the Common Intermediate Language (CIL, previously known as MSIL — Microsoft Intermediate Language). Developers […]

Some developers may choose to utilize SQL’s Mail option as in some scenarios there may be different front end type web applications tied to a single type of database (in this case MS SQL 2005). This prevents the developer from having to write the same email method for each type of front end application. This […]

When restoring a MS SQL database from another server sometimes the tables/objects will be owned by the previous user on the old server. To change ownership on all tables/objects to DBO (the user you assigned to the database and gave DBO permissions) run the following query on the database (see below for last step after […]

This article will show you how to whitelist an IP address for MS SQL access on a Windows 2012 server.    Step 1.  Log-in to the server as an administrator.     Step 2.  Hover the cursor over the lower, left-hand corner of your screen.       Step 3.  The Start icon will appear.  Click Start.     […]

How to View a Report of SQL Database Disk Usage   First, remotely connect to your database by logging in to the database server using SQL Management Studio. A separate KB is available here that covers connecting to your database if needed needed: http://support.appliedi.net/index.php?/Knowledgebase/Article/View/458/84/how-to-login-to-your-ms-sql-server-through-sql-server-managment-studio-express   Once logged in, simply right-click on your database name, go to the ‘Reports’ […]

To reduce the disk usage of an MS SQL database, a shrink operation can be performed. It’s best not to shrink your database however, as this causes index fragmentation which affects performance. If you need to reduce your database size, an ideal time to shrink your database is after you have deleted a lot of old or unneeded […]