If you look at the sys.sysobjects view, you will see an xtype column listed Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L…

There are 13 new videos on channel 9 posted about SQL Server. The non-marketing videos (by engineering PMs) give customers peek into the goals and visions why certain SQL Server features were decided and implemented. Below is a list with a little blurb…

This post is based on a question I answered earlier today, someone wanted to check all columns that allow NULL for NULL values in all tables. The reason people might want to do this check is that they want to make all the columns not nullable in a database (after all we all know that developers hate NULLs).

The Stored Procedure below is based on the code that George Mastros wrote for the following blog post:

I have a bunch of processes that run at then end of the day. Some of these processes are configured dynamic since table names, server names, database names and a whole bunch of other stuff might change. SO you migh have a (over simplified here) table l…

This is just a quick blogpost that will show you how you can use T-SQL to get the command line startup parameters that were used to start SQL Server. Before I start I want to warn you that you do not try NET START and NET STOP on a production server since you might mess stuff up big time!!.

In order to start SQL Server with parameters we can use the configuration tool or we can use the command line, of course we will use the command line

I advise you to read the

If you ever try to debug a script task by setting a breakpoint and the package is on a 64 bit machine it will just ignpore the breakpoint.

I ran into this problem myself a while ago and this week a co-worker also ran into it and asked me how to resolve it.

It is pretty simple, all you have to do is click on Project, then select Debug Properties. Under Configuration Properties, click on Debugging. Make Run64BitRuntime False. See image below.

This will not work on SQL Server 2000 since the sp_refreshsqlmodule does not exists on that version!

A while back in the What is deferred name resolution and why do you need to care? blogpost I showed you that sp_depens is not reliable because you can create procedures that reference objects that have not been created yet.

You can use sp_refreshsqlmodule to help 'fix' that

let's take a look at how that works

First create this awesome stored procedur...

If you want to show a 1 when there is a value for something in the column and 0 if none of the rows have that values you typically do something like this

If you have a bunch of User-Defined Data Types in your databases and you would like to get a list of them then you can run the following query

On SQL Server 2000 and up

So I posted a teaser in the puzzles forum. Without running this, try to guess what will happen?