Tag: sql server

If you have a database with millions of records on which you provide search facility to customers then you will need to maintain indexes so that the visitor experience is enhanced. SQL Server 2005 allows you to create indexes. Its …

Rebuild indexes in SQL Server 2005 Read More »

Tagged with: ,

If you have a large number of stored procedures in your SQL Server 2005 and you have to give EXEC permission to a database user on all of them then the best way to do it is by running the …

Grant EXEC permission on all stored procedures in SQL Server 2005 Read More »

Tagged with: ,

I had been working on a website based on ASP.NET 2.0 and SQL Server 2005 Express Edition. However I was facing a problem on it. Problem was that the website worked all right during the busy hours such as in …

No website response due to auto close in SQL Server 2005 Read More »

Tagged with: ,