How can i have Row number in my SELECT Statement ?
Thanks

hi all.,
How  can I find the Data Base which can't backed up for reasons
like Data Base is in the middle of the Restore  before
i start Backup Process .

After installing SP4 on our company SQL200 Standard Server, we get the
following error on all client computers (WinXP,Win2000) that are using our
local apllication that is accessing sql database
What could be the problem? No settings were changed, only SP4 was installed.

hi we have a link server....and
the user credentials are not being trasfered to link server.....any
thoughts??
we get the following error message

SQL 2000
I have inherited an application where many of the automated processes
call a proc that simply returns the number of records with a NEW
status.

I have to following Access2003 Code that needs to run in SQL 2000
SELECT
extend,
Source,

SQL Server 2000
I will to compare a normal table with a replicated audit table having
identical columns. I wish to report on the differences between the
data.

Hello! I am trying to get some information about certification for Database
Administrators.  Since SLQ Server 2005 will be released in November, will
there be a certification for  SQL 2005? or should I just take the SQL Server
2000 exams?  Any ideas out there?

I've got a stored proc that I can't change that creates a quite large
dataset and takes in 5 parameters.  I need to be able to have each of
the parameters selectable from a drop down box so that as you go
through the list of parameters you restrict the results.  I have it

I've two instances of SQL Server on the one machine. I'm using per seat
licensing. When I look in Control Panel, however, I only see one SQL Server
2000 Licensing applet, and no option to change between the instances. So
does one CAL allow you to use any instance of SQL server on ...

I'm recovering from a hard disk crash, trying to reattach recovered
files.
The MDF file seems fine, but I get:
"Server: Msg 9004, Level 23, State 1, Line 1

I have a sql query in which I need to isolate part of the columm value
and return only that isolated portion.  I can only do this within the
select statement, and cannot add a function or anything like that. I
would also like to keep this query within sql (I don't want to do this

I am sorry to ask this here but do you know a good forum for ASP ?
A

I'd like to put together a SQL statement that will take the name of a
stored procedure as a param, and return that SP's parameters.
I'm writing a test application, and I'd like to wrte a generator to
save myself some time, but I can't seem to figure out how to get the

     Hope there is a quick fix for this:
I am inserting data from one table to another on the same DB. The
insert is pretty simple as in:
insert into datatable(field1, field2, field3)