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 […]

2004-02-23

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 […]

2004-02-19

Blogs

Daily Coping 7 Dec 2022

By

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

Encryption and Data Protection Regulation

By

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

By

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

Read the latest Blogs

Forums

Blocking

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