@syed Jahanzaib Bin hassan: Thanks a lot, It really helps me to understand what they really mean....

Could you please describe more ,and also if you know more functions like this...

@Gaurang-Patel : thanks, but You know, As I said he wants me something like that, I need some help if it is possible

Isn't there any solution without droping?

Shall I drop my column and all of its relations?:(

This is Terrible:(

note:I know I can use SET IDENTITY_INSERT to disable it temporarily but i need a query to remove it....

SELECT v1.name

FROM sys.columns v1

INNER JOIN sys.views v2 on V1.OBJECT_ID = V2.OBJECT_ID

and V2.NAME = 'VIEWNAME'

😀

Dear Steave and OPC,

Thanks for reply.

And No I won't rewrite on file contents, because I have a versioning system and my client wants me to save his versions.

Thank you...

😀 yes Welsh, I guess so!:D

Anyway, If you mean how many instances you can create:

SQL Server 2008 Enterprise Edition and Standard Edition support 50 instances. SQL Server 2008 Workgroup Edition supports 16 instances.

Ref: Maximum Capacity...

What do you mean?

Thanks dude,

You are wonderful!Sorry article was about SQLServer 2000 and 2005,So I want to know Is there any difference or additional feature about Full-text search in SQLServer 20008 by any...

Thanks Grant Fritchey , I didn't know that;)

Hi,

Just do these steps:

1-right-Click on database name on your object explorer

2- select "script database as"

3- select "Create To"

4- choose where do you want to generate your script.

Cheers

Ashkan

Thanks dudes;)