Select Query

Technical Article

Linked Server Issues with Oracle 8.1.7

  • Topic

Hi ,I have a scenario where I need to configure a linked server on SQL 2000 Ent. Edition which connects to a Oracle 8.1.7 database. The linked server will be used in distributed transactions as well.I have done Linked Server Setup, and it is working correctly. I am worried about few things in this.1. Will […]


4 reads

Technical Article

RE: sp_spaceused tablename for each database

  • Reply

Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that says Server: Msg 8164, Level 16, State 1, Line 1 An INSERT EXEC statement cannot be nested. Server: Msg 8164, Level 16, State 1, Line 1I've […]



Daily Coping 7 Dec 2022


Today’s coping tip is to stop for a minute when you walk outside and...

Encryption and Data Protection Regulation


One of the reasons you may be considering encryption is due to the relevant...

Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Read the latest Blogs



By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

record loading

By Bruin

I have a table from a Linked Server that I'm pulling data and would...

Either/ Or Query

By dec_obrien

Hi, I have a table containing some columns and some simple data. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers