Archive for November 1st, 2008

If you work with SQL Server on a regular basis, either writing custom queries, designing databases, or optimizing queries, this is a must see video as it covers a number of the enhancements to SQL Server 2008 including: – SQL Management Studio improvements including IntelliSense – New Data Types for just dates or times (no more […]

Lets consider a simple table called employee( emp_id, name, salary). Now, suppose that we need to create a gridview with paging. One option is to bring all the data from database and do the paging in client-side and another one is to do selective fetch. In both cases we can use a stored procedure that […]

1.Open the SQL Server express management studio 2.Connect to SQL Server using windows authentication 3.Right click the server name and choose properties 4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode” 5.Click OK and restart SQL Server 6.Go to SQL Server studio management express 7.Expand the server and choose security […]