Answer Questions

• jayaseelan Encrypting data across replication

  We are looking at setting up peer-to-peer transactional replication between two databases. We have a customer requirement to encrypt the SSN in this database. I have configured replication successfully. I have also successfully encrypted the SSN using a symmetric key (with encryption by certificate). What I haven't done yet is set up encryption to work across a replication topology. What steps would I have to follow in order to be able to encrypt the SSN on one server, replicate it to the subscriber, and then decrypt the SSN on the subscriber For this scenario, is there a better way to handle encryption other than a symmetric key encrypted by a certificate As a followup question, I have one field -- ...Show All

• reya276 create table from select result

  Hi, I need to create a table which has the columns from the select statement result. I tried in this way drop table j9a SELECT er.* into j9a FROM caCase c LEFT OUTER JOIN paPatient pp ON c.caCaseID=pp.caCaseID Left Outer JOIN paManagementSite pm ON pp.paManagementSiteID=pm.paManagementSiteID Left Join exexposure ee ON ee.cacaseID=c.caCaseID LEFT OUTER JOIN exExposureRoute eer ON eer.caCaseID=c.caCaseID LEFT OUTER JOIN exRoute er ON er.exRouteID=eer.exRouteID WHERE c.caCallTypeID =0 AND c.Startdate between '1/1/2006' and '12/1/2006' AND (ee.exMedicalOutcomeID=4 OR ee.exMedicalOutcomeID=10) AND pp.paSpeciesID=1 AND c.PublicID_adOrganization_secondary is null declare @1 int,@2 int,@3 int,@4 int,@5 int,@6 int,@7 int,@8 int, @9 int,@10 int,@11 ...Show All

• Morten Dahl Error Starting Script Editor in SSIS

  I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! Your idea is on the right path. My ...Show All

• noobiepersonC# How to move variables between packages??

       hi,         Is there any way to export a set of variables from each other package      Issues comes when you have to built five packages which share the same variables.  It's very tedious and hard to re-write them every time...      Thanks for your time, There is no supported method of doing this. You could edit the package Xml directly, variables are fairly easy to find, near the top of the Xml, just copy and paste. N.B. If you make a mistake you will corrupt the package, so keep copies. Ok, thanks Darren. ...Show All

• iGNiTe I am using the reportingservice web service, everything runs fine but does'nt display report

  Please am i doing something wrong, i debug the code no where it is giving me an error: I am using the reportservice.asmx web service to render the report, but it is not displaying the report at all. it just shows me on IE saying Done with out any error, please can you tell me am i doing something wrong, after a very hard time i reached upto this point, on my form i just have a button on its click event i wrote the following code. and i have no other control on the form. except this code. just referencing the webservice. thank you. Dim rs As New ReportingService Dim LogonCredentials As System.Net.NetworkCredential Dim Items As CatalogItem LogonCredentials = New System.Net.NetworkCredential("usernam ...Show All

• Frank Uray Return all fields of database

  Hello, Is it possible to return all the field names of a database. I do not want the data rows. Just a list of fields in the databse. Thanks Something like this will do it Use YourDBName select table_name , column_name , ordinal_position , data_type from information_schema.columns order by 1 , 3 Thanks for that. I am trying this Use CallsAndIncidents select PROBSUMMARYM1 from information_schema.columns I have my database as HOUAPPS237.CallsAndIncidents.dbo.PROBSUMMARYM1 where PROBSUMMARYM1 is the table name whose fields I want returned . i.e Name,Type ,Level,etc. I did not understand these 2 lines select table_name , column_name , ...Show All

• T.Misner How to access Output (Inserted.ColName) from client application ?

  I am using SQL Express 2005 and VB .net Express. Question 1: How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph). Question 2: How to store Inserted.ColName into local variable when insert command is running in stored procedure.: Thanks Jens for your support. Now leaving this thread. Thanks again Ses, this is a proper way to do it. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Hi Jens, There is no problem. I as ...Show All

