Sunday, September 1, 2013

[SQL 2012] SQL Refactor Studio - useful addin for Microsoft SQL Server Management Studio 2012

[SQL 2012] SQL Refactor Studio - useful addin for Microsoft SQL Server Management Studio 2012

SQL Refactor Studio - useful addin for Microsoft SQL Server Management Studio 2012

Posted: 01 Sep 2013 12:04 AM PDT

Good day!We would like to present you SQL Refactor Studio [url]http://sqlrefactorstudio.com[/url] - Addin for Microsoft SQL Server Management Studio 2012 (SSMS).This tool allows you to:- Search for the database object dependencies (search is performed in the database, the files on the disk, editor, SQL Query Editor)- Find any text / code in the database, the files on the disk, editor, SQL Query Editor- Perform refactoring databases (Rename, Add CRUD Methods, Move Columns, Add Lookup Table, etc.)To date, the Addin is only compatible with SSMS 2012 (SSMS 2014 in the plan).In the following releases, we plan to add the ability to format SQL code, Intellisense, and extend the set of refactoring methods.If you have any suggestions / comments regarding the functions of the instrument, do not hesitate to email us at [email]support@sqlrefactorstudio.com[/email].We will certainly consider your comments.______________________________Sincerely,SQL Refactor Studio Teamhttp://sqlrefactorstudio.com/

SQL Server 2012 developer tools

Posted: 31 Aug 2013 11:54 PM PDT

Hi all,I have a quick question for you. What software would i download to get a database developer access to a dev server via a query window with Integration and reporting services?I'm confused.. do I require Developer edition, SQL server data tools or SSMS on its own?Thanks!

service pack 1 setup a network-related or instance-related error occurred while establishing a connection to sql serve

Posted: 31 Aug 2013 04:25 AM PDT

Hi I encounter the following problem when I upgrade sqlexpress 2008 to sqlexpress 2012.service pack 1 setup a network-related or instance-related error occurred while establishing a connection to sql serverI found a suggested solution from http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/I've ensured that sqlexpress instance in sql server configuration manager is turned on.I still could not resolve the issue.any assistance is really appreciatedmy os is windows 7 and rdbms is sqlexpress2012 sqlexpresshere's my upgrade log[left]Detailed results: Feature: Database Engine Services Status: Failed: see logs for details Reason for failure: An error occurred during the setup process of the feature. Next Step: The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=SQLEXPRESS Component name: SQL Server Database Engine Services Instance Features Component error code: 0x84BB0001 Error description: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xBA6E21AA%400x9A41B222&EvtType=0xBA6E21AA%400x9A41B222 Feature: SQL Server Replication Status: Failed: see logs for details Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Next Step: The upgrade process for SQL Server failed. Use the following information to resolve the error, and then repair your installation by using this command line: setup /action=repair /instancename=SQLEXPRESS Component name: SQL Server Database Engine Services Instance Features Component error code: 0x84BB0001 Error description: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xBA6E21AA%400x9A41B222&EvtType=0xBA6E21AA%400x9A41B222[/left]thanks

Free SQL Server Management Studio Utility to get database object information quiclky and easily

Posted: 31 Aug 2013 06:58 AM PDT

Check this outhttp://pvakati.blogspot.com/2013/08/free-sql-server-management-helper.html
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog