So basically your management are asking you to run a marathon but have chopped off your legs?

If all your view does is a select of all columns with no WHERE clause then the only reason I can think of for doing so is to provide a...

Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm

Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm

You need to allow for

CHAR(9) = TAB

CHAR(10) = LF (Line Feed)

CHAR(12) = FF (Form Feed)

CHAR(13) = CR

DECLARE 
    @ControlCode VARCHAR(1) ,
    @WhereClause VARCHAR(3)

SET...

Years ago I started off prefixing tables with tbl, views with vw etc but moved away from doing that when I found I needed to replace a view with a...

You need to look at AWE memory.

Adventures in AWE

If you look in sysaltfiles within the master database check the size * 8/1024 for the size in MB.

It certainly works for TEMPDB however, if your database was built without...

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...