Answer Questions

• Richard Thomas Publishing a report to the web error

  Does anyone know how to fix this error -I've tried allowing anonymous access to the site. -I've added it to my trusted sites. Error: The request failed with HTTP status 401: Unauthorized.    Thanks. Hi Mike- This sort of error can be due to several things. I would start by checking your IIS settings on your Reports and ReportServer virtual directories. More information on setting virtual directory security settings can be found here: http://msdn2.microsoft.com/en-us/library/zwk103ab.aspx -JonHP The report you are using does not have the correct credentials to execute the query against your underlying data source. Check what credentials you have specified through the report properties tab in ...Show All

• Homam85 .NET Framework 1.1 and SQL server express 2005?

  Hi I am running VS.NET 2003 on my computer and wish to try to install the *free* SQL server express 2005 . The problem is I can't install SQL express as it asks me to install .NET framework 2.0 first. I wonder if I do so, will I be able to work with VS.NET 2003 Thanks, Yes VS.NET 2003 would work just fine. Multiple versions of .NET framework can run easily. ...Show All

• Shen Yizhe can service Broker talk to informix

  Hi, I am very new to Service Broker. Can I have a Service Broker which will Exchange Message from Informix and service broker sitting on SQL Server Box. If this is possible, How can we achieve it. Any Pointers will be very helpfull. Thanks express edition supports Service broker Client services only only I am not aware of any restriction that would restrict the linked server to Windows only. This is not an area I'm an expert in, but I believe you can add a linked server connection to any database hosted on any platform, as long as the proper ODBC or OLEDB drivers are provided. As for the second question, as I said already, Service Broker can communicate only between two instance ...Show All

• eldiener Primary Key Auto Increment

  Hi, my table's primary key is int(4), auto increment with the seed 1, if I got 3 data inside, means the id should be 1, 2, 3 id fname lname ============================== 1 Stephen Saw 2 Ali Baba 3 ABC DEF suppose new record will have id of 4. Let say I deleted data with id 3, before adding new record, the new id will be 4 instead of 3, how can I made the new id to become 3 instead of 4 after delete the id 3's data. Is it possible to insert new record with id of 2 if I delete the Ali's record, but it will continue with id 4, or is there any method for me to reorder the id Thanks in advanced. As has been said, we could ...Show All

