Objectowner, not db-owner

Tnx for the heads up. Could have thought that 1 up myself...

Got it! Had to place quotes round the qualified tablename:

sp_changeobjectowner 'europe\stan.loan_dim', 'dbo'

Thanks for the help.

Tnx for the response, Kenneth. I had not tried a qualified reference, but have just now. Result is the same.

I'll just have to dig deeper, I guess.

Tnx for the response, Phil.

For the second statement you could be right. The first statement does not require a DSN, but it does require a Sybase ODBC driver, which...

Tnx for the heads-up, Chris.

Tnx for the response.

On the master db: maybe you are right. However, the problem occurs with user-databases as well. On unchecking the auto-repair option: I am aware that this will...

Extra info:

Platform of the server is W2000 with the latest servicepack. SQL Server 2000 with sp3a. EM is running on my desktop, W2000 Pro with latest servicepacks. I have no...

Tnx for the responses all. I saw a discussion on faster searchtimes in a MySQL forum, could not find it anymore.

I agree, it still leaves open the question about search speed. Anyone has experienced problems related to VARCHAR vs CHAR datatypes?

You are right, Shawn, I just found out the server has been renamed....

Tnx for the response.

Got it going, tnx.

Tnx for the response. I am aware that columnorder is not that important, although the fixed-length-first is new for me. Wanting to place the column in a specific place is...

Tnx for the info, all.

I am under the impression, that when really big tables are involved it is better to create a physical table than a virtual table(# or @).

Tnx for the response guys. Martin, I will surely try your suggestion.