Answer Questions

• ShivaGeorge Sorting, using Object Explorer

  How do I sort the objects list in the "Object Explorer" pane when using Microsoft SQL Server Management Studio (Enterprise Manager) I don't think you can. There is no way to sort the items. The best you can do is apply a filter. Cheers, Dan ...Show All

• Srivani V Eluri Performance Vs length of the data

  Using varchar we can define upto 8000 bytes as a length. Suppose i am defining one column upto the maximum size of varchar type and i am not storing not more than 100 charaters per row. what is the performance and storage differences Books Online might have an answer to your question (storage): http://msdn2.microsoft.com/en-us/library/ms176089(SQL.90).aspx There are also general topics about using va ...Show All

• Kehama Example code for consuming a SSIS datareader from ASP.net

  Hi, Does anyone have any or know of any demo code that shows how to consume data made available by a SSIS DataReader destination in an ASP.net app. Thanks in advance. -Jamie P.S. Doug if you're reading this, it'd be handy to have some examples such as this in BOL or maybe even something provided with the samples. Hmm... so much for the MSDN search integrated into BOL. I only have June BOL on hand, and did the online search pick that u ...Show All

• VarShant How do you process AS objects from the command-line?

  Hello, Quick question. How do you process AS objects from the command-line. I've read this: http://msdn2.microsoft.com/en-us/library/ms186673.aspx and asusme I need to issue such an XMLA command but I don't which command-line tool enables me to do it. Natural assumption is that its SQLCMD (seeing as you can do this from SSMS) but I thought I'd better check. Thanks -Jamie Just Visual Studio 2005. :) Perhaps SP1 will ...Show All

• Mike Heffernan Custom task database connection

  I'm developing a custom error task for SSIS. I've got a couple of existing OLE DB connections that exist in the Connection Manager. I want a drop down to be displayed in the Custom Task dialogue properties where the user can select one of the databases from the Connection manager. 2 questions: 1. How can i get the list of OLE DB databases in the properties dialogue 2. Does anyone have a code sample on accessing a database like that within the c ...Show All

• Ted Strom Distributed data synchronization - Comparing timestamp

  Hello, I am designing a distributed application where a central SQL Server 2005 database will need to be synchronized with remote SQLExpress databases via a WebService. Data can be edited at the cental db (by our connected applications) or on the local SQLExpress dbs running on the users machines (by this disconnected application). Now, how can I use the timestamp column to determine the most recent update. The most recent update to me is ...Show All

• Adjustedrace please look at my problem..

  I don't know what to call this but here is my problem: I need to create a report: sample table (grouping by name) name:   kris                                                                          ...Show All

• Patrick_F URGENT: Insert and Update in a transaction is getting blocked

  Hello, I have the following situation: -Package A begins a transaction (TransactionOption="Required") with IsolationLevel=Serializable -PackageA calls PackageB -PackageB has 2 data-flows. The first one inserts into TableA. The second one updates TableA. They run serially. They both have TransactionOption="Supported". The update is blocked in SQL Server by SPID=-2   (which I know is MSDTC). I tried setting RetainSameConne ...Show All

• Jonas Folleso ETL using SSIS

  Hi guys, I have been able to put together a simple SSIS package and familiarize with how it works. Now as I am trying to put together this ETL job I am stuck and am looking for some recos: I need the source system to be able to do a join on my Datawarehouse table and push thru only those rows which I am interested in. Can this be done using one of the Data flow task Presently we do it by using staging area, creating temp tables, doin ...Show All

• Igor Nikiforov Merge Tables and FileGroups

  Hey all For performance reasons i want to move the Merge Replication tables in a DB of mine (mainly MSMerge_Tomestone and MSMerge_Contents) to a seperate filegroup ... it's a heavy transactional DB and the index fragamentation rate is quite phenominal! The issue i've got however, is that when i try to transfer the table i get a warning saying that the current ANSI_PADDING / NULLS state is off in the current table, but will be switched on in the ...Show All

• Carl Rabeler SQL Configuration holding connections to DS

  Hello All, I have about 160 packages in my system, all using about 20 shared datasources. When changing one of the datasource's connection (changing the server name), I need to open every one of my packages and press OK to allow the remapping to the new server. (this is something I don't understand: wasn't this the meaning of using a share datasource in the first place what's the advantages in that case ) So, I have heard about Package co ...Show All

• _M Where can I find "Common Objects"?

  I used to make good use of the "Common Objects" node in SQL Query Analyzer's Object Browser, as it's faster than Help and included scripting options.  I can't find any similar functionality in SQL Server Management Studio.  Am I missing something Rhodri I've found most of the old "Common Objects" under <instance>.<database>.Programmability.Functions.System Functions, but I can't script them (at least when I'm lookin ...Show All

• Yong Hwee PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services

  When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression) Can anyone give me a hint on this one Thanks, Neno This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=232211 ...Show All

• Lenin82 Moving reports and their histories from SQL2000-RS to SQL2005-RS

  I have SQL 2000 Reporting Server with 30+ reports scheduled to be generated periodically and their snapshots are maintained in respective report history. Few weeks ago; we got SQL 2005 Reporting Server and we started using it for all the new work. Now we want to retire the old SQL 2000 RS machine but wants to copy the reports along with their histories on to the new server. Can someone guide or give pointers where I can find information on th ...Show All

• Chris Carr Column Sorting

  I want to be able to allow a user of a report to sort the records returnedc in a table control based on the column heading they select. ie say the report returns a list of properties as row headings then a list of cost categories as column headings with cost values as the data.  I want the user to be able to click on a column heading say a cost castegory of 'Cleaning' i then want the report to order the properties by 'Cleaning Value' ...Show All