why not

select * from syslogins (from the master database)

select * from sysusers (from each user database)

Bye

Gabor

Definitly the solution #3.

But if you want this to make transparent you could implement a partitioned view based on the year/quartal.

So you can put the "archive" data into differents databases...

Jonathan,

I have to tell you that unfortunatly there is an error in your code

The product id 3 and 4 should have been retrived as both of...

quote:

---

SELECT "SELECT TOP " + rtrim(RowCnt) + " * FROM #T1 A , #T2 B WHERE A.UID = B.UID Group By...

I've forgotten to say that the modifications table is feed throu insert/update triggers.

So the goal is to show all rows where a record exists for one of the component table...

Just a simple info.

The guys as BMC, Tivoli, HP, MS are not able to show you more then SQLServer itselfs is able to.

An addition there are fairly expensive and also...

quote:

---

if turned on HT on my 4 ways server, the OS 'sees' 8 processors.

---

But...

Try to update the row count usage by DBCC UPDATEUSAGE see BOL

Tell us if that on has solved your problem

Bye

Gabor

Here is the answer to the multiple word firstname problem

declare @name varchar(100)

set @name = 'Marie Sarah Vigote'

SELECT LEFT(@name, LEN(@name)-CHARINDEX(' ', REVERSE(@name), 1))

Of cours is you have a name where you...

You cannot.

QA is a text based tool. It's unable to interpret the flow of bits of an image.

You need a client tool beeng able to anderstand the fotrmat of the...

Basically it depends on your application how fast your response times are.

If you have only single row selects and updates then the size of the database does not matter if...

Just an idea.

Try to make one of your index clustered.

That one will rearange your table and recreate all your existing nonclustered indexes.

If you really have a table or index corruption...

Same as above.

We would need the index definitions too to be able to determine if your query uses them correctly

Bye

Gabor

Or if this is you want, just use the:

"

use AnotherDBName

go

"

syntax. See BOL

Bye

Gabor

I do not understand well your question.

In TSQL there is no such command as connect.

First you have to connect to a server/database then you can issue TSQL commands.

Of cours you...