SQL Server 2008 Management Tools Basic vs Complete Explained…. – CSS SQL Server Engineers – Site H

On SQL Server install there is an option to go for SSMS Basic or Complete. With Basic some features are missing:
You are unable to connect to Server Types other than Database Engine and possibly Compact Database Engine. E.g. Integration Services
Also many menu and toolbar commands are missing.
If you initially install Basic and change your mind and then want Complete then go to install disk and Add Features, picking SSMS complete this time

Use of SQL OUTPUT parameter with INSERT to get Identity

        Private Const InsertToolSQL As String = "INSERT INTO [Production].[Tool] ( Bin, DateLastStockCheck, DieIntroDate, DieLastUpdate, ID, NoOfTools, Notes, QtyInAvailable, QtyInRepair, QtyOut, SetNo, Tool, ToolStoresLastUpdateNowFromToolLog, ToolSupplierID, ToolTypeID) VALUES (@Bin, @DateLastStockCheck, @DieIntroDate, @DieLastUpdate, @ID, @NoOfTools, @Notes, @QtyInAvailable, @QtyInRepair, @QtyOut, @SetNo, @Tool, @ToolStoresLastUpdateNowFromToolLog, @ToolSupplierID, @ToolTypeID); SELECT @NewID = IDENT_CURRENT(‘Production.Tool’)"
        Private Const NewIDParameterName As String = "@NewID"
            Dim command As New SqlCommand
            SetCommonParameters(cTool, command)
            command.Parameters.Add(NewIDParameterName, SqlDbType.Int)
            command.Parameters(NewIDParameterName).Direction = ParameterDirection.Output
                ExecuteNonQuery(command, InsertToolSQL)
                cTool.ID = CType(command.Parameters(NewIDParameterName).Value, Integer)
            Catch ex As Exception
                Throw ex
            End Try

No display after boot

Possibly after changing something, for instance trying another monitor or tv connection, or trying dual-monitors
Start windows in Safe Mode
> Start > Control Panel > System > Hardware > Device Manager > Display Adapters
> Pick Nvidia GeForce FX5200 or your particular adapter
> Right Click > Update Driver
> I used do not connect to windows update > Install from a specific location > Don’t search I will choose the driver to install > Pick compatible driver
> The following Next actually installs the driver
> Restart your computer

Connection Strings and ( External ) Configuration Files

May put in a solution folder and add to project using Add As Link.
Then the SharedApp.Config file must have > properties > Copy to Output Directory = Copy if newer or Copy Always
For it to deploy successfully must also have > properties > Build Action = Content. This will include it > Publish > Application Files


Using External Configuration Files

External configuration files are separate files that contain a fragment of a configuration file consisting of a single section. The external configuration file is then referenced by the main configuration file. Storing the connectionStrings section in a physically separate file is useful in situations where connection strings may be edited after the application is deployed. For example, the standard ASP.NET behavior is to restart an application domain when configuration files are modified, which results in state information being lost. However, modifying an external configuration file does not cause an application restart. External configuration files are not limited to ASP.NET; they can also be used by Windows applications. In addition, file access security and permissions can be used to restrict access to external configuration files. Working with external configuration files at run time is transparent, and requires no special coding.

To store connection strings in an external configuration file, create a separate file that contains only the connectionStrings section. Do not include any additional elements, sections, or attributes. This example shows the syntax for an external configuration file.

    <add name="Name" 
     connectionString="Valid Connection String;" />

In the main application configuration file, you use the configSource attribute to specify the fully qualified name and location of the external file. This example refers to an external configuration file named connections.config.

<?xml version='1.0' encoding='utf-8'?>
    <connectionStrings configSource="connections.config"/>

The ‘VFPOLEDB.1’ provider is not regiestered on the local machine. ( x64 machine)

The ‘VFPOLEDB.1’ provider is not regiestered on the local machine
Was previously working on x86 machine.
To resolve go to My Project > Compile > Advanced Compile Options > Target CPU > change to x86
Alternatives ?

failed to create snk — unable for format error message 00000005

This is the problem – what is the answer ?
failed to create snk — unable for format error message 00000005

Strong name access denied error on Windows 7 64-bit from Visual Studio and sn.exe

Visual Studio TFS on Windows 7 – no support for Reporting Features

Visual Studio TFS on Windows 7 – no support for Reporting Features
True !!  Even if you try.
Later on could try having a virtual server with a Server os on it and then add reporting services
In the meantime I have succeeded in most of my other TFS, specifically will now have ability to use Source Code Control to allow me to work on laptop or XP machine. Also Work Item management !!
  • Windows 7 (Windows 7 Home Premium, Windows 7 Professional, Windows 7 Enterprise, Windows 7 Ultimate)

  • Note
    Client operating systems do not support integration with SharePoint Products or the reporting feature. If you want to use either of these features, you must install Team Foundation Server on a server operating system.

  • SSRS – Configure for local network access

    See next blog entry.
    This entry was written when trying to use VS-TFS reports on Windows 7. This is not possible, so do not try. However configuration below does work over home network.
    Found a TFS report cofiguration help website that said use Local System. This is for 2008 but still works
    then on this page look for “To verify or correct the configuration of SQL Server Reporting Services”
    On same page it says .. howeve the real reason in 2010 at least is because W7 does not support this.

    Documents and Reports are Unavailable in Team Explorer

    When you connect to Team Foundation Server using Team Explorer, the Documents and Reports nodes of a project may be unavailable. This is indicated by a red x on the nodes. This may indicate that the firewall on the computer that hosts Team Foundation Server does not have an exception configured for port 80. You must add this port to the exception list for your firewall application. For more information, see How to: Verify or Correct Port Assignments.


    This works – other configurations may also work
    Normal configuration
    Service account = Local Service
    Database credentials windows account
    On other computer
    Internet Explorer > Tools Internet Options > Security > Trusted Sites > Sites > http://nameofserver
    On report server computer
    Go to report manager url > Home > Folder settings > New Role Assignment > Include Content Manager

    Visual Studio TFS Over a home network ( Team Foundation Server ) ( 2010 )

    Objective: Put VS TFS on W7 and then connect to this on my Windows XP desktop so I can work from either
    7 laptop with full TFS including Source Code Control and Work Items
    Wow … round the houses but have got there … think it was really important to achieve
    I do not have a lot of network experience so thought I had to set up a virtual server. Then spent hours and hours getting Virtual Server 2005 R2 and Hyper-V RSAT on my W7 machine with the intention of then installing a server system on virtual server, then connecting to this etc etc…
    However I have just discovered that I did not need to do this.
    Make sure the Windows 7 has a user login and password
    Go to W7 Team Foundation Server Administration Console > Get Web Access URL e.g. http://computername:portno/tfs/web
    Go to XP IE and enter above address. Should be asked for a login – password. Enter this and hey presto you should be in.
    In XP Visual Studio Connect to Team Foundation Server Add server. Just enter server name if using default port numbers and path. Then connect.
    Now I am in business and can start coding -> adding value to my product 
    At last !!