Tag: sql server

Adeel Sarfraz does freelance website design/development/marketing along with mobile applications

Rebuild indexes in SQL Server 2005

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 up to you to decide which columns should be indexed. Most probably those columns should…
Read more

May 11, 2009 0

Grant EXEC permission on all stored procedures in SQL Server 2005

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 following SQL SELECT ‘ GRANT EXEC ON ‘+ name +’ TO <database_user> ‘ from sys.procedures…
Read more

March 30, 2009 0

No website response due to auto close in SQL Server 2005

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 the morning and afternoon but in the wee hours of the night the website would…
Read more

January 11, 2009 0