I have exactly the same two databses.

PROD database is on SQL Server 2000

DEV database is on SQl Server 2005

I run the same query with SET STATISTICS TIME ON.

PROD results

------------

SQL Server...

I was silly.

I didn't realize it was just an extract file

and I had to run "setup.bat" from

C:\sql2ksp3\ folder

Sorry.

I checked.

DB2 account works on DB2 server.

I was able to execute SELECT in Command Editor

using this account.

I'm trying to analyze prod configuration

and see what might be different on DEV box...

Actually Linked Server with these credentials

was registered successfully on production SQL Server 2000 box.

But nobody documented this or scripted the process.

It was done through Enterprise Manager.

Now I need to have...

Hi Jack,

I liked the second one

SELECT

*

FROM

SCHEMA.scan S INNER JOIN

SCHEMA.policy P ON

...

"Readable" means easier to understand. More logical.

The query is supposed to return 1 record.

Your version returns 23 records.

You changed the criteria.

My goal is to re-write it so that it is...

That's the challenge.

Nobody knows the rules.

In the last 4 years the company had

a bunch of junior programmers who

coded it in different ways.

Now the company is asking me if...

That's it.

I figured it out.

The only way to have a GUI environment in 2005 that is similar

to Enterprise Manager "Open table/Query" feature

is:

1. right-click on table

2. click on "Open Table" (this...

Jack,

SQL is being executed in "USFRET" database.

I updated the original posting.

productversionproductleveledition

-----------------------------------------------------

9.00.3175.00SP2 Standard Edition (64-bit)

Guys,

I'm not talking about scripting what you do.

I'm talking about designing query in GUI.

Sometimes it helps to visualize things. Especially if it's a new database

you are not familiar with.

So far...

But in SQL Server 2000 I didn't have to create any new objects,views.

I could design a query and close it.

(Highlight table name, right click, query)

Carl,

I executed your version

but it hangs. It is executed for more than 1.5 min

and I cancel the query.

The original query returns results in 5 sec.

What are synonyms and how you create them?

Shema and indexes:

USE [USFRET]

GO

/****** Object: Table [dbo].[box] Script Date: 05/09/2008 10:34:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[box](

[boxid] [char](10) NOT NULL,

[formid] [char](10) NULL,

[dispenserid] [char](7)...