Tag: SQL Server

Select all indices from a database in Microsoft SQL Server 2005

22 May, 2009 Roel van Lisdonk 0 Comments 0 categories

Select all indices from a database in Microsoft SQL Server 2005 select     [name] from     sysindexes (nolock) where ([name] not like ‘PK%’)     and ([name] not like ‘_WA%’)     and ([name] not like ‘sys%’)

Read More

Check if table has an identity column "id" – TSQL

14 May, 2009 Roel van Lisdonk 0 Comments 0 categories

declare @tablename varchar(100) set @tablename = ‘Product’ if exists (select 1 from sys.columns sc inner join sys.objects so on so.Object_Id = sc.Object_Id where  sc.name = ‘Id’ and sc.is_identity = 1 and so.Type = ‘U’ and

Read More

Stop all SQL Server 2008 BI services

11 May, 2009 Roel van Lisdonk 0 Comments 0 categories

net stop “MSSQLServerOLAPService”net stop “MsDtsServer100”net stop “ReportServer”net stop “MSSQLFDLauncher”

Read More

Who runs my slq server agent job steps

31 March, 2009 Roel van Lisdonk 0 Comments 0 categories

A nice article about the identity who is running a sql server agent job step: http://weblogs.sqlteam.com/dmauri/articles/6914.aspx

Read More

Microsoft SQL Server Profiler 2005 filter on database name

27 March, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to filter you’re Microsoft SQL Server 2005 profiler trace on database name: Check the “Show all columns” checkbox on the “Events Selection” tab. Then click on the column filters… button, you can

Read More

Microsoft SQL Server 2005 Maintenance Plan Wizard

26 March, 2009 Roel van Lisdonk 0 Comments 0 categories

This post describes the way I used the Microsoft SQL Server 2005 Maintenance Plan Wizard. When none default values are used, they will be listed below.   > To create a Microsoft SQL Server 2005

Read More