I have slq2k with 0 service packs.

yes.I did that but no use.

I know about that.But how can i re use the Unused space for some other objects??

I am still not clear about it.

Thanks for the resopnse.AS you have mention if i want i can do it.How can i do it??

And is there a way i can see these free pages??

Thanks,

Meena

it has admon permissions on the box

Ok.I got it set.I had to reinstall SQL server .

Thanks,

M

it's the same.ANd how do i verify the MDAC version??

it's enabled.

The best practice is to dump the data which is needed into a staging table and then rename it to the original name.This is too fast than deleting from big...

Hi all,

I ran into the same problem and further investigating i found out that SQl server agentservices are configured to run with standard sql server account(though you see that in...

I want to merger the records and then insert them into another table.

REL03H/SECSTD,100,2/9/2003 15:00,2/10/2003 15:00

REL03H/SECSTD,100,2/10/2003 15:00,2/11/2003 15:00

REL03H/SECSTD,100,2/12/2003 15:00,2/13/2003 15:00

REL03H/SECSTD,100,2/13/2003 15:00,2/14/2003 15:00

The two records should get mergerd into one record and...

u can run the alter table alter column to change the collation.

alter table tablename alter column [test] [char] (22) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL

But you have to make sure...

you cann't just do a select * from @variable.

You first have to assign this sql to a variable and the execute it

like

declare @sql 1000

select @sql='select *from'+@variable

exec(@sql)

I mean the database not table.

Thanks

Hi,

I am curious to know whether it slows the server performance.Since one of my databases has a pocess running this command against a database since 3 days and i see...