Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Monday, June 11, 2007 - Posts

Best way to generate DDL and data insert scripts
There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can Read More...
Posted: Monday, June 11, 2007 6:53 AM by SQL Master | 1 Comments
Filed under: , , , , , ,
Alert when a specific SQL instance service has been started
One of the IT support team member asked me the question " Is there a way to have SQL Server 2005 send some sort of email notification when it starts up? " The solution is straight forward and yes you can have such alerts or notifications based upon the Read More...
Posted: Monday, June 11, 2007 2:55 AM by SQL Master | 1 Comments
Filed under: , , , ,
SQL Server 2005 Books online May 2007 updates are available now
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For Read More...
Posted: Monday, June 11, 2007 1:22 AM by SQL Master | 3 Comments
Filed under: , , , , ,