When you use "Be made using this security context" you have to provide a SQL Server login and password. This option does not work with a Windows login and password.

What...

Just a thought, in case you were not aware, the instance of bcp.exe that is part of SQL Server client tools will not work against a Sybase instance so you...

What you are seeing is the same as what you would see if you ran the query in SSMS with output set to Text...even varchar columns are output as fixed...

tcloud (3/8/2011)

---

Yes.. Using pass-through authentication (I have the inside Access users all set up on that Server as "Users"). The Access users are inside of the firewall.... The...

Using a view containing the second, third and fourth columns:

CREATE VIEW dbo.MY_ATP_MD_CLASSES

AS

SELECT CLASS_SERVICE_TYPE,

CLASS_DESCRIPTION,

CLASS_STATUS

FROM...

Are you using a domain account or a local Windows account?

OK, let's pursue item 2 for now...

I do not know of any limitations with using Linked Servers when the service starts up as Local System so I am ignoring that...

What I...

Ahhh...the use of MSDASQL provider threw me off. That is the "Microsoft OLE DB Provider for ODBC". You may want to look into a proper provider to reach an Informix...

aravind-305595 (3/8/2011)

---

Thanks All, The solutions are working fine. Thanks for your inputs.

Do we have an option incase if we are not scheduling them in SQL job ? I mean if...

No worries, we're all learning 🙂

You said you don't have a DC, that your server is just in a Workgroup, but your DSN is setup to use Windows Authentication. How...

foscsamuels (3/8/2011)

---

i dont own the rights to do so. the easiest work to do on this db is custom queries. i still dont understand how their subquery can...

Hmmm...I know the technique you are trying to use to derive the table definition of a temp table from the resultset of a procedure works...I just confirmed it locally to...

Try removing Set FmtOnly OFF;

You're passing a string into a function as a parameter. That string must be surrounded by single-quotes which means that any single quotes that exist within the parameter value must...