Answer Questions

• belgerog decryptbykey multiple session issue

  Hi I'm having some issues using the decryptbykey method via multiple connections. When I run the below test script simultaneously on two machines the sum function is always less then the known amount (ie 14945490 and 36382777). Does anyone know of any locking method or alternative way to sum an encrypted column Thanks in advance Waz open symmetric key HR01 decryption by password = 'yes' DECLARE @Bonus decimal DECLARE @Salary decimal DECLARE @Errors int DECLARE @Success int DECLARE @LoopCount int SET @Errors = 0 SET @Success = 0 SET @LoopCount = 0 WHILE ( @LoopCount < 40 ) BEGIN SELECT @Bonus = SUM ( convert ( float , convert ( varchar ( 80 ), decryptby ...Show All

• jsale_endeavor Setting the Locale of Reports

  I am having a problem with date formats in reports. I have a two servers, one setup as En-US and the other En-UK in Windows. I have various reports that are rendered using the report viewer control in local mode. In my reports I have not set a language on any text boxes or on the report itself (using Default option in VS 2005). As I understand reporting services should therefore use the locale set in the browser, or else the locale of the report server. However, when viewing the reports, both servers display date time values in American mm/dd/yyyy format! I do not understand this as I am using the local machine to view the reports and the so the locale of the browser and the locale of the OS are En-US and En-UK respectively. Please could ...Show All

• JK302 Using the results of a script component

  Hi There, I have to populate data from two oracle databases. I have a list of ids from one table and I have to query those ids in the second table (in a different database) and populate that data into a sql server. This is the approach I have taken... I have populated the ids into a recordset destination. I use a script component to extract those ids (from an object) into an ouput buffer. I am wondering how I can iterate throu these ids and query the table in the second database for these ids. Can somebody please help me Thanks a lot!! Table in DB2 has 600k rows in it. List of Ids is 1200. Wouldn't it be a performance hit if I use a lookup transformation for this requirement And is it same like a select statement ...Show All

• toniSQL Creating a data source on the server to connect to SQL SERVER.

  My question is what is the proper way to do this I have been try the ways that it is instructing me to do. By creating the name, then I go to a list of potential sources, one being: the local, then another being: the actual domain on the network, last one being: the name of the created data source. I have already tried the local & domain, I will try the last one. But, my question is if this selection is not going to connect to SQL SERVER. Then, "What should I do within the server to make this connection possible to a client computer look for the access " Hi, I Did not understand your explanation. But anyway, if you want to let clients access SQL Server, you would have to do nothing more than 1.Enabling remote ...Show All

• danskcarvalho SQL Server 2000 Reporting Services

  SQL Server 2000 Reporting Services using Render method. Now i have NO troubles with authentication But there is no Toolbar at the top of the screen where u could export to different formats. But i really need this toolbar. I pass "<DeviceInfo><Toolbar>true</Toolbar>......</DeviceInfo>" parameter to Render method In URL i tried rc:Parameters=True , still no use Thanks. I was using URL access. But is there any other way to bypass username and password to access reportserver. Can anyone help me in providing Report Viewer with Network Credentials (web service ) in SQL Server 2000 Reporting Servcies ,.NET Framework 1.1 , VS2003 ...Show All

• jabuka Mix Relative and strict dates

  I am trying to write a report where I can have a drop down with values like yesterday,today,lastweek. But I also want the user to be able to select a specific range, say 7/1/2006 to 7/5/2006. Also why can't i update the value of a parameter through to an expression Like set the value to =Today(). It throws an error about the type. Can someone point me in the right direction here Parameters are typed so you cannot mix relative dates with specific ones. So, you will need muliple parameters and way to determine which ones to use. I would use three parameters, the first one is a drop down with the realative dates and an entry like "Specify." The other two are DateTime parameters for specifying the start and end dates ...Show All

• Xiaobo Gu Is it possible to send email to SQL Server 2005?

  Now that SQL Mail is being phased out, is it possible to send email messages to a SQL Server instance Satya - Thanks for the reply. That's not exactly what I want to do. I do have Database Mail enabled and working fine. I want to receive emails from outside of SQL Server into SQL Server so that I can execute queries based on the contents of the emails. Because SQL Mail is going away, I don't want to develop anything based on that. Is there a replacement for the xp_readmail stored procedure that was used with SQL Mail Database Mail uses SMTP service. You can use Exchange as your SMTP server, if your company uses Exchange; Using that can you try sending an email to that profile on exchange Refer to thsi KBA ht ...Show All

