thanks much for all the great responces!

You guy have been a great resourse.

My guts feeling too was the system was going to kick but too from upghrading 3 levelof...

Thanks guys for pointing me in different direction.

I should beable to come up with a good list from alll the enhancemennt.

Thanks much John. That worked great.

You guys are great.

Q

Hi,

I talked to ESRI they weere a little help. They said to dot he command select @@versions which told me what verion I was on SQL Server 2008 r2 but...

We are at SQLserver 2008.

I need to justify the upgrade to my boss.

Speed is a big reason.

I checked with ESRI and they support SQQQQLServer 2014.

Thanks Scott. That worked. I know what you are saying about being in another window.

Quinn

Thanks Kirby. That link did it.

I really apreciate it.

Quinn

Did I miss anything on the etiquette page?

I was able to creat and load on of the 2 tables.

Thanks

Quinn

This is really weird.

I an get records from vectorreplica.parcels using a parcel_id from ranierannexparcels. But can't do the inner join

select * from VectorReplica.dbo.PARCELs where PARCEL_ID = '15-030-34000'

This is getting frustrating.

Quinn

Here is some data too.

INSERT INTO vectorreplica.dbo.parcels (OBJECTID, TOWN, rang, sect, parcel_id, pidcode, pidcode2,

water, hosp, fire, amb, comdis1, SCHLDIST, gisacres, taxyear, parclnbr, MultPrpN, HSTDCHOICE,

ownname, ownadr1, ownadr2, ownadr3, ownadr4,...

USE [VectorReplica]

GO

/****** Object: Table [dbo].[PARCELS] Script Date: 03/08/2012 09:47:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PARCELS](

[OBJECTID] [int] NOT NULL,

[TOWN] [numeric](38, 8) NULL,

[RANG] [numeric](38, 8) NULL,

[SECT] [numeric](38,...

Sorry it took so long to respond. Got side tracked.

I tried this from one of the responces.

update VectorReplica.dbo.PARCELS set PARCEL_ID = a.new_pid from Ranieranneaxparcels AS A

inner join VectorReplica.dbo.PARCELS as B...

I had taken the 2 DB's that were having trouble with certain files out of the maintenance plan so they would run. I just put them in to see if...

Thanks for the help.

Here is the error I am getting.

Error number: -1073548784

Executing the query "ALTER INDEX [PK_ActiveSubscriptions] ON [dbo].[Act..." failed with the following error: "Online index operations can only be...