Answer Questions

• jakeohara Specified job_id does not exist

  Hi, We have snapshot replication set up on a SQL 2005 box where the publisher is a SQL 2000 box. Replication was running properly for weeks. Because of some application upgrades, we had to remove the publication and subscription and re-apply once the upgrade was done. Replication is still running properly, however when we look at the job history on the subscription, we get an error message: Could not show the Properties window The specified @job_id (.....) does not exist. (Microsoft SQL Server, Error: 14262). I suspect this is referring to the old job but am not sure how to clear this from memory. I can view the job history on the actual job within SQL Agent and the job is running properly, but this error still occurs when I v ...Show All

• kalprin Recursing XML using XQuery...

  Hi, Being new to this forum, and SQL Server 2005 XQuery in general, I was wondering whether someone could provide assistance with the following query, I'm sure its mind-numbingly simple :) I need to scan an XML column for specific repeating structures that may or may not be there that contain nodes that also may or may not be there, and output them in a standard flat record format. I've had a quick scan of this forum and have noticed this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1039466&SiteID=1 Text extracted below: ============================= declare @x1 xml set @x1= '< xml version="1.0" encoding="UTF-8" > <Groups> <StationGroups> <SGroup> <GroupNam ...Show All

• amit007 Single sign-on with forms authentication

  Hi, We are using forms authentication as per this article http://msdn.microsoft.com/library/ url=/library/en-us/dnsql2k/html/ufairs.asp frame=true#ufairs_topic3 We want to get single sign-on working in SQL Server RS 2005. Users log on to our web application and we use forms authentication. We want the same logon credentials to automatically log you onto to the report manager too, so that when you navigate from our app to the report manager you don't have to log on again! I used the information from here http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconformsauthenticationacrossapplications.asp to try to get the 2 web apps (Report Server and my Web app) to share the authentication cookies, but it only ...Show All

• xshua SQL 2005 woes

  I installed VS 2005 & SQL Server 2005. When I use SQL Server Management Sudio,  I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration" any help would be appreciated. Thanks When I open the table designer - I never get the chance to design a table.  I also get the same error when I open a database diagram designer, or try to return the data from the table (open a table) - yet if I do a select script, I can run this fine.  Also all the equivalent designers work fine in VS 2005 I am running t ...Show All

• brian_tsim how to add/replace a guid column?

  I've searched through this forum, and am extremely disappointed that something as simple as this can't be done without resorting to a script component (which I refuse to do): I have a Lookup transformation that returns a GUID value -- or not, so I've configured its error output to ignore failure. That should leave a NULL in the output column, and I should be able to chain a Derived Column transformation that replaces the Lookup output column (e.g. foo) with an expression like: isnull(foo) newid() : foo But there's no newid() function! Who was the genius that decided SSIS should implement different expressions than Transact SQL Is there a workaround, like (DT_GUID)GETDATE() Or do I have to craft a SQL statement in the Lookup t ...Show All

• Bruno J.C. Nunes Understanding Estimated Execution Plan

  When I generate an estimated execution plan from Management Studio, one of the things I often see in the execution plan generated is an 'Index Scan'. When I put my mouse over the 'Index Scan' graphic, I will see a window display with something called 'Output List' at the bottom of the window. Do I understand correctly that SQL Server will scan my index looking for values in each of the fields included in this output list Thanks, Amos. Output list is nothing but the list of columns that will be projected from the operator (scan or seek). So this will relate to say the column(s) that are required for the join and/or referenced in the SELECT list of the query for example. There is a parent topic in the l ...Show All

• hypo Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• xRuntime How to use Loop statement

  I have a table which contains 170K of customer_numbers. How can I write a query (loop) to create 340 tables or excel files which contains 500 customer numbers each. Thanks for your assistance in advance. A couple of questions. 1. How do you want to split the data up into groups Randomly 2. Tables or excel files are two VERY different things. For excel files, I would suggest you not use SQL to do this. I would probably suggest you use a .NET language to build Excel files. If you really mean tables, then I would suggest you just use one table and assign a number to each customer_number permanently at the start of your process and then you have 340 logical files. 3. What version of SQL Server ...Show All

