Browse by Tags

All Tags » SQL Server (RSS)
SQL Server 2008 saving changes is not permitted
Tuesday, February 16, 2010 2:55 AM
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 tools ==> options and then find this option Read More...
by amir.magdy | with no comments
Filed under: ,
SQL server data base restore script
Friday, July 03, 2009 7:29 AM
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 FILELISTONLY FROM DISK = ‘<path to your backup file>... Read More...
by amir.magdy | with no comments
Filed under: ,
Database or Object Size in SQL server [sp_spaceused]
Monday, June 01, 2009 1:02 AM
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 sp_spaceused when this is executed against your database... Read More...
by amir.magdy | with no comments
Filed under: ,
SQL Profiler custom filter
Friday, November 23, 2007 8:13 AM
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=dbName; 3: User ID=sa;Password=userName;application name=thisIsTheFilter"... Read More...
by amir.magdy | 1 comment(s)
Filed under: , ,