Answer Questions

• scottportraits Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All

• gariche Trouble setting-up witness.

  Not sure where I am going wrong ... I am able to set-up the mirroring , but the witness set-up always fails. I am running all the 3 SQL servers (Enterprise edition) with same domain account, which is also a member of sysadmin locally within each SQL server. When I try to add the witness on Principal using the following command: ALTER DATABASE MyDB SET WITNESS = 'TCP://WitnessServer:7022' I have even tried the IP address with p ...Show All

• salm Error when importing Access report

  Hi! When i'm importing into ReportServer report made with Access i've got those errors: An error occurred while the report Bank Account Transactions By Type was being imported: Item has already been added. Key in dictionary: '[Bank_x0020_Account_x0020_Transactions_x0020_By_x0020_Type].Parameters![trans type]' Key being added: '[Bank_x0020_Account_x0020_Transactions_x0020_By_x0020_Type].Parameters![trans type]' An error occurred while the report ...Show All

• spacemoose sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks Deleting the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell fixed my problem. I think it was left over from the beta2 install I also have no other versions of Management Studio on my machine or ever had until I put Management Studio Ex ...Show All

• Nadirsha ODBC DSN for SQL Database

  Hi, I am trying to configure DSN for a remote SQL database using Windows authentication. When I logn with a user ID and configure the DSN, it's working fine. But when I logout and login with another user ID, DSN test is failing with the following message. Connection Failed: SQL state 28000 SQL Server Error 18456 Microsoft ODBC SQLServer Driver SQL Server Login failed for user. Can any one please let me know how can I configure DSN so that it sho ...Show All

• Rob Cannon How to run only certain tasks

  If I'm in the Data Flow tab in VS 2005, how can I select only certain components to run to test   I tried highlighting the ones that I want to run but it's running all of them in the tab...some of the components I want to take out for testing then maybe put back in later.  If I delete the tasks I don't want to run, then I end up having to recreate them Simon is right. I can't think of a situation where it is possible t ...Show All

• Wokoek SSMS Express: Create TABLE & INSERT data into table - Error Msgs 102 & 156

  Hi all, I have SQL Server Management Studio Express (SSMS Express) and SQL Server 2005 Express (SS Express) installed in my Windows XP Pro PC that is on Microsoft Windows NT 4 LAN System. My Computer Administrator grants me the Administror Privilege to use my PC. I tried to use SQLQuery.sql (see the code below) to create a table "LabResults" and insert 20 data (values) into the table. I got Error Messages 102 and 156 when I did &quo ...Show All

• Clickmaster How can I make this...

  Hi have have this problem, I have a table called PABX that has all the callings registry and what I need to do is for each client(PABX.cod_client) I have 2 types of calls (VC1, VC2) , and for these types I need to select all the registries chaging the dialed number(PABX.NRTELEFONE) for the new one (TROCAR.NRTELEFONE) and for those client that doesn't need to change select the PABX.NRTELEFONE is it possible through SQL Server 2000(via stored p ...Show All

• mailMaheshGupta authorization

  how do you alter authorization to set the database owner to a valid login and simultaneously how do you add the database diagram support objects in sql server 2005 express. thanks There's two ways to change the owner to a valid login: 1) Using the management UI    a) Right click on the database in Object Explorer, select properties    b) in the properties dialog, switch to the "Fil ...Show All

• alfieinsa need sample code in vb.net

  Hi, I neew a small sample code in VB.NET to create a custom data flow component for SSIS. All the examples I was able to find it are in C#. Answer very apreciated. There are a number of websites that provide conversion utilities to convert C# to VB. Using those will increase the amount of sample code available to you. Go to http://msdn2.microsoft.com/en-US/library/ms136 ...Show All

• Joe Hanlon datatype casting in derived column

  Here is my expression in a derived component: "Failed insert into PONL_WELL. WELL_NO=" + (DT_WSTR,10)PROP_NO PROP_NO comes from ms sql server , and the derived component datatype for this column is DT_WSTR. The destination will be ms sql server, and i have a data conversion after the derived component to cast from DT_WSTR to DT_STR. However, the derived component failed everytime giving me Error: 0xC0049064 at Load Ponl ...Show All

• spookytooth Run Variable in DataReader Source?

  Hi all, I am trying to have a DataReader Source that can run a variable which I used to store the SQL statement. For example, I have: Variable #1 Variable name: tablename Data Type: string Value: "name_of_table" Variable #2 Variable name: sql_stmt Data Type: string Value: "SELECT * FROM " + @tablename I want to use DataReader Source to run Variable #2 in the SqlCommand that c ...Show All

• jjrdk Problem when moving index with included columns to another filegroup

  Hi, This may be a GUI bug. When I manually create and then execute a script to move an index with included columns to another filegroup, it works. When I try to edit the storage property of the index through the GUI, index properties, then when I ask to generate the script for the change to the clipboard, I get an error Could not add [FirstIncludedColumn] to the collection because it already exist. Microsoft.sqlserver.Smo it works if ...Show All

• Brad Sarsfield - MSFT Redistribution and setting advanced options

  I would like redistribute SQL 05 EPRX in a small application; trying something other than Access database.  I have the program written and I have query that requires the advanced ad hoc queries setting to be one.  I am wondering if anyone can point me to an article that explains how I can adjust these settings so they will install through my setup file properly. Here is a list of all the advanced settings I found; http://msdn2.microsof ...Show All

• milanac How to import files via HTTP in SSIS

  Hello, How can I import data into SQL server via http server Thanks The script references a variable to get the file - Dts.Variables("LocalFileName").Value Or Is PhysicalApplicationPath a special path that you expect to be derived If so what exactly would you expect it to be thanks a lot, i'll try it ! Yes i saw it, but i'm novice, i don't know how tu use it ... If someone can help me So use the variable and supply the ...Show All