Answer Questions

• nbaker SQL Server 2005 Data Encryption Issues

  I read a couple of articles related to encryption topic in this forum and I feel that's really helpful I don't know if anyone has some knoeledge about the encryption issues in replication and clustering environment. I read some documents from Microsoft web site that explains how to move an encrypted database from its original server to another new server instance. That cause a lot manual works, if the database master key has been encrypted by the original service master key and you still want to enjoy the auto-open feature in the new environment. As we know the Microsoft SQL Server 2005 has a hierarchy encryption key structure and its top level service master key is really service oriented. For what kind of mechanism or set up, Microsoft ...Show All

• Gianluca Colucci Errors after installing Server 2000 DTS Designer Components

  Hello, After Having installed the SQL Server 2000 DTS Designer Components necessary to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager: "The procedure entry point ProcessExecute@@YAXPAUHWND_@@PBG1@Z could not be located in teh dynamic link library SEMSFC.dll." Is there a way to fix so that I can open Enterprise manager Thanks! If you have both SQL 2000 and 2005 client tools installed, you do not need the " SQL Server 2000 DTS Designer Components" package installed. First, uninstall them. Then figure out why 2005 is telling you to install them, when you don't need them. Make sure you have run 2000 SP4 on y ...Show All

• emericbart Complex SQL Query - Joins, Max, Union

  How to find maximum value from two tables have the same field name For example: Table -1 has field calcuated_price and its max value is 3500 and then Table -2 has same field name calcuated_price has max value is 3000. Nishith There are a lot of different ways to do this, here is another: set rowcount 1; select max(field_name) from table1 union select max(field_name) from table2 order by 1 desc set rowcount 0; Hope this Helps, Roberto Hernandez-Pou http://community.rhpconsulting.net There are a lot of different ways to do this, here is another: set rowcount 1; select max(field_name) from table1 union select max(field_name) from table2 order by 1 desc set rowcount 0; Hope this Helps, Roberto Hernandez-Pou http ...Show All

• Trevor2006 Is it possible to prevent user to edit parameters in adress bar?

  I have reports in report server which are accessed by url access with parameters. When the report is generated the whole url string is displayed in the adress bar with parameters. Is there any way to prevent the user to change the parameter value Any ideer whould be very appreciated! You could use a html form and use POST instead of using GET via the url. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=301748&SiteID=1 ...Show All

