By default, the permissions are assigned to allow everybody with a valid login.

What else do you need?

This article can help you: http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp

--M

I tried creating an ODBC conn to one of the databases in my SQL Server Express and it worked just fine. Would the problem be a security issue? I am using the...

You can use EM to get more info on the reason of the failure. In Enterprise Manager go to SQL Agent-> Jobs. Right-click on the failing job, choose 'View Job...

declare @AcctNo varchar(10),@Code varchar(1)

set @AcctNo='aaa'

set @Code='y'

if not exists (select AcctNo,Code from myTable where AcctNo=@AcctNo and Code<>'x')

 insert into MyTable (AcctNo,Code) values (@AcctNo,@Code)

You could do

IF EXISTS (SELECT ...)

 BEGIN ...

 END

ELSE

Hello Phillip,

Thanks for your comments.

The PK in table 1 is not on col1, but on a group of columns. I agree that it would be more beneficial to have...

What about the index seek on columns col2 and col3 for the first query? in both cases those columns are selected, they have indexes, and they are not in the...

Hello Philip,

Yes, there is an index on t1.entry_date (non-clustered) with no addtional columns.

When I said "remove the join" I actually meant to replace it with an extra search argument:

SELECT DISTINCT...

I get the same error.

Here is another solution: http://www.derkeiler.com/Newsgroups/microsoft.public.inetserver.iis.security/2004-06/0579.html

I haven't tried it yet. I will post an update after I do.

That solution looks good, but you are still querying all columns regardless of the datatype they contain. If you know the value you're looking for, you know the datatype and...

You can query sysobjects and syscolumns. Here's an example for a value of type varchar:

declare @table table (id int identity(1,1),tbl varchar(55),col varchar(55))

insert into @table

select so.name as

, sc.name as [column]

from...

Hello Jessica,

Something similar happened to me not long ago.

Since I could connect using a SQL Login but could not use Windows authentication, I thought that it was an Active Directory...

I think the confusion happens when you assign the value of the substring to @strNomEmple which can only be 30 characters long. If you change the declaration to declare @strNomEmple...