Answer Questions

• Mojosound Programmaticaly associating a schedule with a deployed report?

  I have a report deployment system (in C#) set up such that it takes all the RDL files in a folder and deploys them to the target server. Since many of these reports are computationally fairly expensive, I wanted them to display from a report snapshot, on a daily schedule. Although I know how to do this manually via Report Manager, I wasn't sure which SOAP methods to call on the ReportingServices webservice to make this happen. Anyone have any experience with this or tips Thanks, Arjun It can be set using SetExecutionOptions method ( http://msdn2.microsoft.com/en-gb/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.setexecutionoptions.aspx ) Ah ...Show All

• srimal_s conversion error after promoting to production box

  Problem:  data conversion component going from unicode  DT_WSTR to DT_STR with 1252 codepage using a Source Provider=IBMDADB2.1; So.. I developed the package on the testdb without any errors. However, when I promote the package to the production box, I get this conversion error. I thought that it was specific to one column, so I set the ignore truncation error in the data flow. The next column provided then caused the same error.   what settings can I look at changing to prevent this error what data is being truncated or is the unicode conversion map failing the max(length) is 270 on a varchar 300. I also read something about tabs in this type of conversions failing Why would this b ...Show All

• gbshahaq XMLA for Retrieving Database Names

  Hi: Can anyone please share the XMLA Script for Retrieving the database names on a AS 2005 Server . Thanks Then the easiest would be to use ADOMD.NET, and do OpenSchema with DISCOVER_CATALOGS. You will get rowset back. No i am not making a custom application. I just want to retrieve the db information through XMLA and insert into a table and then query the table. As you said i will have to read the output into some variable of XML data type probably. Thanks AK Here is an article which have a lot of examples about using ADOMD.NET, including usage of OpenSchema. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQLDMPrgrm ...Show All

• mts2325 Eventlog

  Hello everybody, is it possible to add entries to Windows EventLog from Sql Server Trigger if yes, could any body tell me how Best Regards Is there any C or C++ code example to add event log entry I need to access windows event log from SQL Server 2000. Hi, thank you for the prompt reply, i created a C# dll and tried to create an external procedure to call it, when I call AddEntry method, I get the following exception: Msg 6522, Level 16, State 1, Procedure EventLogProc, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'EventLogProc': System.Security.SecurityException: Request for the permission o ...Show All

• Godai B SQL Authentication after removing SQL 2000 for SQL 2005

  I just removed (via Add and remove programs) SQL 2000 Server and now only have SQL 2005 left on my machine. The 2005 Server (SQLExpress ) is set up for mixed mode and I've verified that the registry setting is 2 for LoginMode, yet I'm still unable to login. This is the following error TITLE: Connect to Database Engine ------------------------------ Cannot connect to CJL-SERVER\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'drafttrackuser'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476 -------- ...Show All

• nattylife Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

  God morning! I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases. - I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange! - I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio! - Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection. - We have even tried an 10G version of Oracle with t ...Show All

• Ringo21 Tricky Query

  I have a data table like this: MachineID Product Sales ------------------------------- 1 Magazine $20.00 1 Drink $30.00 2 Drink $30.00 3 Magazine $30.00 3 Drink $40.00 4 Magazine $30.00 5 Food $40.00 5 Drink $30.00 6 Drink $40.00 One of the reports the user needs to see looks like this: Product Number of Machines Total Sales Magazine/Drink 2 $120.00 Drink 2 $70.00 Magazine 1 $30.00 Food/Drink 1 $70.00 To clarify: There are two magazine/drink machines (ID 1 and 3) There are two drink only machines (ID 2 and 6) There is one magazine only machine (ID 4) There is one food and drink machine (ID 5) How do I do this quer ...Show All

• mamo How to tailor CREATE DATABASE for an arbitrary instance

  Suppose the following: As part of a product install (using InstallShield)... I create a SQL Server Express instance (say "X") via a silent install I supply a script to create a database in instance X. The idea, of course, is to have a fully automated install. But there's one problem I can't quite see how to work around: - the CREATE DATABASE statement needs the name of a file to contain the database, and that file needs to be in a folder that belongs to the instance (e.g. Microsoft SQL Server\MSSQL.1, Microsoft SQL Server\MSSQL.2, etc). Is there a syntactic variant that allows me to avoid this problem Thanks Josh Andrea: Between then and now, I found what I needed in ...Show All

• koosha MDX Query returning top levels of dimension hierarchy

  Hi, I use AS2000 which contains the cubes and dimensions. I issue a MDX query using ADOMD and then bind the results to and Asp.Net data grid. When i run the MDX query in the query editor it displays correct results. but when i execute the MDX query in the program it also return the top levels of the dimension hierarchy. I only want a subset (lower level in the hierarchy) to be returned. Here are the details: In our cube we have dimension Region_Country_RU. The hierarchy is as follows. Region(top),Country(Middle), and Reporting Unit(Lowest). The user wants to see Country info by selecting countries as DK,GB,US. This is the query to execute. In MDX query analyzer it gives proper output. SELECT NON EMPTY {{[Meas ...Show All

• Gnarlito 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 where i can find DatabaseCache class i downloaded and install SQLServer2005_XMO.msi but still i cant see that class, other code works fine. Thanks Ok, My code assumes that a database file is used. So in your case the GetDatabase method fails to find the db file from the connection string. Try replacing bkpDatabase . Database = GetDatabase ( dbCache ...Show All

• Bloom326984 Transaction

  how can with in transaction execute statment1 and statment2 then rollback transaction but statment2 not rollback how i can use  CLR SPs I write some procedure but it can't work public partial class StoredProcedures { [Microsoft.SqlServer.Server. SqlProcedure ] public static void proc1() { using ( SqlConnection connection = new SqlConnection ( "server=(local);database=ov; Integrated Security =true" )) { connection.Open(); SqlCommand command = new SqlCommand ( "INSERT INTO tb2(ID) VALUES(2)" , connection); command.ExecuteNonQuery(); } } }     when run procedure with out transaction its work ok, but  when run in transaction, err ...Show All

• Rafet restoring a db in SQL Server 2005

  Hello, I received a backup Sql Server file and I am trying to restore it. When trying to restore the backup using SQL Server 2000, I get the following message: "the backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE DATABASE is terminating abnormally." After doing some research online, I figured out that the backup I received must be from SQL Server 2005. Therefore, I installed SQL SErver 2005 on my laptop (so now I have both 2000 and 2005 on my laptop).. I tried to use the restore database option in SQL Server 2005 ( SQL Server Management Studio) to restore my backup, and I get the same error message (written again below) as I did ...Show All

• JIM.H. Dynamic columns

  Hi, In my report i want to display dynamic columns.For displaying what are columns available to user,Iam displaying the columns names in one multivalued parameter.For example in my report i have Date,CaseId,Age,State as columns,and multivalued parameter name is "Columns". I wrote a custom function i.e ShowParameterValues(...) returns String s.If we select the Date and CaseID from the columns then s contain value:Date CaseID Public Function ShowParameterValues(ByVal parameter as Parameter) as string Dim s as String For i as integer = 0 to parameter.Count-1 s =s+ CStr(parameter.Value(i)) Next Return s End Function Now i want to show those two columns only.How to acheve this. Thanks in advance ...Show All

• DVD_SH API for creating user or group

  What's the SOAP API call to create a user or group It seems that when someone successfully logs into Report Server, a new user is created for that user. However, is it possible to create a list of users on demand There are no explicit APIs for managing groups or users. In fact, the report server doesn't even know anything about groups - group membership is handled by the Windows APIs. Assuming that users are authenticated and authorized to access resources, the user is created automatically. I want to use Reporting Services to manage reports with several clients. When a new client is added, I will create a folder under the Home folder and create user accounts for their administrators. Then I will ...Show All

• antares41_41 "Package Configurations" Problem

  Hi all, I have just set up my first deployment utility for the Integration services package i've been building. I seem to be getting problems with the package Configurations. I added an XML config file so that i could change the values of my SQL connection manager at deployment time. This was so that i could deploy it on both a test environment and the live environment. Any other variables can be changed in code by the calling application. As soon as i added the options for the sql connection manager and enabled package configuration i got errors when running the application: [Execute SQL Task] Error: Failed to acquire connection "InternalProductionData Connection Manager". Connection may not be configured correctly or you may no ...Show All