Answer Questions

• HennieE Encryption and database restore

  Hi Can anyone help I have a database using encryption with symmetric keys created using asymmetric keys. I backed up this database and restored it on another machine along with the service master key. I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls. If I regenerate all the encrypted stored procs from scri ...Show All

• peterMarshall106 Help files for MS SQL Management Studio Express?

  Hi Are there any specific Help files to download for SQL Server Management  Studio Express . I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express I can't find reference to Studio in there... Thanks Gauguin   Hi, Here are some links for MS Sql Management Studio Express Help.   ...Show All

• mlal Service Broker Activation

  Hi I'm having problems with activation.  I have a CLR stored procedure that runs fine when run directly (and consumes messages from the queue).  When I try to enable activation nothing happens.  I've tried different execute as options and looked in the sql server logs and I don't see anything indicating why. I've checked sys.service_queues and all options look correct including activation options.  The sys.dm_broke ...Show All

• vgta tables setup

  How would I set up a sql server database based on the following problem I will be creating a poll based on 9 dimensions that compare two companies. honda yamaha performance features reliability conformance durability serviceability aesthetics safety other perceptives The values stored would be 1 or 0 so the values can be totalled. The user will be using a web page and will select a radio button per di ...Show All

• durstin Filtering Top n on Group or Table

  Hopefully someone can help. I am trying to filter either my group or the whole table to return the top 5 lines of my data. If I use Topn (Fieldname) = 5 in my filter for the group, it returns merely the total of the table and hides all the detail. If I use the same filter in the table filter, only the table header is returned. I have rather a complex formula based on parameters to calculate the field I want to show the top 5 of. e.g. ...Show All

• g.miranda How to import cube definition from SSAS 2000 to SSAS 2005

  Hi. I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done  Any suggestions would be greatly appreciated! Regards Kjetil Thank you! Sorry for the delayed reply but I'be been rather busy lately. I am starting on this project next week and will try out your ...Show All

• Mackan Opening a PDF report without the OPEN/Save Dialog

  Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF format You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET. Hope that helps, -Lukasz You can do this with the ReportViewer ...Show All

• ra7207 ReportServer giving me a 404????

  I uninstalled sql 2000 from one of my boxes after having problems running sql 2005 along side it.. I actually uninstalled both versions and deleted all the folder in the MS SQL Server folder within program files. At least the ones I could..it did tell me that some fiels were still in use Anyway I re-installed only sql 2005 with analysis and reporting services being my focus. Of course reporting services is the one that is giving me trouble. ...Show All

• Evan Haklar SQL Server 2005 Express + User Instances

  Greetings All, It was with great excitement and interest that I installed SQL Server 2005 Express along with all the other "Express" editions of Visual Studio onto my computer.  What a great way to learn a variety of modern programming languages/techniques with no investment other than time.  I had visions of a wonderful personal website that my family could enjoy visiting.  I had visions of finally being able to work on a custom ...Show All

• wazhoo Cannot open database

  My mdf file was deleted. I was able to restore the said file but unfortunately I can no longer open it. I have also noticed that the recovered mdf file was smaller than the file before it was deleted. What can I do to open the database file I have tried the following lines using osql utility. 1> use db1sql1 2> go Msg 946, Level 14, State 1, Server JDI11-31, Line 1 Cannot open database 'db1sql1' version 525. Upgrade the database to the lat ...Show All

• Leeoniya To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

  What could be wrong I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4. EXEC @rc = master..sp_OAMethod @Obj, 'Execute' The linked server is SQL Server 2005 x64. Already installed is SQLServer2005_BC_x64.msi version April 15, 2006. Local server is SQL Server 2000 SP4. I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed. Profiler in ...Show All

• ths Transforming a "?" to NULL value

  Hi SQL Champs! I have a flat file source where some data are an question mark ( ). Importing this to SQL serever, I want to exchange these ( ) with an NULL -value. How do I do this most easy in SSIS Do I need a another tmptable first, and then derived Many thaks kurlan Derived Column Transform and the conditional operator. The exact syntax will depend on what you your column is called, and the data type- [Column] == &q ...Show All

• Yingshen Error in SQL Server Management Studio Express when Attach DB

  Hello When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs: TITLE: Locate Database Files - ORION\SQLEXPRESS ------------------------------ C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA Cannot access the specified path or file on the server. Verify that you have the necessary security privilege ...Show All

• lfunk3 Why is IE SP1 Required to install SQLExpress?

  I'm looking for gritty details on why Internet Explorer 6.0 SP1 is required for installing SQL Express. Any help or direction would be great thanks! -Bathisar Hi Bathisar, We need IE 6 SP1 in order to run MMC. There is a bunch of useful information about hardware and software requirements, including more details about the IE 6 requirement, in Books Online at http://msdn2.microsoft.com/en-us/library/ms143506 ...Show All

• Richard Dalley Stopping and restarting Transactional Replication

  The situation is as follows: Database A is being replicated to database B on a networked server. The application vendor is in the process of doing customizations which require frequent table changes. So the vendor (who has access to the replicated DB) stops replication in order to upgrade some tables. But I am finding that either he has forgotten to restart replication or, more than likely, has broken it. So, if anyone is able to comment on a ...Show All