Michael, are you saying the query optimizer would join ALL rows together before

applying the where clause? Or are you just implying that the developer may do a

select *...

K, gonna have to see if the forum gurus can answer this one now. I am stumped.

Tim C.

//Will write code for food

Yes, but they don't look nearly as stylish when "they do a hop to the left"! LMAO OK I'm done. Sorry for dragging your thread down into my corny sense...

Ken Klaft mentioned xp's on page 2 of this monster post. And yes you can NOT do xp's in VB. AFAIK

C++

is the only weapon...

Mromm, are you meaning that you do not normally like to use views for the data retrieval? Just curious as to your reasons, plus I love to debate. (Some people...

AFAIK SQL 2K Enterprise Edition must be installed on NT Server Enterprise Edition, the same as all the rest of the enterprise server apps. Since XP is a desktop platform...

I believe sp_droprolemember is what you are looking for in this instance.

Tim C.

//Will write code for food

To answer your question from ADODB use either :

1) Command.Execute

2) Recordset.Open

3) Set Recordset = Connection.Execute

My RDO and DAO knowledge is rusty, but if you want I can...

From another of my favorite sites : http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14348

Also : http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/AD35AE8F97CB9FDD852568F5004709F1

Tim C.

//Will write code for food

Edited by - TCartwright on 03/12/2003 10:15:26 PM

Ok, now jump and down, when the planets are in alignment while chanting "Ohm mane padme hum"! You should be ashamed as that answer was SO...

where is the script data coming from? RTF? Word doc? have you tried using the BCP as unicode (wide) format? I really dont have any answers for you here, just...

One reason I use views is for security purposes. I typically never grant any rights to the tables themselves, but create views for querying, and stored procedures for action querys....

You can, but it involves a BIG security hole. Let me explain something first.

Since the dawn of NT, NT out of the box was VERY wide open. MSFT took...

Be careful using the Col1 + Col2, if one of the values is null then the resulting value will be null, which may not be what you want. ISNULL(Col1, 0)...

How are you doing the exporting?

Tim C.

//Will write code for food