Hi Gurus
I have a sproc that checks a certain  field in our software. It is to prevent
users from entering alphabets. The problem I have now is that this sproc is
looking for a number to be in there. I need to only raise the error when

Hi - I'm getting this error on a merge subscription between two SQL 2000 SP3
machines. The agent has been working fine for many weeks and nothing obvious
has changed.
Calling up details on the error doesn't give any further info. I've even tried

I have a stored procedure that generates a temp table.  During tha
process, the temp table is altered to add a new column with NUL
values; as follows
ALTER TABLE #Temp2 ADD [LOS] int NUL

I have a txt file of 200mb elevation data.
There are 3 Columns (latitude, longitude, elevation). I have created a db in
sql server called Elevation and imported the data fine. I want to sort out
the locations by elevaion (which is the primary key). In SQL Analyzer,I have

I am creating a stored procedure that will perform a search against a
table. I am passing search parameters to the SP. If the user did not
select a value on the front end, then I am passing NULL into the SP for
that field. So my question is, what is the best practice to only search

I'm trying to port some data from one database table to another
database table on the same server.
This is the query I am using:
----->

Does anyone have any suggestions on an approach to speed this up
please?
I need to check a given column in a given table to see whether there
are any characters within any of the records that fall outside of a

Hi Group!
I would like to get a list of all the table names from a database, can
anybody please tell me how to do that? Many thanks!

I am trying to add another column into each subquery, but I am receiving the
below error.  Query is below
Only one expression can be specified in the select list when the subquery is
not introduced with EXISTS.

The third edition of SQL FOR SMARTIES was just released.
http://books.elsevier.com/us/mk/us/subindex.asp?isbn=0123693799&country=United+S
tates&community=mk&ref=&mscssid=S6KSJJEP0NU19NPCDAVNKEJMF3HA1L99

I'm getting the above error when i try to fill a Dataset through a
dataAdapter.
I presume it is to do with the sql statement. Below is the relevant
code:

hi gurus
the scenario
Frontend - MS Access (not yet decided whether MDB or ADP)
Backend - MS SQL Server

My question is that can I configure SQL MAIL, if my EXCHANGE
SERVER is on different domain and my SQL is running on different
domain.Can anyone guide me for this because I googled a lot
without any result.

If I had two machines, one an application server and the other a Data server
and the application server was running a whole lot of webservices and the
data was shot through and stored on the data server ofcourse.
If I used SQLSERVER as the data server, how many SLQ client licenses ...

Where can I find the best instructions for setting up Automated nightly Full
backups with transaction log backups every hour or so during the day ???
I've seen  a ton of theory and discussion about Simple, Full and Bulk Logged
backup modes but very few complete examples of how to ...