• Sumit Bhatnagar Download and create a Report Project from a Report Server

  Before I start coding ... Is there any existing software/trick/hack to create a Report Project from the DataSources and Folders/Reports on a Report Server, i.e. the inverse of Deployment Would there be anybody interested in such a thing, and, if not, why not I don't think there's any way to create a report project from the report server, but you can get the actual RDL files from the server. Go to your Report Manager. ( http://ServerName/Reports ) Drill through to the report you want the definition of. Click on the properties tab. Click on General from the options on the left. Under the 'Report Definition' section, click 'Edit'. This will prompt you to download the RDL file. You can then add t ...Show All

• WidgetWorking Any other way but Cursors or While loop

  Hi all, I have a bit of a challenging on my hands with this, i have a result set in a table which i am trying to iterate through the rows one by one i.e Values Values Dates 1.10 1.20 1.30 1.40 2006-03-31 00:00:00.000 2006-06-30 00:00:00.000 2006-09-30 00:00:00.000 2006-12-31 00:00:00.000 go to each row get the value and the date perform some calculation with the value and the date and insert it into another table(which sounds easy enough) my problem is how do i iterate through the result set one by one without using a cursor or a while loop do i have any other options at all Hello: Thanks for putting all the ...Show All

• MmeBovary Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• XNA.Zach Can aggregate functions be used in a check-constraint or a computed-column?

  Hi, Can aggregate functions (e.g. Sum, Avg) be used in a check contraint or in a table's computed column Thanks! Green: I don't think you can use subqueries for either circumstance; therefore, I am not sure that you can apply either one to a table. I think that the best you can do for a function is a scalar function. Can somebody else verify this Dave You cannot do it directly, but as Dave suggested, you can do it by creating a function. Here's a simple example create function SumTestOne() returns int as begin declare @retVal int select @retVal = sum(one) from Test return @retVal end create table Test (one int, two int, check (two > dbo.Su ...Show All

• Bobo1234 SQLWB.EXE max cpu

  SQL Server Management Studio 2005 Windows 2000 when I "Open Table" to view all the records in a table, the cpu goes to 100% and the records are drawn very slowly - about the same speed as you read ! I have re-installed all the software and also tried service pack 1. SQL 2000 worked fine. any ideas thanks John, UK Microsoft SQL Server Management Studio 9.00.2040.00 Microsoft Analysis Services Client Tools 2005.090.2040.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.2800.1106 Microsoft .NET Framework 2.0.50727.42 Operating System ...Show All

• tdroz Help Needed: For Creating Synchronous Transform Component

  Hi I am currently trying to write a custom transform componet in c# that will take a row of data, perform a look-up via an external system, then if there is a match then send the data from the extranel system down macth ouptut (which will have different columns to the input) and drop the data that was read, else send the data down the unmacthed output which will be the same as the input. So I would like to write a synchrons transform becuase I don't need read all the rows from the input buffer before I started processing, also I wish have millions of rows load in memory. Can this be done also does any have explame code of how to do this becuse I can't see how to send data down the match output buffer, as this will have the lookup r ...Show All

• wolfr Connections to SQL Server Files (*.mdf) require SQL Server Express 2005

  When ever I click on an MDF file in VS2005 I get the following message. Required Components Missing. Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly.  Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/ linkID=49251. I think this may have been due to the install order and options I selected. 1. VS2005 Pro, without SQL Server Express 2005 as I was planning to install SQL2005 Developer. 2. SQL2005 Developer. I then noticed the above problem and installed SQL Server Express 2005 from the VS Pro DVD.  I still have the problem.  Any ideas how I can fix this Here I mean same problem. I installed ...Show All

• Abdul Sami new to sql, don't understand "text filegroup" PRIMARY

  Thanks for any help in advance. I'm new to MS SQL and I'm having trouble adding a table with the property, "Text filegroup" = PRIMARY. Frankly, I haven't done much reading (I've done lots of googling though, but to no avail) about the subject, but nevertheless it seems that I can't add data to my table unless the 'text filegroup' is set to PRIMARY. However, I can't figure how to set it to primary. Even when I create a new table the default (I think ) seems to not set it to PRIMARY. By the way, I'm using Microsoft SQL Server Management Studio Express. Did you read Books ONline I bet it says the default is primary. You can always script out the table to see what the default is (if it's availabl ...Show All

• asalcedo The best Data Transformation tool to Update/Insert

  Hello, I have some data coming up from an SQL Server source, I have to add it to another SQL Table on the basis of what destination table already have. For instance, if there is already an entry there for particular record (based on matching primary key value), then I just need to updated 3 columns, otherwise need to insert. The problem is, I know how to do it by using script component, but I am wondering if there is a better tool that saves me writing code Any idea Thanks, Fahad slicktop wrote: so if we are talking about a large target table then this method seems like it would be much slower than the alternative. If you have 500K rows in the target and you have to cache all these rows into memory, I can't see how that wo ...Show All

• CarmineM AdventureWorks Database not showing up management studio express

  After installing the Adventure works database samples they do NOT show up in Management Studio Express I have done a clean install of SQL Server Express 2005 SP1 with Advanced services. The database samples only install as physical files, they are not attached to the SQL Server process. If you want to use them, go in the SSMS and right click on the Database node, choose All Tasks and click Attach database.. Locate the MDF File and the LDF File and click Apply (or OK). SQL Server will attach the databases to the SQL Server process and you can access the data. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- I found this not quite accurat. The Attach is in th ...Show All

• ar_pad SQL Execute Task

  Hi how would you use a package variable in inline sql, is there a format utilized Are there any steps I need to take to do that I currently have the SQL Execute task inside a ForEach Loop container, which has the variable mapping for the ID that i need for the SQL Execute task. I just need to know the syntax to use parameters in my query in my task. here is the current code which doesnt work: INSERT INTO LAFProcess.ProcessList (WorkListID, CreatedOn, ProcessStartedOn, Status) SELECT WorkListID, GetDate(), NULL, 2 FROM LAFProcess.WorkList WHERE Status = 2 AND LoanApplicationID = " + @[User::LoanApplicationID] +" UPDATE LAFProcess.WorkList SET Status = 1 WHERE LoanApplicationID = " + @[User::LoanApplicationID] +& ...Show All