Check out the ranking functions of SQL2005.

There are a couple of good articles at CCS.

- http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

- http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/sequentialordering/2261/

- http://www.databasejournal.com/features/mssql/article.php/3773091

Especially because it is a 3th party product, I do not advise to add columns to tables.

To achieve the thing you want, create another logging table and populate that using...

As already stated, doing this with a trigger is not a good thing.

However, as also mentioned, the fastest way of doing it is using a service broker solution. (i.e. inner...

- Was the sql2000 query also remote and using linked servers ?

- are the linked server settings equal ?

- do the databases use the same ansi settings ?

- I...

Niyala (10/31/2008)

---

Thanks for the nice explanation.

How about the issue of licensing? If I have many databases in one instance, I guess I have to pay licence fee for a single...

Adding to PaulBs reply...

-application lifecycle (do all applications need the same software level and/or can they tollerate a sqlserver instance level upgrade)

- cross database ownership only works within an instance...

100% demystification 😎

CU 10 is out now buildno 9.00.3294

kb:956854

I know, but I won't ...

That would just couver their needs...

Indeed.

They are not that fond to migrate the db engine.

Their argument is: if it aint broken... don't fix it...

This means that I'll only be allowed...

Thank you for the feedback.

The majority of our databases indexes get rebuild on a regular basis

Some are not... as always ... no downtime allowed...:hehe: :ermm: :alien:

The final step on...

there can only be one DBO user in a database.

That user is actual database owner.

You can add another user using his own user.

If that user needs dbo-privileges, you'll need to...

GilaMonster (10/28/2008)

---

(10/28/2008...More likely it means that the object in question is a heap (table without a clustered index). Heaps don't have stats. Even if the stats have never been updates...

That would be a valid conclusion.

Just a little add on..

If you want to get an overview of your stats ....

SELECT object_name(id) as ObjectName

, indid as index_id

, name AS index_name

, STATS_DATE(id, indid) AS statistics_update_date

FROM...