Thanks everyone for your response.

Hope this link answers your questions.

https://www.google.com/search?q=sql+server+2008+r2+licensing+quick+reference+guide&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Thanks Jared..

I was thinking of granting individual object privileges..

This is much easier solution.

Thanks!!!

Hi,

Thanks for looking into my question...I forgot to enable the mail profile in SQL Server Agent...That solved the issue..

Thanks!!

That helped....thanks!!!

Thanks Guys...I am also curious to know what will happen to the non clustered indexes and waiting for Gail's answer on that one...

There are no LOBs on that table.

Thanks Padhis..!

I am not able to find an installer file for the below mentioned version.. (In order to create a named instance..I need the install files right..?).

Can you help me..?

Microsoft...

Thanks everyone for your response..I told the team it is not possible to do it from the DB end.

yes...O.K to accept the loss of data if it is greater than 245 chars

I proposed it...but Varchar(max) is not accepted by the team...they want to limit it to 245

THANKS for your response.

We are migrating an old application from Sybase ASE 12.5 to SQL Server 2008 R2.

Sybase does this automatic truncate..so, if the users inserts more...

I agree..but I was also learning ROW_NUMBER() yesterday only...so it was a learning experience for me anyway..!

CREATE TABLE Category

(CategoryId int, NameCategory varchar(245))

INSERT INTO Category ( CategoryId, NameCategory) VALUES (1,'A')

INSERT INTO Category ( CategoryId, NameCategory) VALUES (2,'B')

INSERT INTO Category (...

Thanks

Thanks...Is there anyway to get an installation file only the client components..?