It's hard to tell what the issue might be without further clarification --
What version of SQL-Server are you using? Express, Standard, or Enterprise?
What version of ArcGIS are you using?
Did you load the point data into an ArcSDE layer? What storage format
Do you have a spatial index built?
- V
I'm Running Express 2008 R2 and Desktop Advanced 10.1 sp1.I don't know what you mean by and ArcSDE Layer. Like I said I'm a noob. I drug a table created by querying another SQL database on another machine which created the local table on my Machine.
--TRUNCATE TABLE Temp_Prod_Data;
DROP TABLE Temp_Prod_Data;
CREATE TABLE [dbo].[Temp_Prod_Data](
[client] [varchar](50) NULL,
[ownerno] [varchar](25) NULL,
[propertyno] [varchar](25) NULL,
[lease] [varchar](50) NULL,
[API] [varchar](25) NULL,
[LPD_ID] [varchar](25) NULL,
[well_name] [varchar](50) NULL,
[WELL_NUM] [varchar](15) NULL,
[COUNTY] [varchar](50) NULL,
[STATE] [varchar](2) NULL,
[OPERATOR] [varchar](50) NULL,
[YYYYMM] [varchar](10) NULL,
[ProdDateT] [datetime] NULL,
[ProdDate] [varchar](25) NULL,
[GAS] [float] NULL,
[OIL] [float] NULL,
[Latitude] [float] NULL,
[Longitude] [float] NULL,
[DEPTH] [int] NULL
) ON [PRIMARY]
GO
INSERT INTO Temp_Prod_Data (client, ownerno, propertyno, lease, API, LPD_ID, well_name, WELL_NUM, COUNTY, STATE, OPERATOR, YYYYMM, ProdDate, GAS, OIL, Latitude, Longitude, DEPTH) Exec [trinitylt\SQL2008].[LandTracker].dbo.sp_Prod_Data_5_year_Export;
SELECT * FROM Temp_Prod_Data;
The above creates the table that I use to create the XY event layer which is then exported back into my database as a feature class. Which is what I use to add the run the XY coordinate tool. Hope this makes sense.I have no idea about the Spatial index. Thanks