I thought this was a really interesting question - and a pretty tough one, too!  Google didn't help at all, and the old lists of undocumented DBCC commands don't help,...

Hey Brian,

This is much better than what we had before.  Of course, I may be a little biased... 

I know this is...

Visbek,

The stored procedure is more efficient because it does not have to be parsed, optimized, and compiled repeatedly at run time.  However, in this case you are using dynamically executed...

Hello visbek,

You cannot use a variable for a tablename in a SQL statement.  You can, however, dynamically execute a SQL string.  The code below shows how.

OK, I miss being a Forum Guru.  Are we going to have a poll on names for the different levels (democratic approach), will the site admins just unilaterally decide (corporate...

Glad you're finding the kind of info you needed.  By the way, I saw that somebody else posted a script that takes fixed server roles into account.  It can be...

OK, I've seen the answer in today's daily email, and it's an interesting concept in an academic / historical sort of way.  But if the firewalls have the ability to do...

I scored 46%, but I was probably biased - giving myself the benefit of the doubt, leaning toward the geek side.  Is it geeky to give true confessions about things...

Alzdba is probably right about you needing to either reboot or at least restart the SQL Services for everything to work completely.  I know that I've had to do this...

Try something like this:

exec sp_msforeachtable 'select ''?'' as tablename, id, datumarchief from ?

    where datumarchief is not null'

Is that what you...

Well, how about that?  I feel like I'm hobnobbing with the Big Names now.  But, you see, I had to be online Saturday ... because Sunday was my daughter's birthday! ...

Hello Dinesh,

English Query itself provides a sample or two of how to use VB to interface with English Query.  See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/eqbol/eqconcpt_5egi.asp for details.

Hope this helps!

Chris

I came straight to the discussion today, and didn't even hazard a guess - the question does not provide enough information, in my judgment, to categorically say that one of...

Did you read the post Ray mentioned?  Our procedure is based almost entirely on the sp_help_revlogin procedure, which is available at http://support.microsoft.com/default.aspx?kbid=246133 (the same link Ray mentioned).  Compared to the...

Rajesh's idea about CONCAT_NULL_YIELDS_NULL is an excellent one, but IIRC, this setting is SET by default in the Query Analyzer and NOT SET via ODBC.  However, Rajesh still could be...