What components of 2000 and 2005?

I'd say run the upgrade from scratch and pay close...

What parts of SQL 2005 do you have installed? (Check add-remove programs). What SQL-related services are running?

It's very easy to go through the upgrade and not upgrade any of the...

Leo (10/28/2008)

---

You are right, I run the full backup at 1:00AM then Tran Log backup at 4:00AM. As you said, that is completed waste of my time coz......nobody using the...

What did it install? A named instance? Did the installation give any errors?

Look in the services app. What SQL services are there?

One of my developers has written a query that when runs seems to be spawning some sub-queries (I say this because when I look in activity monitor I see multiple...

What do you mean by 'its still a SQL 2000 database'? If you mean it's still in compat mode 80, that's normal. The upgrade will not change the compatibility mode...

The RPC:completed and SQL:Batch completed are good events to use to see what's running against the server.

First thing is to capture whatever code the app is using to show the...

rchantler (10/28/2008)

---

Given that these are the access patterns and that performance is very important in this instance I will be creating 2 views, one for each of the access patterns;...

Lowell (10/28/2008)

---

I was hoping if you ran the same query, you might see simililar results and tell me what assumption I had was wrong. I'm going to fiddle with this...

Try this

SELECT A, B, C, Row_number() OVER (Partition by A, B, C Order by A,B,C) AS Flag

FROM

(SELECT A,B,C FROM OriginalTable

union all

SELECT A,B,C FROM OriginalTable

union all

SELECT A,B,C FROM OriginalTable

union all

SELECT...

More likely it means that the object in question is a heap...

In SQL 2005 you can set up DDL triggers to log schema changes.

Why are you shrinking your database?

Be aware that you will need to rebuild indexes afterwards as the shrink will badly fragment them.

Considering that you want to import from a text file into SQL, perhaps the data source should be the text file you're trying to import.

Check the account you're using to connect. Make sure that the login name exists on the remote server and the password is correct.