Answer Questions

• DueyDooDah columns in select list

  In your client, sure -- every client library can do that.  In SQL Server, probably not.   What is the business or technical problem you're trying to solve   Perhaps we can come up with a better way of handling it. -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     < buragohain@discussions.microsoft.com > wrote in message news:6926c563-86b6-40a5-a ...Show All

• TonyKing wmi event watcher task

  hello i would like to know how i can retrieve the file path+name of a file detected by the WMI Event Watcher task, so that I can assign this to a variable for an Import task thanks darren thanks again for this detailed reply. so if the file watcher task cannot be used to wait for incoming files, what would be the typical use I'm sure this scenario of detecting inoming files and importin ...Show All

• davidoweissman Error 6522 Trying to Run Assembly from database

  Hi, I am attempting to load an assembly that has been stored in a table as a byte array. I have created a c# class called AssemblyLoader that takes in 2 parameters, the assembly name and the parameters for the assembly (just a query string). From this it returns the assembly byte array using a simple sql statement within the class using the assembly name to select the assembly bytes to return from the database. The returned byte arra ...Show All

• anydobbo Parametric

  Hello, I'm using SQL 2005 and reporting services. I have several parameters, the report show two parameters in the same line and I would like to present three parameters in the same line. how can I do that This is not natively supported. The closest you can get is to write your own parameter frontend application and then e.g. use the RS report viewer controls to send the parameters to the report s ...Show All

• Verbal Slow execution of queries inside transaction

  I have some VB.NET code that starts a transaction and after that executes one by one a lot of queries. Somehow, when I take out the transaction part, my queries are getting executed in around 10 min. With the transaction in place it takes me more than 30 min on one query and then I get timeout. I have checked sp_lock myprocessid and I've noticed there are a lot of exclusive locks on different objects. Using sp_who I could not see any deadloc ...Show All

• David Smith (MicroStaff IT) embbed AS cube browser

    Hi,   How could I embbed AS cube browser to my application thanks a lot,   I have been looking for the same, but so far I have only seen reference to using OWC (Office Web Components) to embed an Excel doc that references the cube. The add-in is available here: http://www.microsoft.com/downloads/details.aspx familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en ...Show All

• bill1951 How do I attach query results to send mail

  I have several tasks that I don't want to use conditional failure on. I have a ON ERROR send mail task right now that works. I want to have that send mail task include query results from a separate query. How do I do that Peter Cwik Once you have the text file created as Jamie said you can attch the file by send mail task. Or if you want the output in the body of the mail then you can attain that by using ...Show All

• Baz Star I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express Edition (final release)

  Hi   I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine   But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like. Analysis Services -> Deployment Wizard (All) Documentation and Tutorials Performance Tools -> Database Engine Tuning Advisor   ...Show All

• allen_xu .Net framework for SSRS 2005

  Hi, We are plannning to upgrade to SSRS 2005 from SSRS 2000. Does it mean that our clients/users will have to upgrade to framework 2.0 from framework 1.1 inorder to see the SSRS Reports Thanks in advance ! siaj To add to Jens' answer, Microsoft recommends Internet Explorer 6.0 SP1 with scripting enabled. Other browsers can be used and will support HTML viewing functionality but may not ...Show All

• kissinger Knowing what is grouped?!

  Hello! I have a table "A" like this shown bellow and a problem... Vr Kon Value ID DZ PRM 22900 -16.00 101 M PRM 22900 16.00 102 P PRM 22900 -728.19 103 M PRM 22900 728.19 104 P I am doing simle grouping on this table... Grouping is by Vr,Kon,Dz and Value is summed. Select is like this SELECT  Vr,Kon, sum (value) from TableA GROUP BY vr,kon,dz So, my results look like this: ...Show All

• vurdlak cannot open a jscript file

  SQL Server CTP Sept 2005. In Microsoft Visual Studio 8 after starting an Integration Services Project I tried to create a jscript file. A file was created but the browser was completely messed up. First I was never able to open it (right after it was created but not yet saved). The file name "jscript1.js" would appear as a separate tab on top of the window next to the "start page" but when you click on it the the file does not appear in the edi ...Show All

• Steve X Fu Update statement

  Hi All I am having sometrouble with a update statement. The table is about 60 columns, apart from the first one all are NULL. insert into customer (id,sitename) values (newid(),'TEST') The error message I am getting is: Server: Msg 8152, Level 16, State 6, Line 1 String or binary data would be truncated. The statement has been terminated. The column I am inserting into is nvarchar (50) so I am a bit stuck as I dont understand t ...Show All

• Carl.H Domain groups disabled by default. how to enable them by default?

  Hello, I notticed that to add a domain global group to a role, you first have to enable this type of object. Also, I did convert a few cubes from 2000. I have a lot of domain groups associated with a lot of roles, the problem here is that the membership shows a UID instead of the group name because the group object is disabled. 1) How could I have the domain group object enabled by default in a new cube 2) How could I have te domain ...Show All

• Mark with unique display name Upgrading databases from beta 2 to rtm?

  Hi! We are currently developing an application for SQL-Server 2005. We have a machine with Beta 2 of SQL-Server 2005 with a few user databases and want to install RTM of SQL-Server 2005 on a clean machine in the next few weeks. What is the best way to upgrade the databases to the new machine I guess backup/restore will not work Thanks! Jus You can detach/attach just fine, if your prior version of databa ...Show All

• Hidroilio Meta Data

  Hi, I want to get meta data information for DTS packages, I don't see anything when I click on Meta Data Services Package. Also, I get an error when I click on Meta Data "An error occurred while trying to access the database information. The msdb database could not be opened." Need help.. Thanx SQLBob I was actually referring to the original post. I meant to say that DTS was renamed SQL Server Integration Services ...Show All