• Bob Reinke Microsoft report builder is a very BAD product

  This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. Please do the test with adventures works , and open the browser and choose report builder, you will see that . you can't do a report choosing a measure from two diferente measures groups and by more then one dimension.   One tool that does this is Microsoft cube explorer inside visual studio 2005, when you are developing the project :) you can explorer data from diferente measures folders. But there is no way the end user to ...Show All

• dhoops Not Associated with a trusted SQL Server connection

  I setup a DSN to a remote SQL 2000 Enterprise Server and was able to successfully complete the test connection. However, when I went to use the DSN to establish a connection in Integration Manager for GP 8.0 I got the following error: "Integration Manager was unable to obtain column information. You will not be able to map to fields in this query until the following problem is corrected: Could not create connection to Data Source '_Web Customers': Attempt to open connection Failed: [Microsoft][ODBC SQL Server Driver][SQL Sevrer]Login Failed for user'(null)'. Reason:Not Associated with a trusted SQL Server connection." I have tried everything I have been able to find on Trusted Connections but nothing seems to wo ...Show All

• TRID After Install, "Running sqlcmd -S Server\Instance" Fails

  I'm trying to figure out how to set up SQL Express so I can start learning SQL. I've installed SQL Express, but when I type " sqlcmd -S Server\SQLExpress," I receive the following error: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Username>sqlcmd -S Server\SQLExpress HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: ...Show All

• PerBylund Time intelligence

  I was trying to using the BI wizard and add time intelligence, but when I try to do so, I get an error stating: "One or more dimensions do not have a data source view. The time intelligence wizard can only be run if a data source view is present." Does anyone know how to get around this error Thanks! Do you use server generated Time dimension Yup, it's the server generated time dimension. Thanks for the info, Mosha. Is this an active/open issue for Katmai, or do I need to log it somewhere It always better if you - the real customer with the real scenario - log the issue on connect, even if such work item is open somew ...Show All

• Stigern Rollup with distinct -- why?

  I have a group of lastnames with counts of distinct records per lastname. I need a summary at the bottom of the query which tells me how many records I have total. Rollup or cube seems like the way to go, but I can't find any info on using this with distinct records. Thanks for your help. COMPUTE does not work with DISTINCT I think what you may be wanting is the COMPUTE feature. I don't recall if that is available in SQL Server 2000, but it is documented for SQL Server 2005. http://msdn2.microsoft.com/en-us/library/ms181708.aspx I have never used it, but it sounds to me exactly like what you are trying to do. Dan This quer ...Show All

• laserbeam Help with SQL Server 2005 and IIS 6.0

  Hello, I am having problems with my system configuration. I am trying to access a SQL Server 2005 database from a C# .NET web page, but I keep getting this error, " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I am using windows authentication. The SQL Server resides on one server and my web server is on a different server. If I run the both the web server and SQL Database from within the same server it works fine, the problem comes when I separate the servers. I am running Windows Server 2003 on both servers, MS SQL Server 2005, MS Visual Studios 2005, and IIS 6.0. Here is my Web.Config file: < xml version = " 1.0 " > < configuration xmlns = " http://schemas.microsoft.com ...Show All

• jrboddie Report in Multiple Columns

  I have a report, let's say it has two table columns, Name and Phone. I need to format this report so that it will print Name and Phone top to bottom, and then start at the top of a second column instead of going to another page. Do I do this using body columns, and if so, can someone explain how. I have tried by changing the column property of the body to 2, but it just moved a table column over the the other body column. Am I heading down the wrong path I am using VS 2003 to create the report. Thanks Setting the column property of the body is the right way to accomplish this. However, you need to check the page width value of the report. When Body.Column is 2, the report width is divided in half, if ...Show All