Terry you might want to try this:

CREATE TABLE #T

(ID INT

,FirstName VARCHAR(10)

,LastName VARCHAR(10)

,Email VARCHAR(10))

GO

INSERT INTO #T

SELECT 1, 'aaa', 'bbb', 'aa@bb' union all

SELECT 2, 'aaa', 'bbb', 'aa@bb' union all

SELECT...

stewartc-708166

It has highlighted an area that most people only had a vague appreciation for. well done and...

Read these article by Jeff Moden and I believe you will find your answer plus a lot more:

Cross Tabs and Pivots, Part 1 – Converting Rows...

Look up the DATEDIFF function in Books On Line at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/57e0601a-9d97-4437-9be1-7efa639b39fc.htm

The GETDATE function reference is:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bebe3b65-2b3e-4c73-bf80-ff1132c680a7.htm

The following will returrn a value of 3 as today is 10/04/09

.

SELECT DATEDIFF(day, '10/01/09', GETDATE())

Of course...

For a relatively complete discussion of when checkpoints are set read this:

http://technet.microsoft.com/en-us/library/ms189573(SQL.90).aspx

Jeff your a young wipper snapper ... heck I have a son older than you!

However, you have given me an idea for an article or whatever. "Checklist for creating a database" or something like that. I have policies on the subject, might be worthwhile...

The original question by the OP was

Just wondering if there is a way to force SQL Server to skip checking if a table or a column of a table, which...

Well we might soon know. Sent an email to the web master for SSC,...

Garadin

These were my test conditions using Developer version of SQL Server 2008 Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

/

ALTER DATABASE Test

SET COMPATIBILITY_LEVEL = 100

CREATE TABLE Dbo.NonExisting

(ABC VARCHAR(10))

CREATE...

Looking at that procedure in 2000 there is the following:

-- NOTE: THE IMPLEMENTATION (ie. using trace bit 1717) IS *VERY* LIKELY TO CHANGE,

--SO DONT EVEN *THINK* ABOUT USING THIS TRACE...

Garadin

These will compile fine if the entire table does not exist. They will not compile if the table exists but the column you're referencing does not. It will error. Try...

david.wright-948385

Darn good idea ....

Steve Vassallo

I do disagree with your end line of:

"If everything seems to be going well, you have obviously overlooked something"

Maybe if everything is going well,...

Do not know why you would want to create an SP and not know if it would function, but yes it can be done for example:

CREATE PROCEDURE Dbo.Garbage

AS

SELECT * FROM...

Can not agree with you...