Greetings, that is my situation as well. Visual Studio is not installed nor are any other visual tools. The procedures were created when I did a backup via the enterprose...

Jeff, thank you for the reply. I'm not sure what you mean when you say "it only creates them when the first instance is needed." Can you elaborate on that...

Greetings, It turns out McAfee was causing the failure. Problem solved. Thanks.

Greetings, yes, I realize now my post was vague. Let me see if I can amplify. When using Oracle it is possible to install Oracle's Advanced Security Option piece. By...

Jay, without more information I am not really able to assist further. The first thing I would suggest you do is find the DBA for the Oracle database, you are...

DOcumentation for the import/export utility can be found at http://www.oracle.com/technology/index.html. Look under the version of oracle you are using for the utilities manual. It documents import/export. I am assuming...

It appears that syslogins is the view I want to look at. The syslogins view shows WIndows Users and their access to the database, isn't that what sp_grantlogin impacts? The...

THe reason for the question is that some time ago I had issued the command

exec sp_grantlogin '<user>'

and had forgotten which user I had issued the grant to. I wanted to...

Greetings, what is the combination if sp_grantlogin has been issued for a particular user?

Thanks.

I did switch once and it worked fine.

Greetings, no, I never did receive a definitive answer to this question and I still see it happening. I check the data on both servers and things appear to be...

Thanks for the responses. I guess the more basic question I am hoping to find the answer to is when does the LSN get updated? Is it the actual database...

Thanks to everyone for the responses. I requested 4GB of memory.

Hello, it turns out it is necessary to set AllowInProcess for the Oracle OLE DB drivers. DOing that resolved the problem. THanks.

Carolyn, I tried that but am still encountering the same error. I am beginning to wonder if this version od SQL Server is compatible with the Oracle 10gR2 client. Do...