I have installed to Adaptive Server Anywhere Driver on our SQL Box, yet when I use it to link to the Sybase box I'm still getting a ODBC error. "No...

Your right!

Thanks

The only thing I would suggest is to save the DTS packages to VBscript and do your editing that way.

HTH

Marty

Our IT department is broken up into three groups, Development, Network and SQL Admin.

The Development Group has no “sa” access to the production servers at all. If a change...

Got it..Works great! Thanks for your help.

Marty

I receive the same output as before.

Is there a way just to select the last 3 times a company was called and ignore the rest?

As in:

Campany ...

I think the configuration file is the settings derived from: Tools – Options - then setting/saving the parameters for your instance of ISQLW.

Hope this helps.

Marty

Check out http://www.cdolive.com/kb.htm

Hows this:

update titles

set pub_id =

(select pub_id from publishers

where pub_name = 'Godel Publishing')

where type = 'business'

Are you trying to use a subquery? Like:

UPDATE emp

SET deptno = 31

...

I hate to admit it but your Director is on the right path. If you are a developer and the DBA, SOX dictates that you cannot have full access to...

Most Excellent!

Thanks for your time.

Marty

Check out

http://www.databasejournal.com/features/mssql/article.php/3296731

Can you write a sub query to insert the defaults?

INSERT INTO tblA

(A, B, C)

SELECT A, B, C

FROM tblB

WHERE tblB.D = '?'

Sorry for not being clear.

What I am trying to accomplish is:

Using - Where Flags & 2 = 0

Flags are a preexisting index. What I would like to do is have...