Answer Questions

• Olav Tollefsen Printing report produces .25 inch horizontal offset

  When I print my report to the printer it is not centered correctly.  It is offset around .25" (or more) to the right.  I have my page setup as 8.5" x 11".  I have all my margins set to 0.5".  My body is exactly 7.5" x 5".  When I export to pdf everything is centered.  When I view the report in the 'print preview' type view it is centered.  However, when I actually print it is offset.  I measured the output ...Show All

• Stephen Toub - MSFT Aggregation Question

  Let's say we have 2 attributes: a and b. Each consists of the defaulthierarchy of an all-level and a leaflevel consisting of the leaves 1 and 2. If I add an aggregation on (a,b) then questions such as SELECT [SomeMeasure] ON 0 FROM [Cube] WHERE (b.b.2) should yield an answer that is preaggregated, right I.e. the coordinates (a.all,b.1),(a.all,b.2),(a.all,b.all),(a.1,b.1),(a.1,b.2),(a.1,b.all),(a.2,b.1),(a.2,b.2),(a.2,b.all) shou ...Show All

• sudev Using 2 connections and DB in a query

  Hi, this is proberly a really stupid question, but I am new at this, so here goes: Is it possible to use two connections in a SELECT, i.e. SELECT * FROM p WHERE pno IN (SELECT pno FROM sp) where p is from one connection, and sp is another. Why Well I am trying to stage some data, (my very first attempt at it), and want data from the foreign table where a date is higher than a date stored in my "settings" table located in my ...Show All

• mk20 connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly

  hello, i've installed SQL server 2005 express and Visual web developper 2005 express. when i whant to create a database in VWD the following error occures: connection 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: go.microsoft.com/fwlink/ linkId=49251 i searched the internet but can't find the solution, i already reinstalled m ...Show All

• starkami How to build OLE DB tests in MDAC 2.8? (can't find "msxmloledb.h")

  Hi, I am trying to build OLE DB conformance tests, which are included in MDAC 2.8 SDK. The following error occurs during compilation: "Cannot open include file: 'msxmloledb.h'". I couldn't find any information about such include file (msxmloledb.h) also in internet. Can someone, please, tell me, where can I find include file "msxmloledb.h", or how to build OLE DB conformance tests without it. Thanks in advance ...Show All

• TheOneFD Connect with SQL Mgmt Studio to SQL Server 7 ?

  Is there a way to use the new SQL Managment Studio to access SQL Server 7 as well as the 2000 and 2005 How can I do this You cannot use Management Studio to access SQL 7.0. You can use it to access SQL2K and SQL2K5. ...Show All

• Nihar Managing an axis in a SQL 2005 Reporting Services Chart

      Hi,    I'm getting my feet wet with SQL 2005's reporting services charting features and I can't seem to find a way to have my Y-Axis stay constant.  I've created a Line Chart and have set the Minimum and Maximum scale to 10 for my Y-Axis.  The report seems to ignore this and sets each chart in the report relevant to the data for the series.  This means that my charts, which are performance indicato ...Show All

• drachx how do i get grid view inside the report

  hi there... how do i grid view in report Are you asking for a Grid view like in SharePoint, where you can edit data in place   If so, Reporting Services does not offer this capability right now. You can display data in a table layout. You can also display data in a cross-tab or matrix layout.  The only thing you cannot do is edit that data in the web page. Hope that helps, -Lukasz --- Thi ...Show All

• Martin Danner Cannot select "Server Database Engine" when installing SQL Server Sep 2005 CTP

  I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are  check boxes on the Components to Install page of the Microsoft SQL Server Installation Wizard to select component groups for your SQL Server installation, they are all disabled , except " Workstation Components, Development Tools, and SQL Server Books Online". I tried installing and after it finishes, there are no SQL instances.... What am I doing wrong Please he ...Show All

• InoS Datetime behavior

  Hello, i'm using SQL Server 2005 Ex SP1, i would like to ask may be newbie question. On some machine have to input query in this datetime format '21.6.2006' and on the other one in '2006-06-21'. Collation setting is on both the same. What's dependin on, please Thank you for any help. The formats in the user interface are usually depending on the regional settings for the user working with the application ...Show All

• Sunil_D No mapping between account names and security IDs was done.

  I received the following when trying to deploy an 2005 analysis services package over an existing database: The following system error occurred: No mapping between account names and security IDs was done. We have redeployed this solution several times over the last week and have never encountered this error. The changes that we are deploying are related to partitioning of the measure group fact tables - and are not related to security in a ...Show All

• warp9.5 Reporting Services HTTP 401 Unauthorized Error

  I have IIS 6.0 on Windows 2003 spk 1 configured for digest authentication. Using a bland test html document, I can authenticate via IIS using my domain credentials to the html document. I then attempt to access the report manager folder document and get HTTP 401 unauthorized as a message. Not sure what I have to do to the reporting service piece to have it allow digest authentication RS does not support dige ...Show All

• saw1234 How to audit all SQL Queries in a database?

  How can you audit all queries within a database Profiler is very costly, but you can set up a job to run a trace, just for certain types of events, like Batch Complete and RPC Complete, which will capture all of the queries run. If you script this in a job, then direct the results to a trace file on the hard drive of your server, the cost is minimal. You can then use fn_get_traceinfo to review the trace files ...Show All

• NeverGone Logging Issue

  We are running into a wierd problem where the "UseParentSetting" LoggingMode only works for the immediatelly called (child) package - the one right after the package that defines (enables) the log. So say you had three packages: Pkg1 enables logging and calls Pkg2, Pkg2 inherits the logging by setting LoggingMode=UseParentSetting and calls Pkg3, and finally Pkg3 inherits logging from Pkg2... In this scenerio Pkg3 would not ...Show All

• Docile Problem Assigning Value to Package Variable From Data Flow Script Component

  In my Script Component properties I have included "ClientReportGroupId" as a ReadWrite variable. This variable is declared as a Package Variable. So, in my Script Component I do this: Me.Variables.ClientReportGroupId = CInt(Row.ClientReportGroupId) But that returns the error : Error: 0xC0047062 at JobSet Table Task, Script Component 1 [385]: Microsoft.SqlServer.Dts.Pipeline.ReadWriteVariablesNotAvailableException: The collection of variables loc ...Show All