• Dipendra DTSTransform.DataConvert programmatic access?

  I am trying building a package from code. I have been able to follow the SSIS samples and build my control flow with foreach loop and SQL Commands pretty easily. The data flow has been a different story, I am struggling with input and output columns. I trying to read from a flatfile, convert data, perform a lookup, and update or insert based on the results of the lookup. I was able to build this package in the designer and it works just as I want, but I am having problems duplicating the data flow in the code. I was able add the flatfile, data conversion, and insert controls on the data flow and linked them together. However, I cannot figure out how get the input columns in the data convert object to become selected and generate the ...Show All

• Steve Hempen Snapshot Replication vs. Copy Objects DTS

  I have an application that I wrote that is running in the local office and a remote office. The two offices are connected via a hardware VPN. The connection in the remote office is wireless and can give speeds down to 40kbps. Each office is running MSDE 2000 and runs off of a separate database with a different name. I would like to have the database from the remote office available in the local office. It doesn't have to be completely current. A 24-hour delay would be fine. Since Transaction replication is not available in MSDE, I can use either Merge or Snapshot. Since the local office wants to allow folks to access the remote office's database without allowing them to affect the remote database (query purposes only), it seems that Sna ...Show All

• thedo Report in Report Manager (server) does not look the same way that it looks in the Visual Studio Environment

  I am using SSRS 2005 and my server is a Microsoft Windows Server 2003 Enterprise Edition Service Pack 1. Most of the differences between VS and Report Manager are formatting differences. Borders won't show up, scrolling does not work etc. Is there something i need to upgrade on the server. Last thing but not the least. Everytime i change something in regards to the parameters i need to delete the report from the report manager and deploy in order for the change to appear on the Report Manager. Is there a fix for this Could somebody please help me with these 1. differences in rendering between design-time and run-time -- the renderer used in Report Designer is quite different than the renderer us ...Show All

• yanivpinhas Sorting Values in Colum Matrix in a logical order in RS2005?

  Hello, I am curios if someonse has accountered issue when you have to sort values in a column matrix in a logical order as opposed to alphabetical order. In my case I would like to have a matrix column sort like in th example below as opposed to 'Graduate', 'Law', 'Total','Undergraduate'. I have a column called OrderKey which forces the sort I want in T-SQL but this sort seems to be ignored by a RS Any ideas how I can fix it Thanks Undergraduate Graduate Law Total Score 230 560 880 1670 This Sorting information should be set for the matrix's Column Group. In report designer, right-click on the header for the Column Group and choose Edit Group..., then cli ...Show All

• Swapna.B. Out of virtual memory

  I have one package that is constantly running out of virtual memory, right now I am on a development server, running only this package. The package is moving data from one table into another on the same server in the same database. The server has 3 Gb of memory and is only running SS2005 and SSIS. I am a local admin on the server and running the package through BIDS, once again for our initial testing. I tried setting the property BufferTempStoragePath to our E drive so it can utilize the 100 Gb of free space we have but that doesn't seem to work either. I have also tried setting the MaxRowSize to many different values to no avail. I am constantly getting an error, see below for exact error, when it gets through roughly half the load. More ...Show All

• vandewst Sum Facts

  I have a type 2 SCD on a sales person dimension. If a sales person moves from one territory to another, how can I calculate their total sales across both territories Some of the fact data will be associated with the dimension key in territory A and some data will be associated with territory B. Does the cube hide this complexity If so, how Thanks Dave it makes sense. I created a simple DB/AS project to see how it worked which helped me out as well. Making a few assumptions about your design here, but hopefully this will make sense. In your dimension design, if you have an attribute for the sales person that is based only on column(s) that reflect the sale ...Show All

• Alba Where to put DISTINCT in a CTE?

  CTE's are surprisingly useful for paging data, but I'm running into a problem where I have to add a distinct clause. The idea is to pull topic records for a user's forum posts, but only one topic record even if there are multiple posts in the topic. Here's what I have so far: CREATE PROCEDURE pf_PagedTopicsByUser( @StartRow int, @PageSize int, @UserID int ) AS DECLARE @Counter int SET @Counter = (@StartRow + @PageSize - 1) SET ROWCOUNT @Counter; WITH Entries AS ( SELECT ROW_NUMBER() OVER (ORDER BY IsPinned DESC, LastPostTime DESC) AS Row, pf_Topic.TopicID, pf_Topic.ForumID, pf_Topic.Title, pf_Topic.ReplyCount, pf_Topic.ViewCount, pf_Topic.StartedByUserID, pf_Topic.StartedByName, pf_Topic.LastPostUserID, pf_Topic.LastPostName, ...Show All

• wooten Custom Authorization in Reporting services

  For custom authorization, I am overwriting the CheckAccess method. But how do I know what I am trying to access in CheckAccess method I need to know what report the check access method is trying to execute for our requirements. How do I get that I have the same issue! Can anyone help Thanks! ...Show All