Answer Questions
danyeungw Question About Scalability of Reporting Services
We use SQL Server 2000 Reporting Services to represent reports for our company. Our boss complained to me about the poor performance of Reporting Services when he viewed reports. He suspected that RS Server is a single-thread server and can not be scaled up by adding more CPUs or memories to increase the reports process speed. Is my boss correct And how can we increase the performance of Reporting Servces Traditional scale up can res ...Show All
Will Merydith SQL Express Connection Issues
Hi folks. I'm having some issues getting started using C# and SQL Server Express. I'm trying to create a C# project to just connect to a SQLSE DB just so I can start learning how to use it. I've used the SQLSE Surface Area Config Utility to enable remote and local connections, and it gives me error 26 about the default config not allowing remote connections. I then altered the connection string from .\SQLEXPRESS to .\MSSQLEXPRES ...Show All
Dieter D DATABASE AGE
What's a reliable way to determine database's age SQL Server 2000. Thank you. Run select * from sys.databases the create_date column tells you when the database was created. Eric ...Show All
mike miller How do I register/install an IFilter with an instance of Sql Server?
Hello, I am wanting to install Adobe's Pdf IFilter v6.0 for use with pdf files stored in the database and to use Full-Text searching on those files. I have been unable to find documentation telling me where I need to install the files, and how I register the IFilter with an instance of Sql Server. I know I've seen demos showing how to do it, but I have not been able to find them again. Thanks, JoeM Great ...Show All
BigCountry SQL Server Toolbox & Designer
I just had a clean install of Sept 2005 CTP SQL Server. I am new to the software and trying to grasp a few handles to start development quickly. In particular I am looking for a (form) designer associated with the Toolbox which I populated with tools I need successfully. The only thing that bothers me a bit is that the tool bars appear to be very dimmed, kind of barely visible but they react to the cursor when it is passed over them. I do not un ...Show All
Danut Prisacaru How to append a new values like uniqueidentifiers, sequence numbers to data flow?
Hi, I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us yes..i want to append values to a path with in the data flow task. If i use Derived Column Transformation, how can i generate uniqueidentifiers and sequence numbers for each row Thanks Go ...Show All
hafe How do I attach query results to send mail
I have several tasks that I don't want to use conditional failure on. I have a ON ERROR send mail task right now that works. I want to have that send mail task include query results from a separate query. How do I do that Peter Cwik Once you have the text file created as Jamie said you can attch the file by send mail task. Or if you want the output in the body of the mail then you can attain that by using ...Show All
JonSiii Transmission Queue problem
" noWrap width="1%" bgColor=#b71c0c> 1. Yosi 29 Temmuz 12:19 secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All
Weidong Ding Convert Coloumns to rows
Hi all, I've got a table with the following data: (sample data) Tbl_MachineHrs ASSETID DATE HR23 OPR23 HR06 OPR06 HR07 OPR07 HR14 OPR14 HR15 OPR15 HR18 OPR18 HR19 OPR19 HR22 OPR22 806CD03 11/07/2005 6817.9 116 6824.3 116 6824.9 103 6827.2 103 6827.6 46 6831.1 46 8066584 11/07/2005 5211.3 92 5218.8 92 5219.1 188 5223.8 188 5224.3 107 ...Show All
asche CLR Stored Procedure Not Visible
I am trying to do some time series analysis on data that I have. I've read that the best way to do this is to use CLR to write the manipulation code in .Net and then load the assembly into SQL rather than extracting the data, manipulating it and putting it back again. I'm using crystal reports with visual studio 2003 to do my reporting. The problem I am facing is that the CLR stored procedures I create using SQLExpress are not visible from my SQ ...Show All
jgodfjhgojfd MSDTC - The Transaction Manager is not available
I am trying to do something simple to test TransactionOption. I have a ScriptTask (out of the box), which runs fine. To test TransactionOption, I set the Package Properties TransactionOption = Required. Straight away the package fails with the following message Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This c ...Show All
geertDCOD suppress the display of a txt box when null
I have a text box in a list, which i only want to display if it is not null. How can i do this in reporting services. thx la You must put in the value the expression: = IIF(CSTR(Fields!EvaluatedField)="", "", "The Title") I hope it helps you Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. ...Show All
gabrielh Authentication in Management Studio
Hi, I'm attempting to connect to a SQL Server 2005 instance on a Windows 2003 server remotely with Management Studio on a Windows XP box. SQL Server is set to use Windows Authentication. If I select Windows Authentication as the authentication method in Management Studio, the 'user name' field is greyed-out and locked to my current XP user name, which is no good for connecting to the server. Why is this happening and how can I change th ...Show All
jporto Deliver to SharePoint
Quite a while ago Brian Welker talked about Reporting Services WebParts (which are available now...) and a delivery extension for SharePoint. Is anybody aware of it I googled around and didn't find anything about that (besides Brian's statement)... Is there any other option to deliver reports to SharePoint (beside the "delivery to file system" and import/link it to SharePoint) Thanks, Lloyd, I don't understand what single ...Show All
Matja&#382; SQL Server 2005 - 180 Day Trial Edition
Can this trial version be upgraded to a fully licensed version once a license has been purchased without the need to re-install. I will be buying an Open Volume license once it is available but would like to set up the server initially with the trial version Please be aware there is an issue with upgrade from Evaluation to Express for SQL Server 2005 RTM, if you go through the upgrade path of Evaluation ...Show All