Browse by Tags

SQL server data base restore script

this is a quick trick that i googled from bits and pieces in a caffe when my laptop didn’t have a Management studio installed i found a way to execute sql scripts to my instance of sql express well to restore you need to have the logical names of files in the database backup to know that just type RESTORE...

Posted to .net Wand (Weblog) by amir.magdy on 07-03-2009
Database or Object Size in SQL server [sp_spaceused]

Space used by the objects in the database is a tricky subject, this can be very useful when planning your database maintenance plan a system stored procedure as you probably had figured is called sp_spaceused gets you the needed information that procedure can be used in multiple ways use Northwind exec...

Posted to .net Wand (Weblog) by amir.magdy on 06-01-2009
SQL Profiler custom filter

the tip is simple u need to make a filter that filters and shows only your DB transactions on a server. what u need to do is to change your web.config by adding a string that you can later filter on 1: < add key ="Main.ConnectionString" 2: value ="data source=Server;initial catalog...

Posted to .net Wand (Weblog) by amir.magdy on 11-23-2007

Page 1 of 1 (3 items)

ASPXWizard.net