Thanks for taking the time on this one Tim.

Yes - I can join in the way you describe. I was just nervous about the efficiency - probably my lack...

It would take about 3 pages to fully describe the process (and this thread is getting close )

The permission rules are in a table like:

TABLE permissions

ObjectID...

Kind of a different need I think.

Consider this:

CREATE TABLE Document (

DocID INT,

DocName VARCHAR(30)

)

INSERT INTO Document VALUES ( 1, 'First Test' )

INSERT INTO Document VALUES ( 2, 'Second Test'...

I may not be understanding the PERMISSIONS function, but was under the impression that is only identifies that I have rights to select from the Database Table. I need...

This may not be your problem - but when we experienced something similar we found (after days of testing) that there was actually a bad sector on the disk.

Just a...

Hey Diamond V,

Tim Cartwright has an answer in another forum. Check out this URL

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B180368

Guarddata-

If you look at the routines to handle the data type of image that might help you understand a "blob" better. The basic idea is to *chunk*...

After you close the ADO object, do you set the variable to nothing?

adoObj.Close

adoObj = Nothing

This will help break the connection (I believe)

Guarddata-

You might take a look at the MDAC version. We had some problems with this between a server running one OS and the client on another.

Guarddata-

SQL 7 had an ugly way to get GMT. Something like this...

(courtesy of Microsoft PSS) :-

declare @deltaGMT int

exec master.dbo.xp_regread

'HKEY_LOCAL_MACHINE',

'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',

'ActiveTimeBias',

@DeltaGMT OUT

select getdate() as LocalTime, dateadd(minute, @deltaGMT, getdate() )...

Of course it depends on whether you are inserting through a stored procedure or directly into the database...

Let's say you insert directly. You could just create an insert trigger...

Oops - Of course if you are looking for a JOIN command, you could do this:

SELECT P.* FROM TestPerson P

INNER JOIN MatchMask M ON P.PLogin LIKE M.FindValue

Guarddata-

Rocko,

Try this and see if it works or helps..

CREATE TABLE TestPerson (

PLogin VARCHAR(10),

PName VARCHAR(30)

)

CREATE TABLE MatchMask (

FindValue VARCHAR(10)

)

INSERT INTO TestPerson VALUES

( 'Login1', 'First test login'...

Francisco

Really good question and shows that there is not always a single answer for every situation.

If there were no aggregation involved, or if the IN statement produced a number of...

You've got the right idea. Here is where I use abbreviations (perhaps too much)

SELECT GL.username, GL.password

FROM [globalLogins].[dbo].[Logins] GL, -- perhaps use (NOLOCK) here

INNER JOIN [myApp1].[dbo].[users]...