Browse by Tags

SQL Server 2008 saving changes is not permitted

i was using SQL Server management studio 2008 diagram editor which i was using after years of using sql server managemenr studio 2005 whcih i think is the easiest tool for modeling Database. and i came across this message turns out there’s an option that i have to uncheck for this to work...

Posted to .net Wand (Weblog) by amir.magdy on 02-16-2010
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 (4 items)

ASPXWizard.net

Browse by Tags

SQL Server 2008 saving changes is not permitted

SQL server data base restore script

Database or Object Size in SQL server [sp_spaceused]

SQL Profiler custom filter