• R.Tutus Database 'model' corrupted

  Hi, my 'model' database corrupted and my SQL Server 2005 Express can't be started. I believe I have the SAME problem as his: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=455524&SiteID=1 but when I try the command start sqlservr.exe -c -T3608, an error message appeared: "Your SQL Server installation is either corrupt of has been tampered with (Error getting instance ID from name). Please uninstal then re-run setup to correct this problem" Well, the problem is that I have an ActiveBPEL database inside, and I really need a way without reinstalling it. Any solution Thanks, Edwin Hi Edwin, Although I can't really comment on your issue (as it woul ...Show All

• SW Sam Remove outlying records...

  Guys, Is there some Transformation or other method to remove outlying records based on an attribute during a Data Flow task I have a list of Organizations complete with a list of Products they have bought. I am going to do some data mining / profiling off of this data but first I need to get rid of the top 25% and bottom 25% quantity records by Product. I've looked at Percentage / Row Sampling but they are too simple. How would this be done in SSIS Thanx! Sincerely, J'son JsonC wrote: Guys, Is there some Transformation or other method to remove outlying records based on an attribute during a Data Flow task I have a list of Organizations complete with a list of Produc ...Show All

• Joris Valkonet Management Studio vs. Management Studio Express Edition

  I am back doing development after a three year hiatus. Previously I was working with SQL Server 2000 and Enterprise Manager and I need to get up to speed quickly on version 2005. The computer I am using already has Management Studio Express installed but we have full licensed copies of version 2005 enterprise edition available. I have two questions: Are there features available in the full version of Management Studio that would compel me to switch from the Express Edition If so, how in the heck do I make the switch. Is it as easy as uninstalling the Express Edition and then installing the full version from the 2005 enterprise edition CD I already tried installing from the enterprise CD and got the error message cited in ot ...Show All

• Janine_Whittaker Hw can the cube be modified after deployment?

  Hi, We used cube in our project. And the project is released to production environment. Now we need to modify the cube. Can anyone have any idea what are the ways we can handle this Appreciate any suggestion. Sachin! We have deployed product at many client locations. Now we need to add few things to the cube But it is not feasible to go and change manually at all locations and same time client may not want that. We are looking after creating an update for the product. Now the question is how to update cube One option is delete existing cube and create again with new xmla script and process cube. Can you please suggest any other way to do s ...Show All

• mikecc Dynamic connection string

  Our Reporting Services environment uses Oracle as the data source. Based upon the user connecting to the database determines what rows they will see for various tables. How can we dynamically pass the username/password to the connection string Background: Our users log into Active Directory and are assigned to a group. The AD group name is used to access a control table in Oracle that contains the database username/password for that group’s connection to Oracle. All subsequent connections to Oracle will use the group’s username/password from the control table. We have an ASP.NET application that works like this and stores the connection information in the session state. How can we do something similar with our connection in Reporting Se ...Show All

• EricBrown Cannot Kill Process stays in KILLED/ROLLBACK status

  I've just try to kill a process running for almost 10days now. It is a differential backup on which the SQLServer apparently choked. After killing the process it's in KILLED/ROLLBACK for quite sometime when I try to get the status with KILL 57 WITH STATUSONLY I get the following result: SPID 57: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds. So I would infer that the process is indeed finished but it stays there. How can I get rid of a process that has a 100% Rollback completion and an estimate time remaining of 0 seconds I'm having the same problem. You could have just restarted the SQL Service without restarting the server. I had this ...Show All

• AlexBB I can't get a SQL QUery to accept a null for a parameter

  I have straight forward Insert Query, which takes values mainly from text boxes, however I am having trouble when the value is null. eg cmdP0.Parameters[ "@EmpID" ].Value=txtEmpNo.Text; When I run the Query I get... Message="Parameterized Query '(@ID int,@EmpID int,@Photo nvarchar(260),@DoB smalldatetime,@Med' expects parameter @EmpID, which was not supplied." I also get this when the parameter can be a string. I have set the parameter properties so that SourceColumnNullMaping to true (it was set as false - so hoped this might fix it!) No luck. Have you tried to set DBNull .Value as value of the parameter, if the text is returned as null That worked for the string ...Show All

• Tom De Cort somebody plz help me.

  want to do a login in vb.net, when the user enters username and password, it looks into ms sql to find user then compare password with database then select user in database and closes form to open another form with selected database. please help, i am stranded with my project and i am getting nowhere. Which authentication type are you using HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- OK, so you implemeted your own authentication, right But SQL Server will authenticate the user first and check the authorization. Therefore you will nedd to either connect to SQL Server using SQL Server authentication OR Windows Authentication. Appropiate Connectinstr ...Show All