When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another ...
I'm trying to find a good open source tool that simply compares data in a database on one server to a table (of the same schema) on another server. Then I want to generate INSERT statements for the ...
I have some SQL Server databases and use SQL Server Management Studio to manage them. However, I find that is not very friendly to create, design and print database diagrams (for existing tables). ...
Two quick questions for anybody that's tried this: Will Management Studio 2012 install and run side-by-side with, say, Management Studio 2008? I vaguely recall not being able to do this with 2008 ...
I'm running SQL Server Management Studio 2008 (10.0.5500.0) and was attempting to edit the built-in template "Create T-SQL Trigger (New Menu)". I open the Template Explorer, right-click the template, ...