Answer Questions

• Donald Sechrest deleting records

  I have a couple SQL tables that have been appended to daily over the last two years. There is now about 50,000,000 records in the table. Does anyone know the fastest way to delete records before a certain date to shorten these tables Delete queries and everything else I've tried is taking way too long. Is there an advantage of doing it that way when I could do this: DELETE FROM dbo.Daily_snapshot_INV WH ...Show All

• David Gardiner MS Help - Reporting Services PDF Rendering and Code Security Context

  This is a long post. I have spent a collective 8 hours over the last 2 days working with MS Technical Support on determining the reason why my reports images, when called using absolute references to a web project ( http://localhost/projectname/mypic.jpg ), were not displaying when exported to PDF. Side note - the techs I worked with were excellent, but just as stymied as I was concerning this problem. My architecture has a .NET 1.1 app wr ...Show All

• Harold Shapiro Performance difference

  Hello, i'm running 7 same HW&SW configured servers with the same load with SQL Ex 2005 SP1 installed. I'm executing SP over 200.000 times a day. And here comes the problem, every server got different average response time, the quickest executes the SP in 1 ms, the slowlest in 50 ms, that's 50x slower! Have you any performance hint, please Thank you. There are numerous layers between C# and ex ...Show All

• DevelOper_sdl suppress a row in a table (mailing address report) - suppress like CR.

  i'm retrieving addresses from a database and displaying them in my report. i have an addr line 2 for addition address data if needed. i have placed this addr line 2 on its own detail row. however i do not want that row to display if there is no data. the following is happening even though i have set the visibility on the row and text field to =iif(fields!addr2="",false,true) the name prints on the first line, the main address on the ...Show All

• samdalil String to Date Conversions

  Having some trouble converting strings to dates. I am using a .dtsx package and have figured out how to use a derived column to convert the string to a new string which is a valid date. The problem is now converting the column data type to date. I insert a new data conversion step to convert the vchar field to date, then when it runs it fails on this step. Error is The conversion returned status value 2 and status text "The value could not be ...Show All

• technisat how to run the Service Broker Samples

  I am trying to run the Readme_HelloWorld sample on the SQL server 2005 Books online. But don't know where I can get the setup.sql, SendMessage.sql, ReceiveMessage.sql scripts. I followed two examples on the blog, but they did not work at all. Here are the scripts: /* example 1 */ create database TestSB go use TestSB go create queue TxQ create queue RxQ create message type Msg create contract MsgContract(Msg SENT BY ANY) create service TxSv ...Show All

• NewWorldMan Adventure Works DW Script

  The Data Mining Tutorial accompanying the June CTP includes mention of a table DimProspect. Despite the csv file existing in the Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Data Warehouse path containing the data for the table, the instawdwdb script doesn't include any reference. Can someone supply me with the necessary script for this table Regards Baz Star I am one of the authors for ...Show All

• stevelam How can we deal with unknown member in cubes for data mining?

  Hi, all here, I currently have a question about unknown member in cubes (as we know, there is always an additional member called unknown in an OLAP dimension)for data mining. I mean is there any way for us to deal with unknown member in cubes when mining cubes Thanks a lot in advance for any guidance and help. Yes the unknown member is added automatically during dimension processing. You can change the UnknownMember property of a d ...Show All

• fatih_saki Migrating RS

  I have installed RS 2005 on a new box and want to restore my present RS 2000 ReportServer db.  The restore seemed to work, but when I try to bring up the service, I get this error: The report server cannot open a connection to the report server database. So then I tried using the Configuration Tool to upgrade I then get this - System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Version' in ta ...Show All

• dunlapja Issue with launching report builder from client

  I cannot get report builder to launch remotely in a brower on the client side. It works fine on the server where reporting services is installed. .Net 2.0 framework is installed on the client machine. It seems to be a security issue, I get an error in the log 401 unauthorized. I have checked the rights on IIS and everything seems to be in order. Any thoughts ...Show All

• trishide Is this possible? How

  hello guys, I want to create a report using a bar chart data region from a cube. The cube contains Date and Time dimentions. Here is my question: The catagory field (x-axis) value of the bar chart is dependent on the paramaters value(i.e.StartDate and EndDate). For instance if the difference between StartDate and EndDate is greater than 1 year, the x-axis value for the bar chart should come from the Date dimention and display the year value. ...Show All

• SMang New Query Connect Dialog

  The "Microsoft SQL Server Management Studio" opens a connection dialog with every new query. Please tell me there is setting to prevent this. Thanx, Greg The popup of the dialog is related to your current context. If you have object explorer open and a server connected then the query will be connected to that server. If you have an existing query window connected it should connect to that server. If working dis ...Show All

• Mohan1 Connectivity Issues in AMO

  Hi, I am using AMO to connect to SSAS 2005 and programmatically create objects. currently I am specifying only the ServerName in the connection string. Please see the code below: <code> Server SSASServer = new Microsoft.AnalysisServices. Server() ; SSASServer.Connect ( "DataSource=" + ServerName); </code> The above code works fine and I am able to connect. Now I want to provide the instance name of the s ...Show All

• joaopaulo7 Sql Question

  I have a table that stores Firstname and Middle name in Field 1 and Lastname and Suffix name in Field 2. I have to seperate the first and middle name and put in 2 fields. But the problem is I cannot just check for the space inbetween. since some first names have spaces in between. And then another space for Middle name. Same with the lastname and suffix. How would I seperate these fields into different columns. ...Show All

• MoonWalker Execute Package Task always Fail When ExecuteOutOfProcess = False

  Why does the Execute Package Task in SSIS always fail when set to execute in-process Having ExecuteOutOfProcess = False always results in that the package fails when run from within BI Studio. I have also tried it from Command Line using dtexec., same results. The problem with setting ExecuteOutOfProcess = True all the the time and running from within Bi Studio is that an enourmous amount of processes is created, none of which die ...Show All