sorry ??

You can't create a view which accept parameter's

because  a view can't accept parameters?

I THINK !!!

THE backup which you are restoring is not properly taken.

pls take the backup again

and then try to restore it!!!

Maximum size of text that you can save into a

database is 8000 characters per field?

If you want to save the text more than that

then you have to create more...

Why you are using cursors?

Can you use temp tables ? in place of cursors..

it will increase the performance of your query?

Yes!!!

you should use Cast or Convert funtion for this??

Are Bhai ?

Teri Problem Meri samazh mein nahi aya ?

Zara Samjhana To ??

My Dear Friend,

pls use the following Query :--

Sp_rename 'oldname','new name'

ok!!

pls. use the given Expression in place of that:

set =Convert(Numeric(18,5),FldB)/Convert(Numeric(18,5),Fldc)

Create Temp table of same structure

then compare the first 10 letters of the same field

in both the tables.

For this i have created a function in which you have to pass two date from to to date

and it will calculate the no.of  mondays in the given two dates

Create Function...

The most important duty of a DBA is to Normalize the relation as far as possible.

if your data is normalized then you can pick up the important decission in time.??

cursors are used when,

if you have bad database design.

my recommendation is to you pls. do not use

cursors.

Try this Query :-

select max([2]) from tbl_excel

where [2] not in (select max([2]) from tbl_excel )

----------------------------------------------

I don't exactly know how to solve but you can cahnge the name of your table?

You have not permission on such table ?

or

Your Sql server 2000 driver may be corrupt