I tried installing the same in another PC and it worked.So can i install sql server 2008 R2 RTM in a windows 8 pc? According to link (http://blogs.msdn.com/b/sqlexpress/archive/2012/03/02/sql-server-express-and-windows-8.aspx)...

Hi nicbyte

Do you mean that install directory is corrupted or what?

Config file is properly configured for new installation.Setup path config file path and all parameters are proper. Also i have doubt that should i enable .net 3.5 to install sql...

hi nicbyte

I have config file and setup file in the same folder.

Does .net 2.0 is required only for installation of sql server 2005 express or does it used by sql server for it's working?

If i go to SQL Server Installation Center and click on Installation hyperlink and then on new installation.. then it asks for installation media.(from link http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/F6C35A03-B98C-46F1-8010-0A76DF8773D5)

Can i install...

So should i run the setup again? Or is there any other method by which i can install new instance(named instance) by using already installed sql server.

No. I don't have any triggers in customer table.

Here is complete details on what problem i am facing

Problem with “ExecuteNonQuery’”:

We are using VB.Net & in the below code sample ‘ExecuteNonQuery’ method returns -1 while executing Insert & update...

The query i have used is insert into [customer]([Id]) values('531067')

And another one is update statement

update [customer] set [Call attnd]='ses' where Id = 531067 and (Ltrim(Rtrim(cast([Call attnd] as varchar(max)))) = ''...

ok, got it.

Thanks

But i want to check sql is installed or not through code.So registry check or some other codes will be helpful.Anyone please come with a solution?

under 'snapshot' transaction , whether the entire database snapshot is taken? (during begin transaction statement is run) or only required rows snapshot is taken ?(during select statement)

thanks.

Thanks for the reply.

Thank u all. I can use filtered index.