I'm trying to pass through a SQL statement to an Oracle database using
OPENROWSET.  My problem is that I'm not sure of the exact syntax I need
to use when the SQL statement itself contains single quotes.
Unfortunately, OPENROWSET doesn't allow me to use parameters so I can't

I have access to the Server (Win2003 SBS) through Remote Desktop Connection.  
I need to change the Permissions of a DataBase Role in the msde instance on
that server.  I can't seem to find a way to connect to that instance.  Is it
even possible through a Remote Desktop ...

This follows a topic in microsoft.public.sqlserver.server where I asked
a question in March, got a helpful reply and have only just got around
to doing anything.
Original topic:

Does the upgrade from per seat license in sql server 2000 to processor based
licensing requires reinstallation of sql server?Is there an easier way of
upgradation.
Tanks in Advance

My SQL server is short on disk space and I need to create a new instance
of SQLServer. I had another server running Linux with enough space left
 so i create a new partition on it and shared it through SAMBA.
Now I can use this shared disk in RW mode from the SQL server (tested ...

I'm a newb.  I'd love some help solving this apparently simple query.
table one contains email sender addresses
table two contains emails
From table two I wish to SELECT all emails whose sender address is not in

i suspect i know the answer to this already, but here goes anyway....
i have a table that has field of varchar(2048), which once in a blue moon i
need to edit the data manually (until a bad character parser validates the
data before it's written ;-) )

I have a table with 10 billion records but there are no key on it. I cannot
build a key on it as it is the data source.
However, the data source exits the duplicated rows.
I have used the DTS to transform the data into a new table and delete the

I have a web service that takes in a record to be added to a database
table, simple right?
Well one field stores a .wav file converted to a bit array and is of
the field type Text.

there are one table with a column with 16 varchar, eg. ________1245678( _
stands for space.).the database size is 15 MB.
when using bcp,
right-aligned data will be display.

A user received this message (subject line) while trying
to add a record to one table in a SQL Server 2000 database
accessed through VB 6 and ADO. The application was the
only one on his machine running against the database. The

The example bellow will receive a parameter.
create procedure usp_InsertProducts
@SKU varchar(30)
Now how do I check whether is @SKU empty or not.

I am thinking about replacing the INSERT data script
files that I have with XML files. This way I can open the XML
file using an XML Editor and see the values in a GRID and
make changes easier.

I created a temp table #t
But in tempdb..sysobjects the name is stored as
#t__________________________________________________________________________________________________________________000000000018
Any reason for extra length?

I am trying to load data from a table in MS Access to SQL Server 2000
using T-SQL OPENROWSET. When I select data from the remote database (MS
Access) using SQL Query analyzer, the columns do NOT appear in the same
order as seen in Access directly.