I am trying to use Data-Tier applications and am going through the tutorial here.
When I get to step two the tutorial says to open Utility Explorer in the view menu. But it is not there! I looked all over the program for another entry point but I just dont see it.
I am currently running SQL Server 2008 R2 Version 10.50.1352.12 and I am connected to a server running SQL 2008 R2 Server Express.
Why cant I find it?
Are you running the Express version of SQL Server Management Studio? If so, that doesn t support the Utility Control Point stuff. Also, you re connecting to SQL Server Express Edition, and that s not able to be a control point either. You re in Enterprise territory. You can use Developer Edition to play around, though, and it functions the same as Enterprise, except you re not allowed to use it for production.
Probably you re way past this but someone else might find it useful...?
I m using 10.50.1600.1 and the utility is on the View menu of SSMS
But you don t have to "Configure the SQL Server Utility" - I have been using/deploying DAC packs pretty much since R2 RTMed and have bever used the utility.
Cheers
Mark
Please verify that you installed SQL Server 2008 R2 - with "Management Tools - Complete" option
The steps to install are mentioned in the following link: SQL Server Management Studio Missing after 2008 R2 Install
Hope this helps!
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
