Hi....

create proc Top_NthSal

@TOP_ID  int

AS

create table #test(Top_ID int IDENTITY (1, 1) NOT NULL  , ID int ,Salary Int)

insert into #test (ID,salary) select *  from salary_table order by salary desc

if exists...

HI...

Is ur two SPs are belonging to same DB where u trying to call them together if no then u have to qualify (for calling purpose) them with DB name...

Hi!!!

I just modify Karl Grambow little bit..........

CREATE proc Top_NthSal

@TOP_ID int

as

declare @cmd as varchar(4000)

create table #test(Top_ID int IDENTITY (1, 1) NOT NULL  , ID int ,Salary Int)

set @cmd = 'insert...

Hi!!!

Chk for this....

declare @id as int

if EXISTS (SELECT 1 FROM TABLEb  WHERE ID = @id )

BEGIN

select a.id , b.id,case when a.id > 1 then 100 else 200 end

from tableA a...

Hi...

How that will fail because of IDENTITY property.......

Hi..

May be check the property for SQL Server Agent wheather it is checked for Autostart..u find that in SQL Server Property>>>Right Click

.....

declare @id varchar(400)

set @id = (select categoryid from categories where categoryid = 1)

select (@id) as id ,description  from categories where categoryid = 1

Hi..

U can use this to check the currently available space in the current DB

SP_SPACEUSED

Hi!

Actually I m here as just maintenance of DB...... main working of DB is going on client side...yesterday what i observed disk space was just 6 or 7 GB (E:...

Hey!!

Just go through these likns that will help u bit

http://www.informit.com/guides/content.asp?g=sqlserver&SeqNum=41

http://www.databasejournal.com/features/mssql/article.php/10894_3514731_3

Hi!!

Just leave all the things..go to EM there u need to go to all task then attach db there u will ask for mdf file location...with out ldf file u...

Hey!!

I dnot how but it is working now fine...I just added new SQL-SERVER to my server group and its EM I opened then tables and then all rows..it opened as...

Hmmm....

I got error message like...

The log file for database 'Employee' is full.

Back up the transaction log for the database to free up some...

Thanks for ur kindly help Rudy!!!

I have database of 5MB......is there any king of package  setup for MSDE 2000????through which i can install my DB???