Sorry Andreas... That's absolutely incorrect and you really need to check your facts before making such an unqualified statement... Try this... insert a column in the middle of an existing...

You are partially correct... all of the SQL objects will be constructed from what is in the MODEL... However, the listing from sysfiles shows the following file names for the...

Heh... I missed THAT!  Not only does the table need some fixin', but you do need to add some memory!  My desktop box has a gig... a server running standard...

Cory,

Great idea but, the Model DB files don't show where new files would be made (as a default)... they only show where the current Model files are.

For the other DB's, then sysfiles...

KBrown,

You all set?  Michael's solution seems to do what you asked but just making sure (pretty cool sequence generation function he's got there, huh?) because of the duplication of stock...

You DO need to access the registry... You can either do it from the front end or you can read them using the unsupported xp_RegRead stored procedure.  For SQL Server...

Yardstick?  Is that anything like the 2x4 I normally use?

Oh yeah... almost forgot... you need a complete list and script for any triggers that may exist on the table as well as a complete list of views that use...

Ok, I can tell you're just a little nervous about this whole thing and I don't blame you one little bit... so, here's the plan and why I asked the...

Nope... I've seen this before... I call it "chain" join.   If we look at Wade's join "chain"...

FROM Inventory AS I

JOIN Block AS B

JOIN Phase AS P

JOIN ProjectSub AS PS

JOIN...

Only way that could happen is if group_sec doesn't exist...  what do you get when you run the following?

SELECT COUNT(Group_Sec) FROM TestTable

They do the same thing where I work and it drives me nuts... what's the purpose of an archive?  Right... to move infrequently used data out of the way for...

Using a cursor to do a simple "UPSERT"??  You an Oracle programmer, Simon?

Real answer is... don't use a partitioned view.  SQL Server can handle huge tables.

Here's the schema you posted...

CREATE TABLE [dbo].[IISlog] (

 [date] [datetime] NULL ,

 [time] [datetime] NULL ,

 [c-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [cs-username] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [s-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS...