if you are tired of the limit of editing and selecting rows in Management studio this is how you can change it. from tools menu select options and this is how you can change it. know that loading a lot of rows affects the client machine memory to say the least not to mention locking rows in case of editing.

when installing Microsoft Dynamics CRM 4.0 on a SQL Server 2008 machine I get this error on the verification screen of CRM Service msftesql was not found on Computer <computer name> … there’s a simple fix for this problem, all you have to do is to allow CRM to update when the installer starts there’s also a KB that I wanted to include here

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

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 = ‘’ this will display all the logical file’s in the backup in the result sets you’ll need the logical file names for the coming script (the...

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 this data appears it shows two result sets the first one which is a Whole Database statistics DatabasName database size in MBs and Space in the database that has not been reserved for database...

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:     now that you have something to distinct your connection from all other users all you have to do is open the profiler window and start a new trace ==> connect don't start the trace yet   and...