SQL Server This is the SQL Server tips area of programmingtips.co.uk http://programmingtips.co.uk Tue, 07 Sep 2010 02:47:28 +0100 FeedCreator 1.7.2 http://programmingtips.co.uk/images/M_images/rss.png Programming tips rss feed http://programmingtips.co.uk This is the SQL Server tips area of programmingtips.co.uk How to create the default aspnet membership tables in SQL Server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=74&Itemid=10 One of the things that I keep having to look up is the command to create all of the default... Thu, 15 Jul 2010 21:55:58 +0100 How to get a list of views in sql server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=69&Itemid=10 To get a list of views you can use the following querySelect * from sysobjects where type = 'V' and... Thu, 28 Jan 2010 22:18:18 +0100 How to get a list of stored procedures in sql server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=68&Itemid=10 To get a list of stored procedures in sql server you can use the following querySelect * from sysobjects where... Thu, 28 Jan 2010 22:17:18 +0100 List connections on sql server 2008 http://programmingtips.co.uk/index.php?option=com_content&task=view&id=62&Itemid=10 How do I list all of the connections or view the total connections in use on SQL Server 2008 The... Sun, 13 Dec 2009 20:28:08 +0100 Enabling AgentXPs in SQL Server 2008 http://programmingtips.co.uk/index.php?option=com_content&task=view&id=55&Itemid=10 To run maintenance plans you need to have AgentXPs enabled.To enable this in SQL Server 2008 usesp_configure 'show advanced options',... Thu, 03 Sep 2009 19:28:44 +0100 How do I list all of the identity columns in a SQL Server database http://programmingtips.co.uk/index.php?option=com_content&task=view&id=31&Itemid=10 SELECT OBJECT_NAME(OBJECT_ID) AS TABLENAME, NAME AS COLUMNNAME,... Wed, 31 Dec 2008 14:22:20 +0100 Commands for managing identity columns in SQLServer http://programmingtips.co.uk/index.php?option=com_content&task=view&id=30&Itemid=10 DBCC CHECKIDENT There are a few options that you can use for this command: The first option will show you the current... Wed, 31 Dec 2008 14:18:22 +0100 How do I replicate identity columns in SQL Server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=29&Itemid=10 Replication of Identity columns in SQL Server is a tricky business you will need to bear in mind the following:- Make... Wed, 31 Dec 2008 14:09:50 +0100 How can I update a column value in all tables in SQL Server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=28&Itemid=10 This query will write out a SQL Query, which will Update a Column Value in All Tables First, open SQL Server... Wed, 31 Dec 2008 13:59:05 +0100 Multiuser temporary tables in SQL Server http://programmingtips.co.uk/index.php?option=com_content&task=view&id=20&Itemid=10 SQL Server can allow temporary tables for each user for example ALTER PROCEDURE dbo.JGR AS Declare @Yaks table (... Fri, 28 Nov 2008 21:54:56 +0100