Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle 9i as a linked server
Has anyone made figured this out yet? I'm having the same problem, and I'm using Microsoft OLE DB Provider for Oracle, my oracle database is in 9i too. What's interesting is, I have two schema owners in the database, right now, queries againt tables in one schema work fine, while the other...- lisali
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL Server 2000 advice
You can change the a login ID's password via EM. Go to Security -> Logins, right click on the 'sa' login ID, select 'Properties'...- lisali
- Post #9
- Forum: Microsoft SQL Server: Setup and Administration
-
How can I execute a stored procedure from a DTS package??
I got the same problem. I'm trying to export the ouput from a stored procedure into an Excel spreadsheet. Only the field names are inputed into the file, with empty rowset. Has anyone done this successfully? Thanks.- lisali
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
