Answer Questions

• DavidChai Using Symmetric key problem with encryption, decryption works fine

  Hey I had a table with a column of data encrypted in a format. I was able to decrypt it and then encrypt it using Symmetric keys and then updating the table column with the data. Now, there is a user sp which needs to encrypt the password for the new user and put it in the table. I'm not being able to make it work. I have this so far. Something somewhere is wrong. I dont know where. Please help Thanks. I used the same script to do the encryption ...Show All

• Hector Y. Martinez Error locating server/instance specified

  I am trying to connect to the AdventureWorks database while using Visual Basic 2005 Express. I am currently using the SQL Server 2005 trial version. Here is the error message: An error has occurred while establishing a connection to the server. When connecting to SQL server 2005 this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, Er ...Show All

• Dribble Cannot deploy assembly from VS.NET into SQL server 2005

  Hi, when deploying assembly from VS into SQL Server 2005, deployment fails with these error messages: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command.  The results, if any, should be discarded. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command.  The results, if any, should be discarded. I'm deploying assembly with UNSAFE permission setting. What's wrong, please Than ...Show All

• Carlik Moving a SQL Server 2000 Database from one server to another advice

  Hi, i was after some advice on moving a SQL Server 2000 database from one server to another. Usually i would do this by backing up the database on the original server the copying it accross the LAN to the new server and restoring it there. This database is 10Gb in size and copying it accross the LAN will take some time and i would like to minimise downtime if possible. The database is at a customer site where i am not responsible for the netw ...Show All

• StormForce Changing MOLAP dimensions to ROLAP

  I have a working SSAS 2005 cube running against a small SS2005 database and successfully deployed so that it can be seen across the internet, and Excel 2002 or 2003 with the correct OLEDB provider installed can view the cube in a pivot table. I want to be able to demonstrate that the cube dynamically updates when the underlying data changes. I have therefore changed the measure partition to ROLAP, and now realise that I need to change the ...Show All

• pkoanui Doing a data import using DTS Wizard in SQL Server 2005 - being efficient with 5 flat files

  Hi, I'm a new user of SQL Server 2005. I have the full version installed. I also have SQL Server Business Integration Dev Studio installed. My OS is Windows XP. I'm importing a series of 5 flat files into a database on one of the SQL Servers we have. My goal is to get 5 different tables (though perhaps I should do one and add an extra field to distinguish each import) into the database for further analysis. I tried doing an import via D ...Show All

• domi creating certificate thru backup file

  Hi, I have created a certificate and now have taken a backup of this file by the following code: backup certificate EncrProdCode to file = 'C:\BackupCert\EncrBackup.cer' with private key(file = 'C:\BackupCert\EncrPrivKeyBackup.pvk', encryption by password = 'EncrPrivKeyBackuppwd') Now i want to create a certificate IN DIFFERENT DATABASE from this file. i m using the following database: create certificate EncrFromFile from file = ...Show All

• lf3877 Problem in bulk insert

  Hi All, I am trying to perform Bulk Insert for an existing folder containing the data files into an existing destination table . I get the following error : [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\PD Data\PDDW_md_costs\Files_to_load" could not be opened. Operating system error code 5(Access is denied.).". Here Files_to_load ...Show All

• Galovesongs Calculated Measure error

  Hi. I am working on a cube for schools, precisely analysing student absences. I have two measures belonging to two measure groups where each measure group is linked to all the dimensions. These measure are : count of absences ,number of periods. The calculated measure i'm trying to do is : (count of absences /number of periods )where number of periods != 0. case when [measures].[number of periods]= 0 then 0 else ([measures].[co ...Show All

• Jean Olbrechts Moving SQL2000 to SQL2005 - COM+ Transaction Issue

  I am trying to move an application that is currently using SQL2000 to SQL2005 Production environment: Server1: Win 2000/SQL2000 Server2: Win 2003/IIS/COM+ & ASP Trying to move to: Server1: Win 2003/SQL2005 Server2: Win 2003/IIS/COM+ & ASP The problem is that when a COM+ control tries to start up a transaction I keep getting the following error: error '8004d00a' : New transaction cannot enlist in the specified transaction ...Show All

• I.Blagoev Report Needs only PDF Export Format

  Hi, I have around 20 report in my testserver.In this 5 reports needs to export only in PDF format. The Other 15 reports are needs to export in PDF,Excel,CSV and TIFF formats. I am using Reporting Services2005 for developing reports and also using VS2005. Any suggesstions appreciated. Thanks, Prabu You may be able to write some Javascript or report code to remove items from the list after the page is rendered. ...Show All

• rpsingh rana Exporting Report Builder Tabular Report to CSV

  A simple tabular Report Builder report was written to feed another system that requires quoted CSV. I have two issues when exported: 1) I can't get control over the exported column names. Currently, they are exported as "FIELDNAME_Value". When I try to change the column headings in the designer, it has no effect on the exported column names When I create a New Field and specify my desired column name (e.g., COMPANY), the e ...Show All

• Takrim Khan Drop Down Parameter List

  I have a string with values that are separated by a space. It looks like this: DAY MICS SUN FIX STD . I would like to take the string and make it a drop down list in a report parameter. I have tried the split function but it errors on me. How can I accomplish this Is the value dynamic If not, could have manually put into parameter list If it's dynamic, I think best way is to use a Query for the param ...Show All

• Simon Brangwin Grouping by custom datepart for shift patterns

  My application has a log table with a timestamp field which represents the time when the record was inserted. We would like query the the table and group the results into date units based on the value of the timestamp. The grouping specification is held in another table but only specified for a single week. For example WeekDay Start End 1 06:00:00 14:00:00 2 08:10:00 17:00:00 What this specif ...Show All

• skibumb How to upgrade from SQLXML3

  I have written a whole bunch of XML and XSD files for SQLXML3 but now with Yukon-Beta2 I find no way (and the docs pretend it has never been there) to actually use these files with SQLXML4! ! It can't be that I really need to re-design all these schemas and convert them to SP's and then REWRITE my apps which used XPATH over HTTP queries to utilize the new SOAP functionality. Any help would be apprechiated! Hi Todd, thanks for the answe ...Show All