SELECT * FROM syscolumns where id=object_id('dbo.yourtable')

The NEWID function generates a GUID

One problem I have had with IDENTITY columns is that when I use the

SET IDENTITY_INSERT dbo.tblAnswer ON
     INSERT INTO dbo.tblAnswer(fields....) VALUES(...)
SET IDENTITY_INSERT dbo.tblAnswer OFF

The identity...

Yes it is possible.

Simply use fully qualified names for your objects.

Northwind.dob.orders (database.owner.object)

If your databases are on different boxes then you can use BEGIN DISTRIBUTED TRANSACTION.

ROLLBACK and COMMIT are the same...

select

object_name(i.id) AS TableName,

c.name as FieldName,

I.Name AS IndexName ,

objectproperty(object_id(i.name),'IsPrimarykey') AS IsPrimaryKey

from sysindexkeys as ik

inner join sysindexes as i

on ik.id = i.id

and ik.indid = i.indid

inner join syscolumns as c

on ik.id...

Chances are one or more of your tables is locked.

Try running sp_lock or looking at the current activity in Enterprise Manager.

One possibility is to break down your update into small...

Standards always lag behind current developments. They have to.

I find it hard to get enthusiastic about SQL-92 when we are in the last half of 2006.

If you are a...

Solution for constipated mathematicians, work it out with paper and pencil, if that doesn't work use LOGs

Consuming XML isn't hard, it's digesting it and it makes my eyes water to parse it.

I've used it for what it is supposed to be used for. Separating content...

If I ever get to the States it will be beers all round.

I don't have many ambitions in life but I would really LOVE to have a game of baseball...

In my first job we had a guy ring up the IT department and ask

You know these computer viruses? Can humans catch them?

This from a guy who forgot his...

In nearly 20 years I've always been fortunate in that I have worked for companies where extra hours over those in the contract were recognised. Not always in financial...

If I remember correctly Lotus Approach relies on the old DBF format.

You could use a DTS package to export the data you want into suitable DBF files to use for...

A primary key is a special sort of unique index.

The difference between an primary key and a unique index is

• A primary key cannot contain a NULL value
• A primary key is...

I'm wondering if it has something to do with caching.

QA will be running this query from scratch. Perhaps the SQLSERVERAGENT has an execution plan cached in some way.

If you...