Is SSIS out of question here? You could create a SSIS package and deploy it as an SQL Agent job.

Check out this link: http://support.microsoft.com/kb/321686

You need to explicit grant the user access to the db and set default db to the database in which the user is to access.

Glad it worked out for...

I understand that ECDA is a sybase gateway - that can be used for replication (is this your intention?).

1) Pulling data from SQL Server - you would rely on ECDA...

Can you see any events in Application and System?

Try restarting the Windows Management Instrumentation service (WMI). Any luck then?

Ok so we have a situation with application is creating sql logins with sysadm rights and then you can't login with them. Do you have the pwd?

I would have...

Do you still have problem?

This is quite common. Sometimes vendors installs and "configures" applications that has excessive rights due to limited knowledge by the people who does the setup. The application probably needs on...

Thanks!

Some of the problems we have with backup during creation is that a different team has some scripts "they can't change". Other is daily rebuild of db's - but...

No. I pulled that number out of thin air. What I said was "If you [removed] think it'll take 80 hours of studying." I certainly don't study 80 hours for...

Braindumps are "bad" because you are not being tested. The person who took

the test and provided the "correct(?)" answers was tested, then passes the

answers on to you. Test simulations (Transcender,...

I don't have an excuse for little time. I just can't see the difference between "very similar". Please answer this question. I seem to have gotten into a sweetspot here.......

"The companies that build selft-test software build their own sets of questions that mimic what you may see when taking the actual Microsoft Exam."

How close is "mimic" to the others...

1) When installing named instances a random portnumber is applied (Dynamic port).

2) When accessing try with creating an odbc. On large networks telnet is often denied.

3) If you cannot...

It seems only the clustered resources is installed on node 2. You can run the client setup on node 2 and install the non-clustered features you like (Management Tools,SSIS etc)....