Let's say I may possibly use two transactions in a script, the second
one will depend on the successful execution of the first one.
The following code works.  However, I'm wondering if SQL Server 2000
has some internal function like @@transaction_status to indicate the

I had Office 2003 Pro Ed on my WinXP pc and just installed the
additional Small Business Management Edition 2006 components, namely,
Small Business Accounting 2006 and Business Contact Manager.
Now in the lower right of my taskbar I have an icon for SQL Server

Somebody know how I can create a nested ranking from a analysis services
cube, using MDX?.. i mean, sort a sales ranking that show .how % of my
clients.....b.buy only 100 articles.......how many clients ....expressed in %
, buy just 200 articles parent level using a measure and then ...

Hi ppl,
I need to create a view which contains both SALES and CANCELLATION/RETURN
data.
Is it possible for a VIEW to store data from 2 sources?

IN our network with Windows 2000 server and Windows XP clients the following
problem occurs.
On our accountingfirm book-keeping is done with a prograam that runs on
sql-server. The following happens:

I've following problem. Please forgive me not posting script, but I
think it won't help anyway.
I've a table, which is quite big (over 5 milions records). Now, this
table contains one field (varchar[100]), which contains some data in

I issue this command in QA:
CREATE FUNCTION encrypt_pair (@data VARCHAR(14) , @key char(30) )
RETURNS VARCHAR (60)  AS
BEGIN

My application writes data into sql server.
Currently it converts data into XML  (an in memory XML string) and write
using OPENXML.
I want to know if i write it to a csv file and use BCP, then will it be

I have SQL Querys. Some people said me I must use the INNER JOIN, but I
don't now Why???. I need some help with the INNER JOIN. Thanks in Advance.
SELECT * FROM table1, table2
WHERE table1.tb1_id=table2.tb1_id

I have Sql Server 2000 and Word from Office Xp.  Since a few weeks, I cannot
import Data from my database towards a Word document.  I follow the
procedure, but at the end, it tells me Word cannot find the data source.  If
I use Excel, well it works perfectly.  What is the gig?

Following is my table and its content:
Year        TargetedBudget        FirstQuarter        SecondQuarter        ThirdQuarter
-------------    ----------------------        ----------------------        ----------------------        ----------------------
2000        25000            12000            11000            1000

I am trying to install SQL Server 2000 on a Win2K OS machine but I
get this error message:
  "A previous program installation created pending file operations on
the installation machine. You must restart the computer before running

Does anyone know how to turn OFF
Double Quoted Identifier Delimitation
on SQL 2000 Developers Edition SP4 running on Windows XP SP2?
All my packages in DTS seem to show Double-Quoted identifiers.

When I am trying to delete the record from flat table it gave me following
error and that record doesn't have a constraints / triggers so why it's
giving me this error.
---------------------------

Ok,
What format is this to where I can't find records (that I know are
there) using this date "2005-09-29 23:58:00".
Here is the SELECT that I use that doesn't work: