Answer Questions

• lucerias Disable Paging

  Hi Is there any way I can disable paging and show all record on one page Regards Amit You can set the report's InteractiveHeight to 0 to disable paging. -Chris Sweet.. Thank you for your help Chris. Regards Amit ...Show All

• Boretti Extracting package information from SSIS

  Hi all, I am supposed to maintain a bunch of excels documenting all the mappings I'm doing in SSIS. The excels have the following format: Target Field | Target Type | Source Table | Source Field | Source Type | Transformation Rule Apart from being incredibly tedious, it is hard to keep every excel current, as there are other people adding and taking information from the database model. I plan to extract this information from SSIS and create the excels dinamically, but, apart from parsing the .dtsx for each package, I see no other way of getting what I need. Any suggestions on how I should do this Is there an easier way Cheers, David Leal The SSIS object model provides access to all aspects of the packag ...Show All

• cgkitab distrib.exe --- Many instances running

  How many instances of distrib.exe should be running Yesterday I created multiple publications in SQL 2005. without counting, it looks like each publication has its own distrib.exe.... it this the way it is supposed to work Each instance it holding 8k of ram (not a problem right now) but I have many more publications to create... Please let me know if this is the way SQL server works now Thanks for the explanation. I just wanted to make sure it was normal... The reason for the multiple publications is not for the purpose of the subscriptions but rather the publications them selves. We have about 200 table that are changing several times a year based (data lenghts or additional columns). Th ...Show All

• Alex Farber encrypting connections to sql server 2005

  can you please tell me how can i encrypt data sent between client application and sql server 2005. No, a certificate is needed in order to use SSL. I am including additional links that may be useful. · Encrypting Connections to SQL Server http://msdn2.microsoft.com/en-us/library/ms189067.aspx · SSL Certificates http://msdn2.microsoft.com/en-gb/library/aa364691.aspx (This one makes reference to SSL for HTTP connections, but the main explanation and description of how SSL uses certificates are common) · Configuring Certificate for Use by SSL http://msdn2.microsoft.com/en-us/library/ms186362.aspx I hope this information will be useful. -Raul G ...Show All

• Marlun Is this a real IN/OUT parameter?

  I have the following stored procedure definition: CREATE PROCEDURE insertWsdls @url varchar(128), @source varchar(64), @hashcode int, @wid Integer output AS INSERT INTO Wsdls (url, source, hashcode, scan_date) VALUES (@url, @source,@hashcode, getDate()) set @wid = @@IDENTITY return GO When I looked at SQL Server Manager Studio, I found parameter @wid was identified as Input/Output parameter. However, it is defined as output in the procedure creation command. Why does the parameter @wid become an Input/Output parameter Hi, OUTPUT always means that this is also an input parameter. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• DotNetFireball ADOMD.net 9.0 (client) and CubeDef.LastProcessed

  What is this property (CubeDef.LastProcessed) supposed to return as it does not return the date the cube was last processed Does AMO provide this info more reliably TIA Dave Hi Dave, It's a bug - CubeDef.LastProcessed returns the last time the server was restarted as far as I know. See http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=124606 ...for more details. Take a look at the comment posted by furmangg on April 28th on this entry on my blog for some code which does what you want: http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!675.entry It's also available in the Analysis Services Stored Procedure Project here: http://www.codeplex.com/Wiki/View.as ...Show All

• JPC16 How to add columns at run-time?

  I have a table: column1 column2 column3 column4 data data data data data data data data I want to create more columns at runtime, what should I do desired output: column1 column2 column7 column3 column4 column5 column6 data data data data data data data data data data data data data data The number of columns to be added is random. Please help. I have not yet tried using the matrix component, I can't find any samples in the web. I have created a dataset for the column names alone but i'm having a problem mapping the data under it. here's the type of the table i'm trying to do: column1 column2 column3 data1 data2 ...Show All

• deen bad excel performance / capacity question

  a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size) the reason for this is the detail displayed for each record each record has a drop down of approximatley 4-6 rows of detail a report with 3000 lines will have those 4-6 rows of detail for each record shouldn't excel be able to handle this the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why ...Show All

• fleo Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"

  I get an error dialog when I try to create a new SQL database , both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is: Local Database File: User does not have permission to perform this action. I've searched for help with this. I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder). The SQL Server Express error log is clean and indicates full functionality. Everything is running locally. No VWD installation errors. Any ideas Thank you! VWD creates your database using a User Instance is your ...Show All

• bxchan SQL 2000 Database upgrade to 2005

  Dear All.. I have a few databases running a sql2000 and the time as come to move them onto sql2005. Which would be the best route to take. If I can think back to older version it was just a simply job of doing a backup in it's current version then restore in the new version and upgrade was taken while restoring.. I could be wrong but any help !! Thanks Martin. Also take a close look at the compatibility information from SQL Server 2005 books online. HI Hemantgiri Many thanks for the info, I knew my old memory was right - I shall remember your points when I upgrade thanks again Regards Martin Hi Martin, If you founds information use ...Show All

• rgudgeon cumulative totals in chart : Report Builder

  Hi, I am trying to display a line chart with cumulative totals over period of 12 months in a fiscal year. I know this can be achieveable in report designer using "Running value function". Any idea how to achieve the same in Report builder thanks in advance. Here is the data : Month Count July 2 Aug 3 Sept 2 Expected output should be Month Count July 2 Aug 5(July count + Aug.Count) Sept 7(July count + Aug count + Sept Count) Regards, bala Hi guys, Any idea how to achieve the above functionality in Report Builder ...Show All

• OnCallBI-DBA how to query the SQL server name?

  I use : select @@servername to find SQL server name. But it will return the virtual OS name in cluster environment, not SQL server name. I need this server name for error handling as well as generating query scripts. How to query SQL server name You can: -Query the name through xp_cmdshell, reading it from the SET command -Creating your own CLR function to read environment variables -Read the registry for the needed value through xp_regread /buit be careful this is undocumented and might be deprecated in further versions) HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- 1. Suppose I have serveral instance on a cluster, how do I figure out my ...Show All

• jbrcks SQL Server best practice with IIS

  Hi Everyone We are building a new site using ASP and SQL as the backend. Any idea where I can find some information about best practices to coonect the 2. I was thinking about IIS on a DMZ with port 80 only open and the SQL inside the internal network and open port 1443 between them. Any ideas will be welcomed. Thank you Oren Levy Hi bass_player Thanks for the prompt reply. How do you tell IIS to connect via a differnt port number I was thinking using ODBC for simplicity. Do I still leave it as 1443 on the IIS side and then redirect to a different port on the SQL side or vice versa. Thanks again. Oren That will be ...Show All

• Dave Patricio Analysis Services

  How can you process multiple Analysis Services databases against the same SQL Server database without receiving table locks and the processing fails. Dear, We can create a DTS Package that will process all the Analysis Databases one by one. HTH from sufian How about one by one database using some program There is a command line tool available to execute XML/A requests. ...Show All

• AllisonH Transaction Report to a .txt file.

  I have a transaction table that I need to export for our financial system to import. It has a lot of zero's and a lot of spaces and it is in a .txt format. Is there a way to do that and if there is how I do have a copy of the requested file if you need to see it. I know how to get the data and I know where, but I have no idea on how to get the spaces zero's and so on. Some help would be great! Thanks   ...Show All