Answer Questions

• mikho Get the variable from Execute Process Task to C#

  Hi! I need help with some C# code. I have build a SSIS package with an Execute Process Task. I need to send dynamic variables in to my C# program so I thought it was a good idea to use the StandardInputVariable. How do I get the variable in my C# code Thanks Carl Your Main methods parameter collection The data type is string and the value is testing. I have a question for you. Is't meaning that I shall use the main-method to get the argument and the variable Carl Thanks for your help. I tried to get the variable through the main method but it dont work, the only thing I got was the argument. My test code: static void Main(st ...Show All

• Hooper How do I start using Reporting services?

  OK so I'm new to this reporting server stuff.... I installed SQL 2005 and reporting server (default instance and sharepoint) and Visual studio 2005.I I can start off now creating reports in Visual studio but I'd also like to take a look at the reporting service. According to reporting services configuration all works and can be connected to. When I type http://localhost/ReportServer I get message "Microsoft SQL Server Reporting Services Version 9.00.1399.00". So all looks fine but I have no idea how to start the program and start creating reports (as I can do with Visual Studio) To use the web browser based Report Builder you first need to create a Report Model using either VS or the SQL Business Intel ...Show All

• ananta Updating and deleting data using Gridview or Detailsview in VWD Express and SSE

  I am trying to update and also delete records from an SQL Server Express database with the Gridview and Detailsview controls in Visual Web Developer Express. In one database I have got( although I don't understand how) the detailsview to both update and delete but not the Gridview which is using the same datasource and connection. In another database I can't get either to update or delete. I just can't see what I'm doing wrong, and I've been at this for 4 days now. Is there a fundamental rule that I'm breaking Any help would be so appreciated. Many thanks Chris You're right. I've been there subsequently and fortunately it seems that others are experiencing the same problem. Cheers. ...Show All

• Kim Carlsen Replicating roles

  Hello, I use a merge replication between Sql Server and Sql Server Express. When I enable a DB for .NET features (eg RoleManager), I have new tables and roles that are created and some GRANT are given on SPs. When I replicate these DB to another one, none of my roles are replicated and I also loose my roles. Is there a way to replicate also the roles and the permissions Thanks Pierre-Emmanuel Dautreppe use a postsnapshot script for this. if you deployed your subscription through a file copy (unc), you could package up the permissions in a script and use sp_addscriptexec to replicate this to all of your subscribers. ...Show All

• JFoushee Can anyone help explain 'XactSequence' in profiler trace

  Hi All Can you explain the column ' XactSequence ' in detail in SQL Server 2005 profiler trace Thanks in advance. They're not the same. Think of a sql job where you have multiple job steps. So, the jobid is not the same as the jobstepid. It's a 1-to-many relationship. Thanks, can you let me know the difference between transaction sequence and transaction id Also, for dtc transaction, does it have transaction sequence Thanks. But when will SQL create a XactSequence for the specified SQL transaction Also, will DTC transaction have XactSequence transaction sequence. ...Show All

• technica Reports rows written but they aren't

  I have a 3 data flows with an oledb source, a script component and a sql server destination that reports success and that it wrote the rows to the table in question. However, the rows are not written to the SQL Server 2005 table that is the destination. I have many other data flows in the same package that work exactly the same way that insert the rows they should insert in the destination table. An example of the message I get indicating success is as follows: [DTS.Pipeline] Information: "component "SQL Server Destination" (75)" wrote 289 rows. Has anyone else seen this behavior or have an idea what might be wrong Why would the data flow report success when the rows were not, in fact, inserted in the destinat ...Show All

• Craigton Drillthrough results conditionning

  Hi, I would like to be able to set a condition to define the results of my drillthrough in AS 2005. Let's use an example to explain what I am trying to do : We got a Cube with 2 dimensions ( Time, Products ) and a measure ( Sales Amount). In our cube we have stored detailed informations about our vendors, customers and stores. The following statement should return all rows from the columns Customers, Vendors and Stores names. DRILLTHROUGH SELECT {[Time].[Time hierachy].} on Columns, {[Products].[Product.hierarchy]} on Rows FROM My_Cube WHERE ([Measures].[Sales Amount] RETURN [Fact].[Sales Amount] ,[$Vendor].[Vendors name] ,[$Customer].[Customers name] ,[$Stores].[Stores name] I wonder if it is possible to set a conditi ...Show All

• LKeene Help Please...request to send data to the computer running IIS has failed

  Hello,    I am trying to complete the BOL sample " Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http:// sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below. Sub sync() Dim repl As New SqlCeReplication() repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll" repl.Publish ...Show All

• vande013 Login failed for user 'Domain\userId'. [CLIENT: <local machine>]

  I have a strange problem. I have installed sql server 2005 w/ SP1 (developer version) in my local. After the installation the event log shows the following error message: 2006-10-25 01:25:27.59 spid9s Clearing tempdb database. 2006-10-25 01:25:27.89 Logon Error: 18456, Severity: 14, State: 16. 2006-10-25 01:25:27.89 Logon Login failed for user 'Domain\userid'. [CLIENT: <local machine>] 2006-10-25 01:25:28.09 spid12s Starting up database 'msdb'. (Obviousely, I have removed my id for security reasons) The real problem is that I couldn't connect to local or any remote servers using my Sql Server Management Studio . I have spent a lot of time on the forum(s) to find an answer, but seems to me that it is an "unknown" ...Show All

• lucerias Need infos regarding install of SQL Express 2005 SP1

  Hi, A little technical question. If I want to install SQL Express 2005 SP1, do I have to uninstall current version first Thanks in advance, Stephane The 'Advanced Services" edition is the same version of SQL 2005 Express, and it includes additional functionality, including Management Studio Express. Again, you do NOT have to uninstall before adding a service pack. (Now is that complete enough for you to indicate you have been responded and answered SQL Server and Visual Studio are separate products. You do not have to apply SP1 to them in any particular order, nor do you have to apply it to both (though it is a good idea.) Please indicate if your question has been answ ...Show All

• New-Bee Efficient sorting by an XML node value over multiple table rows

  Hi colleagues. I would like to use the newest XML feature for localization problem. So: I have  Country table with Name column of XML data type. This column contains a country's names in amount of languages, in a format like: "<ru> </ru><en>Russia</en><fr>Russie</fr>...". I liked that approach much until I faced a problem - How to select all the countries ordered by French name So I created primary and secondary (PROPERTY) XML indexes in order to increase efficiency of the following query: select top 100 * from Country order by Name.value('(/fr/text())[1]', 'nvarchar(max)') However, when I tested that query over 150 000 rows it turned out to be 60(!) times slower than to quer ...Show All

• teqmem No one can help me on this prolem??????

  or it may be too simple to care about My scenario is: I want to pass a multi-value parameter, Employee, with value set string[]{n1,n2,..,nk} to the report1. {n1,n2,..,nk} is a subset of whole employee name set {n1,n2,...,nk,...,nm}(k<=m), and it value is based on the user's access. when user open the report1, he/she can select one or more user name from the Employee dropdown value list. my problem is, there's no checkbox at the leftside of the Employee values to let user choose the value, so all the {n1,n2,..,nk} are selected as the value of @Employee. I spent time on setting 'Available values' uner "Report-->Report Paramters-->Employee", but can't get what I want. P.S., I do check the 'multi-value' for ...Show All

• Tryst Email subscriptions: changing "from" address for different subscriptions on same server

  I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience). Unfortunately this isn't really possible without doing some messing around. You can make a call to the RS WMI provider to change the SenderEmailAddress value, but you would have to synchronize the code makin ...Show All

• SanK Creating 1 backup for multiple DB

  is there a way to create one backup from multiple databases If what you are looking for is a backup at one point in time for multiple databases, so that they can all be brought back to a common point in time, the way to accomplish that is with marked transactions. There is not a mechanism to create a single backup spanning multiple databases. You can, however use the full recovery model to roll a group of databases forward to a single point in time. The mechanism for making sure that this point is exactly coordinated across databases is to use the BEGIN TRANSACTION 'MyTransaction' WITH MARK statement to begin a marked transaction. If that is a distributed transaction (accomlished by touch ...Show All

• Ted Strom How to programmatically create "Script Database As"-script?

  I would like to programmatically create the same XMLA-script that one gets from selecting Script Database As->CREATE To->File... in Management Studio. Any thoughts on the simplest way to accomplish this Came up with the solution. In case anyone else is interested it is below (uses the Microsoft.AnalysisServices namespace). public static void WriteCreateDatabase() { Server svr = new Server (); svr.Connect(Properties. Settings .Default.ASConnString); Database db = null ; if ((svr != null ) && (svr.Connected)) { db = svr.Databases.FindByName(Properties. Settings .Default.ASDBName); } else { throw new Exception ( "Couldn't get a ...Show All