pointing out the obvious here, but this might help:

the book must exist first in your dbo.books table.

after it has been added, you can realte the book to one or more...

--create database [ ] --example where i created a badly named database

select dbid,'[' + name + ']' from master.dbo.sysdatabases

results:

1 [master]

2 ...

what was the results of the query i posted?

was it 'No Name Database' literally?

did you try drop database [No Name Database]?

somebody ran this command:

--Turn system object marking on

EXEC master.dbo.sp_MS_upd_sysobj_category 1

after that is run, all commands that create objects in SQL 2000 are system objects. this is fine if you were...

just tested it:

create database [ ]

drop database [ ]

the above works..

create database [ ]

Server: Msg 1038, Level 15, State 3, Line 1

Cannot use empty object or column names. Use a...

did you try this:

select'[' + name + ']' from master.dbo.sysdatabases

and then trying to drop the database in quesiton, including the brackets?

i think your stuck with simply generating the statements as a batch, and then running them:

like this:

select'exec sp_dropuser '''+ name + '''' as SQLSTMT, * from sys.sysusers where uid...

dunno if this helps; I've used this query in the past:

select db_name(dbid),object_name(x.objid),* from (

select * from syscacheobjects) x

in an article here on SSC, i read that the columns pagesused...

here you g; this works for both 2000 and 2005, you have to run this in each instance:

typical results:

ServerName ...

double check the table...it's problebly owned by a non dbo user...

so the table is referenced by select * from lesterlogin.lester, and not dbo.lester.

since sp_help doesn't like the owner name in...

My Dev Server for testing:

Windows 2000 Advanced Server SP4

1 Gig ram ...

here's the results of the second pass that Jeff asked for:

SQL2000/QA ...

ok here's some performance numbers from my machine, which has both SQL2000 and SQL 2005:

Jeff's inner join example took ...

I'm assuming the field is a varchar field,

you din't give an example but there's two methods to look at below;

if the values are always the same position, or the...

this isn't what you want to here, I'm sorry.

.NET does not use codes to identify it's exceptions like VB 6.0 did. In

.NET, everything you encounter is a "type", including exceptions....