
Any one send frequently asked Important questions in C# .Net, ADO .Net, Asp .Net and Sql Server. . . . . . . . tx in Advance. . . . . . Hi, Find this. . (B)What is an IL? (B)What is a objects in Remoting? (A) What are the ways in which client can create object on server in CAO model? (A) Are CAO stateful in nature? (A) To create objects in CAO page ? (I) Can we post and access view state in another application? (I) What is SQL Cache Dependency in ASP.NET 2.0? (I) How do we enable SQL Cache Dependency in ASP.NET 2.0? (I) What is Post Cache substitution? (I) Why Config”? (B) What is a SESSION and APPLICATION object? (A) What is the difference between ‘Server.Transfer’ and ‘response. Redirect’ ? (A)What is the difference between Authentication and authorization? (I) what proper? (A) If client side validation is enabled in your Web page, does that mean server side code is not run. (A)Which JavaScript file is referenced for validating the validators A)What is the use of <%@ page aspcompat = true %> attribute? B) Explain the differences between Server-side and Client-side code? (I)Can you explain Forms authentication in detail? (A)How
when you should go for them? User defined data types let you extend the base SQL Server data types by providing a descriptive name, and format to the database. Take for example type is used to store Boolean information like 1 or 0 ( true or false ). Until SQL Server 6.5 bit data type could hold either a 1 or 0 and there was no support for NULL . But from SQL Server 7.0 onwards, bit data type can represent a third state, which is NULL . Define are the properties of a transaction. For more information and explanation of these properties, see SQL Server books online or any RDBMS fundamentals text book. Explain different isolation levels An isolation level
Error while installing SQL 2005 on Win 2003 Server Hi, I have installed Win 2003 Server standard edition to work with MOSS 2007. When i tried to install SQL server 2005, it is throwing error like "Your Operating system does not meet service pack requirement for this SQL server for this release." Can any one direct me, which version of Win 2003 Service Pack this issue. Please provide me the Link for SP download. Regards Saravanan. Step 1: Download SQL Server 2005 Express Edition The SQL Server 2005 Express Edition download page has three separate
Upgrading SQL 6.5 to 2000 then to 2005. Failing at first hurdle. Need some urgent help chaps " at least when you have stopped laughint from shock" I have inherited a sql 6.5 server running on an old nt4 server. "ok pause for laughter" As you can imagine this server is crap, slow, unreliable and all the rest. Problem is its critical. Being new here shot of this system asap. So began the upgrade path for 6.5 "created an SQL 2000 server on a second machine and have tried to use the SQL server upgrade wizard.All seems to go ok untill it comes to the Upgrade of
Migration from SQL 2000 to SQL 2008 Can Anyone help me how to migrate DB scripts contains Joinnig in it. Please Tractor . Tractor_ID = @Tractor_ID AND Tractor_History . Date_Effective = @Date_Effective Please explain how to migrate these joins to SQL 2008 HI Follow these links to migrate SQL Server 2000 / SQL Server 2005 to SQL Server 2008 White paper written by experts SQL Server 2008 Upgrade Technical Reference Guide SQLCAT