Answer Questions

• Waqar Azeem Errors in the OLAP storage engine (first deployment using AdventureWorksDW)

  Here are a few of the 24 errors. I looked for missing foreign keys but didn't find any. Any help would be appreciated. Error 2 OLE DB error: OLE DB or ODBC error: Query (5, 25) Parser: The syntax for 'AS' is incorrect..  0 0  Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed.  0 0  Error 4 Errors in the OLAP storage engine: An error occurred while the 'English Month Name' attribute of the 'Time' dimension from the 'Analysis Services Tutorial' database was being processed.  0 0     <Batch xmlns=" http://schemas.microsoft.com/analysisservices/20 ...Show All

• ahmedilyas full, differential, transaction hwo to rotate the differential?

  Being of the "point and click"-generation I managed to create some sort of a fairly simple backup plan for our databases. There are hourly transactional backups and daily full backups, which were set up with a database maintenance plan. As the databases store event records they are ever increasing around the hour. The daily backups are now of a size that holding them is not feasable anymore and I want to move to a differential backup scheme: Weekly full backups Daily differential backups Hourly transactional log backups The problem I have is that the database maintenance plans allow me to rotate backup files automatically as they included the date and time of the backup. For differential backups there is no option ...Show All

• Cobolman Monitor SQL Server status through Notification Services

  Hello, I am new to Notification Services. My question is can notification services be used to monitor the status of sql server 2005 (stopped/started) and databases (online/offline). Thanks I probably wouldn't use NS for this. Use the Microsoft Operations Manager with the SQL Server MOM pack. The MOM pack is available at http://www.microsoft.com/downloads/details.aspx familyid=79F151C7-4D98-4C2B-BF72-EC2B4AE69191&displaylang=en . Or, you can use SQL Trace and event notifications to receive notifications of SQL Server events. See the Montioring Events section of SQL Server Books Online for more information. See http://msdn2.microsoft.com/en-us/library/ms190378.aspx . -Diane Lars ...Show All

• Patrick P. REnder Reports

  Hi, Can multiple parameterised reports be combined(or rendered) into one PDF or MHTML format How is it done (ReportingServices 2005) Note: The reports generated have same structure but the values in the fields as the input parameter changes. Thanks in Advance Regards, Somu We do not currently have a report concatenation feature. You might be able to get there using subreports. ...Show All

• jdang Database Mirroring

  Hi, Would anyone know if database mirroring with SQL Server 2005 is ready for public use or if it's still being tested. Has anyone been successful at setting it up Thanks, Sylvie It is definitely ready for use. In the versions of SQL Server prior to Service Pack 1, you had to enable a trace flag, but that's all cleared up in SP1. You can find out more about it here, along with the steps to set it up: http://msdn2.microsoft.com/en-us/library/ms177412.aspx If you want to try the client auto-failover, open this page and search for "mirror": http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/SQLServerDatabasesAndSamplesOverview.htm#MirroringFailover ...Show All

• Whoisit SQL Server Agent not finding the package to run

  Hi, I have been searching through the posts hoping to find an answer to my problem. Most errors and problems seem to deal with Agent not being able to run packages because of permission issues. My problem has to do with SQL Server Agent not finding the package to run. I have a proxy with a high enough level of permissions (SqlAgentOperatorRole). The error message I get is: Executed as user: ___/____. The package could not be found . The step failed. The package is in a folder on our network. When I create the step I use the browser to go find and select the package. So why does it not find it at runtime I can run it manually My group is using 2005 for the first time. Any help you can provide would be very much appreciated. ...Show All

• Landon Parks Using CASE in WHERE statement

  Hello, This is what I'm trying to do : ALTER FUNCTION [dbo] . [CAExportSelectAll] ( @CodeLabel nvarchar ( 255 ) ) RETURNS TABLE AS RETURN ( SELECT CodeLabel FROM CAExportPreSelect WHERE ( CASE WHEN @CodeLabel = 'CLASSIQUE' THEN CodeLabel = 'NV' ELSE CodeLabel = 'MT' END ) ) It doesn't work, and tells me there's something wrong in the WHERE statement. Where am I going wrong Thanks very much. Thanks a lot Dave. Actually I have found a solution to my problem that is slightly different to yours, here's what I did : ALTER FUNCTION [dbo].[CAExportSelectAll] ( @CodeLabel nvarchar(255) ) RETURNS TABLE AS RETURN ( SE ...Show All

• Manolis Backup and recovery of SQL Server using VB.net

  Hi, I have a small application in which i'm using Sql Server as Database. my requirement is how to take the backup of the entire database or some tables from the database when there is any delete from the database. My requirement is to do from the VB.net application.Hope i delivered my question correctly. Any little help is beneficial to me. -regards GRK Hi , forgive me for the late reply.I tried the above code it is running after small changes to the code.thanks a lot -regards GRK Hi, It's normal, DatabaseCache is my own class that contains all the data of my application :) Basically you need to remove that and replace dbCache . SqlConnection in the Connect function with the connection you use for ...Show All

