Answer Questions

• nitin.dac Access 2003 and SQL Express

  Is there a way to integrate Access 2003 as the Front End for SQL Express I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow. As you can see, I am totally new to SQL and any help would be appreciated. Thank You, James Create an ODBC connection using administrative tools, and then connect to it from ACCESS. ...Show All

• rothth Execute SSIS package without SSIS console

  Hello, How can i do to execute SSIS package without SSIS console This can occur when you use a hosted database with your hosted web. thanks   Coroebus wrote: Do you mean that i can execute a dts package from an aspx web page Yes. Search this forum for clues. You should use the Microsoft.SqlServer.ManagedDTS assembly A few links: ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/dtsref9mref/html/T_Microsoft_SqlServer_Dts_ ...Show All

• Rajesh Choudhary how can i use The "Use Database" statement

  the question is how to use use database statement if the name of the database contain spaces please help me Thanks Unfortunately you can't add images here in the fora, but I believe you mean this one http://www.insidesql.de/images/stories/google_bart.gif But I think, this one's also pretty cool http://www.insidesql.de/images/6thsense.jpg -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de If I offended ...Show All

• MarianL error on installing sql express 2005

  I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following: System Configuration Check - - COM Plus Catalog Requirement (Warning) Messages COM Plus Catalog Requirement If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the file ...Show All

• AmolK How to find how Activation has failed

  I have seen the posting on determining how activation has failed and looking through the system logs is very helpful in determining why activation is not occuring, however, short of looking through the SQL Server logs is there another way to get the same information Access to the SQL Server logs is fairly restricted. Does anyone know another way that this can be done I have used the execute as technique described in the article on "Troubl ...Show All

• hvac-r_tech Someboy help me to receive the status of cubes's metadata info via SQL Query.

  Someboy help me to receive the status of cubes's metadata info via SQL Query. I've been analyzing this problem for two weeks and found several solution for example ActiveX (ADOMD.Catalog) or other programing solution, bat I want faund SQL solution this problem. Information Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service ...Show All

• orc Management Studio DB properties window failure

  Starting with DB's created with SQL 2000, detached, then attached to SQL2005, I can access the tables and data fine in Mgmt studio. But If I right-button click and ask for properties on the DB I get: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) --------------------------- ...Show All

• Anand K Moving from one computer to another

  I am developing an SSIS package in a local computer. I have connection managers defined that link to a SQL Server database. I connect to the database using SQL Server Authentication, a username and a password. When I copy the package files and try to execute them in another computer, the password is lost and I have to edit the package and rewrite the password. How can I move a package between computers and not lose the password Regards, Pe ...Show All

• ArekP XMLDP documentation?

  Does anyone know where there is documentation on XMLDP and the query syntax necessary to process XML data sources in reports Have a look here: http://msdn2.microsoft.com/en-us/library/ms345251(SQL.90).aspx Thanks, that URL got me started, but I was looking for more specific information about the syntax and behavior of the <Query>, <Method>, and <ElementPath> elements. ...Show All

• Persistent Systems Aggregating time stamp data for a time series plot

  I have an application that records data points using timestamps.  For example: START        FINISH        VALUE 01/01/2005  02/25/2005  5 02/25/2005  04/16/2005  3 04/16/2005  06/03/2005  7 I need to be able to plot the data as a time series prorated across the time "buckets" (think of a stock ticker).  I have done it successfully in T ...Show All

• Jonathan Rajotte BreakpointManager,BreakpointSite

  Hey i am creating a custom component and want to give the user a breakpoint or 3.  in AcceptBreakpointManager I say this._bpm = BreakpointManager _bpm.CreateBreakpointTarget(1,"You hit #1"); _bpm.CreateBreakpointTarget(2,"You hit #2"); It was my understanding that I would be able to see these breakpoint descriptions in the list of breakpoints for my custom task.  I cannot.  All i see is OnCustomEvent which unless I have missed so ...Show All

• IngJVV Using Xml data columns in Report Models

  I am working on a project where I need to expose some Xml data columns to a user that will be using the columns in Report Builder. I need to give the user the ability to query the nodes within the Xml data column. After creating the Data Source View, then opening up Report Builder - when I try to add the Xml column to the filter, I get a yellow warning icon next to the condition... Does anyone have any ideas on how to accomplish the task Cra ...Show All

• Savillum Setting Device Info Settings

  Hello- Is it possible to set the HTML device information settings ( such as StreamRoot, Replacementroot, HTMLFragment ) through the URL or by config files (like rsreportserver.config) I'm able to access settings such as JavaScript and Toolbar using the URL like this : rc:Toolbar=false , but it does not seem to be working for other settings. If these are not available via the URL is there a list of which settings are available and ...Show All

• Rupesh Bhurke Error Creating Counter???

  Does anyone know what causes this error (Error Creating Counter) w3wp!library!9!9/8/2005-14:25:27:: e ERROR: Error creating counter.  Category: RS Web Service, Counter: Total Cache Hits (Semantic Models), Instance: APPCENTER2005.  Error Description: System.InvalidOperationException: Counter 'total cache hits (semantic models)' does not exist in category 'rs web service'.    at System.Diagnostics.SharedPerformanceCounter..ctor ...Show All

• Gert Drapers - MSFT How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. I don't understand. You're selecting from multiple tables. Don't those tables have ID columns Can't you use those SELECT av .*, cs .*, ti .*, ti_alt_tit ...Show All