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...

I have used bcp to transfer tables with more than a billion rows. What is the error message you are receiving?

Just so we're on the same page, and in case it changes your response...the "Native Client" driver, ODBC driver and OLE DB driver are all part of the "SQL Native...

vritaz09 (3/5/2011)

---

I dont have full version of sqlserver.In my web hosting plan i have express edition so i cant use sql server agent.so i searched about service broker.so how can...

I am seeing two separate issues here:

1. Your instance is unable to connect to other servers using Linked Servers.

2. Other instances are unable to connect remotely to your instance using...