• Erik11 Third Major Flaw with Reporting Services!

  What is the way to keep multiple detail rows together on one page. There seems to be no future to keep multiple detail rows together. I'm not talking about table keep together, group page break or anything like that. I have 3 rows that need to be in one page at all times. Is there anyway that this is possible Enkh Whats so special about these 3 rows that they get broken up onto separate pages Well this is just a serious layout and requirement concern nothing more. It is nice to have every detail item (3 rows each) on one page instead of spreading into two pages. In this case it is hard to read and keep track of what item you are looking at the page, and so that you have to flip to the previ ...Show All

• Xargo Visual Studio Output information in debug mode while running a SSIS package

  Hello When running a package in VS you can see something like this in the output window: SSIS package "logging.dtsx" starting. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "C:\test ssis logging\bad_data1.txt" has started. Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning. Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file. Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total numb ...Show All

• sfx1 Can't log in to reporting services in my browser

  I've installed the Developer's edition of SQL05 on my PC at home. I am able to open the reporting services via the Manager Studio and Windows login under my username and password, however I cannot open it in my browser when I enter the http://computername/reports address. I get a login dialog and enter "computername/myloginID" for the user and my local login password. It will not accept the login and reprompt until I exceed 3 tries. I also tried logging in with the PC's admin id and password as well as the sa account name and password. Any ideas on what I missed in the setup or security Thanks for any assistance anyone can provide mike... Hello Mike, I believe this is due to the security settings in IIS. ...Show All

• Eric Wellnitz Importing data from Cache DB on Unix server

  Good morning, I am using SQL Server 2005 attempting to create a daily download of the tables on a Unix server in a Cache database. For one reason or another, when I try to import the data, I can't see the Unix server on our network. Using Server 2000, I was able to do this, but Server 2005 won't let me. What do I need to do to make Server 2005 see the Unix server TIA, Mark ...Show All

• DeadlyEvilRyu ODBC SQLFetch problem

  Hi, I have ODBC code reading data from a XLS file. It opens the file, reads the sheets and columns available, then presents a dialog to allow the user to select which columns are to be used to load the data. All of this works, almost. It is a simple "Select A,B,C FROM Sheet1" using SQLExecDirect When using SQLFetch it always skips the first row of data. Thanks, any ideas would be great. Keith Thanks for the response, I have played with different row sizes does not change the results. I have also tried different files with different row counts, It always miss only the first row. I have also added blank rows above the first and it still misses the fir ...Show All

• ShrikantBijapurkar SSIS variable that should contain uniqueidentifier

  Hi I am importing data and wand to assign a fixed value to an output col. the fixed value should be a uniqueidentifier maintained in a variable so that it can easely exchange prior to execution. My problem is that I realized that there is no variable type for uniqueidentifier. When trying to store the guid in a string variable and then trying to cast back using a script component i received a casting exception telling me that a string cannot be converted into a guid. I dont want to use an object type because then i would have to manually read out the variable a execution start. Does anyone have experience using varialbes and guids Thanks a lot Alex It appears that casting to DT_GUID in SSI ...Show All

• peebman2000 sql beginner - saving views to a file

  is there anyway to automatically save a view to a file at a scheduled time Thank you for any help or pointing me in the right direction. You sure can - just change the query part ( the -Q"something something" part) to this: EXEC sp_helptext 'viewname' Of course, replace viewname with the name of your view. Buck There are a few ways to do this, but the simplest is probably to use a command-line tool such as osql which comes with SQL Server or the client tools. You can schedule this using the Windows scheduler or an AT command in the operating system. I have a full example and tutorial of that here: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=151 ...Show All