Ya for SQL 2008 its true. slipstream would work.

But mine is SQL Server 2008 R2.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Hi,

Created the SPN's in Active Directory but still SQL Server failed to come online.

I have created the SPN's for both Netbios name and fully qualified domain name for SQL server...

Awesome script.

Thank u so much.

Thanks Muthu.

Thanks Steve.

I can go with shrinkfile but i was trying an attempt to understand the behavior and whats written in MSDN,

Can we make any changes and observe the behaviour what...

small correction target % is 40% and not 40M.

You are right. I wanted to understand it better.

Thank you.

2. Secondly, which is my actual question, if it is a heap table or has non-clusterred or a table which has duplicate values in all columns, meaning i cannot create...

Thank You.

Thank you so much.

Thanks Gila for the help.

Thank you very much.

Thank you very much.