• Ted. Casting...

  I've got an ftp task that will be downloading a couple of files each night. today they're called blah20060830blah the date value in the middle changes each day. I'm trying to adjust this value with an expression. The expression doesn't want to cast my getdate function into a string that this property will accept. I know i'm missing something stupid. Thank you killerless wrote: AWESOME, thanks a lot, i'm looking forward to the day when the variable expression can be created w/ the expression builder. (I'd settle for a text area a this point) Install Sp1 and you'll be able to killerless wrote: Is it possible to call a stored procedure From a expression No! Sorry. ...Show All

• Corey Furman SQL Server with Advanced Services - Error 40 on Connection

    Before you begin swearing....... I have a VS2005 application developed against SQL Server Developer whose target database system is SQLE. Last night I downloaded SQL and built the datbase. I can connect to and manipulate the database easily with the Studio Management Console. The intention is to use SQLE locally. I can't connect programmatically to the local SQLE server. I have used the surface config monitor and turned on all protocols except VIA. I've also been through with the configuration manager. I can connect via the Studio Management Console using the information in the connection string which is: Server=BLISS/MHASQLE;Initial Catalog=KJS;User ID=aaaaa; Password=bbbbbb; Trusted_Connection=false;     ...Show All

• Nick Sheng Accessing the variable in Execute SQL Task

  I have a variable SYear with the data type Integer and the value 2005. Connection type is OLE DB, and my sql statement is: DECLARE @MyYear Int SET @MyYear = I have set the variable User::Syear as Input with the parameter name=0, there is no result set. I set BypassPrepare both True and False. However, this simple statement does not work. I keep having an error. If I put integer value directly into @MyYear, it is fine. What is wrong in here Somebody help me! This is VERY annoying. It is a type cast problem between the .Net type and the SQL type. When it can't cast the .NET type to the SQL type you selected, it just fails SILENTLY and gives you NOTHING in your task and NO ERROR. What EXACTLY ...Show All

• DQM Cannot remove push subscription on SQL Server 2000

  Hi, We have created replication from one production server to another backup server by using SQL scripts. These scripts have been generated by SQL Server after manual initial setup. When I ran these scripts they did not add the subscription for the backup server because a stored procedure were missing named something like sp_addsubscription. Therefore I ran the script on the production server and created the subscription manually on the backup server. But I made an error, I created a push subscription first but I should have created a pull subscription. Now I can't delete the push subscription. I don't even get a error message. I can't press delete and when right clicking on it I can only choose Help. The subscription has the following ...Show All

• Jeff Johnson Stored proc poor performance need help with query optimization

  I currently have a stored procedure in our SQL Server 2000 environment that will run great most of the time but periodically throughout the day it will start to run poor. Once I issue an sp_recompile on one of the largest tables (NominationScheduledQuantity with 2 million rows) in the database the stored procedure runs great again. I am assuming this is because a more up to date plan was generated. The code of the stored proc is: CREATE PROCEDURE ursp_Nom_GetDisaggNominations ( @ContractID INT, @DateGasFlow DATETIME, @CycleCode CHAR(3), @FilterZeroQuantityNomFlag CHAR(1), @TransTypePooling CHAR(2), @CycleCodeTmy CHAR(3), @CycleCodeEvn CHAR(3), @CycleCodeID1 CHAR(3), @CycleCodeID2 CHAR(3) ) AS BEGIN Set NoCount On DECLARE @TodayDat ...Show All

• kiekar Processing AS2000 Cubes from SSIS

  Hi All, I have a scenario where I want to execute AS 2000 Cubes from a SSIS package. In my Prod environment I have two servers one with the SQL 2000 database and the AS2000 cubes on it and the other with SSIS installed on it. What I am doing here is I have a DTS package with a process cube task in it, this DTS package is saved as a structured file and then I call this DTS package from SSIS using the Execurte 2000 package task. Just FYI the process cubes task is using local as the server reference. I want to know how this will work when I execute this DTS package from within an SSIS package running on a different server Appreciate all help. Thanks The "normal" way to process AS ...Show All

• Soxiz initialize pull transaction from backup

  I'm trying to initialize a subscriber from a backup for a pull subscription. The publisher was started before the full backup was made. I followed the instructions @ Books Online topic "Initializing a Transactional Subscription Without a Snapshot" http://msdn2.microsoft.com/en-us/library/ms151705.aspx and How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming) http://msdn2.microsoft.com/it-it/library/ms147834.aspx . I initialized the subscriber by restoring the db before I run the create subscriber scripts. All agents run successfully except for the following: The network setup is that the publisher and the subscriber are in 2 different domains with the distribution database at the pu ...Show All

• RWF Simple Batch program example

  Can someone point me to some examples of batch scripts that will allow me to write a simple tool which can reliably detect if any instances of SQL servers are running on a machine and if running, then their names. Hopefully the tool should be robust enough to run on diff flavors of MS Windows. Thanks YOu can use the tool SQLCMD or OSQL with the appropiate switch -L for listing the servers. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• jens_essen Quoted Identifiers in a CSV

  There have been some posts on the difficulties of handling csv with quoted identifers. I heard there were some custom components that aid in dealing with these as input files. IYO, what do you consider to be the best way to deal with csv with quoted identifiers as an input to an ETL operation Also, if you know of any bloggers making quality (hopefully free) custom components Thanks!! Personally, I've found the easiest way is to use a genuine CSV Reader,which handles all the special cases that SSIS does not. Make a Script Source Component using it. See http://www.csvreader.com/, or for a free version, try http://www.codeproject.com/cs/database/CsvReader.asp. ...Show All

• ravi_nilesh Drop Down box not showing option

  I'm using a drop down list for a parameter in RS2005. The issue comes when there is only one option. When I render the report inside the microsoft studio it works fine, but when I render the report from the Report Server (web browser) if there is only one option in the dropdown menu then it seems that it is there but I can't see it. It is a multivalued parameter. Is there a way to resize the dropdown list or any way I can fix this Any help would be greatly appreciated. Thanks for your response. I contacted Microsoft Support and they told me I needed an article Number. Do you know that number , If so, can you please send it to me Thanks again, Pilar Ok, he ...Show All

• RubenPieters ADODB and Mirrored SQL-Server

  I did setup a Mirrored Database. Connecting from it using ADO.NET works well. It goes to the Mirror if the Principal fails. But ADODB does not work. I get the error following error: 80004005 Invalid connection string attribute When trying to connect to the DB in case the principal failed and the mirror is active. (MyProductiveDB is in failover state) What do I do wrong Here is the code: ADOConn = New ADODB.Connection ADOConn.Open(CS) CS is my Connections-String: "Provider=SQLNCLI.1;Data Source=MyProductiveDB;Failover Partner=MyMirror;Initial Catalog=MyCat;Persist Security Info=True;User ID=MyUser;Password=xxxxxx;Pooling=True;Connect Timeou ...Show All