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....

Best;

by simply clicking on your name and looking over your previous posts, it's obvious that the moment you encounter a question, you post it here first without ever attempting to...

so...

Your saying CLR's are for people who know sql, or people who don't know sql...I'm confused. 😉

the way to do that would be with a scalar function then:

Create Function dateConstant ()

returns datetime

AS

begin

return '01/01/2007'

end

select dbo.dateConstant()

i might be second guessing you, but i believe you want to change the date to a PARAMETER, and not a CONSTANT, right?

If my re-interpretation is right, then you want...