Setting SqlDataSource command timeout for ASP.NET
Here's a quick tip in regards to changing the command timeout for a SqlDataSource object in ASP.NET. Sometimes you'll want to increase the command timeout of a SqlDataSource object from 30 seconds (its default value) to something greater for resource intensive queries.
Read more
Find modified date for all SQL stored procedures in a database
When working with SQL, sometimes you need to know information such as "when did this stored procedure or function change?" Maybe someone that you work with fubared a previously flawless procedure. Maybe you had a brain fart and left an ambiguous field name in your query and just want to know when you made that change. Hey - its happened to all of us. Keep in mind, there ARE source control programs for SQL. I know red-gate has one. There are a few other version control programs from companies like Skilled Software, SQLDBControl, etc. Many of us (probably most of us), however, don't use these programs. So how can we find when a stored procedure has been modified? We'll take it to a query like the following.
Read more