Answer Questions

• nino_emcee Why can you not create a Query Notification subscription in TSQL?

  The title says it all. You can do it from a ADO.Net client so why not from TSQL. It all uses the service broker stuff so why not You can always create subscriptions from an internal CLR procedure using ADO.Net. HTH, ~ Remus You can not do it from an internal CLR assembly. This is explcitly block. Secondly the comments in the article don't answer the question how you get the Engine to start monitoring for changes to a query via TSQL The explicit block is on the context connections, not on CLR assemblies. A CLR assembly can use a normal connection to set up the notification (connect in loopback to itself, requires external_access permission). I don't know the exact reasons why setting up QN from T-SQL was no ...Show All

• J Tatta Transactions in triggers

  I have an AFTER trigger which responds to a table update process. Within this trigger a separate stored procedure is called which does some additional processing. The problem is that if this inner stored procedure fails, for whatever reason, the entire trigger and the initiating update also rollback whereas I want the update to commit. I have tried using various combinations of SAVE TRANSACTION etc but each time I get messages similar to ' The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.' Does anyone have any ideas I understand that - however what I'm not sure about is what is making this an uncommitable transaction Is it the ...Show All

• Ryn How can I install SSIS on client side?

  Hi, We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it Thanks in advance, Jie Hi Jwei, Take That CD 1 and choose Workstation components, Books Online and development tools. That'll install the following components: .BOL .Native client .BIDS .SQLXML4 .MSXML6 .OWCL11 (Office Windows Components) .SQL Server Backward-Compatibility Files HTH Thanks a lot for the solution Run setup. Choose the Integration Services and Wo ...Show All

• vidya_084 Class Offerings Analysis

  Hi guys, I need a plan of action slides based on this scenarion below. Thanks a lot. The mission of the UCF Division of Graduate Studies is to provide leadership and services to create high-quality learning environments for graduate students. In support of this mission, the Division of Graduate Studies is client-centered and focused on providing the information and services that students need to enhance their experience with UCF and that faculty and staff need to effectively carry out their responsibilities to students. In an effort to continually improve the student experience, the division of Graduate Studies often conducts focus groups and other means by which to collect feedback from students regarding area ...Show All

• NR Partitioning an Existing table

  Hi Champs, I have some tables that already partitioned and some are not partitioned at all. My questions are: How can I partition an exixting unpartitioned table and how can I alter an already partitioned table, to use another partition function and schema /Many Thanks To partition a table you can create the partitioned version and then use switch to swicth the data into the partitioned table. I believe but have not tried it that you can change the partition scheme by rebuilding the clustered index with a different partition scheme. ...Show All

• dbaeck can data analysis done using SQL Server 2005 be used in a consumer website?

  I just have a simple question that can hopefully answer whether I should dive too deeply into Reporting/Analysis Services. I'm looking to run some clustering algorithms on user-inputted keywords on objects within my database (please see http://flickr.com/photos/tags/friends/clusters/ for an example of what I'm talking about). It seems to me that the various reporting methods that SQL Server provides would be an ideal, quick and easy way of providing this for my SQL Server 2005 database. Can the reporting services provide this type of functionality And if so, would this be scalable I would want to be able to access this clustered data in much the same way I do queries across my database and would want them to be done quickly and efficiently ...Show All

• shaul_ei Can SQL Server 2005 Express and MSDE CoExist?

  I read in the installation requirements document for SQL Server 2005 Express the section on upgrading MSDE to SQL Server 2005 Express. The section indicated that if MSDE is installed via an application installation, that application will have to be uninstalled to remove MSDE. This leads to my question. The small application I'm looking into developing will require SQL Server 2005 Express. What if a customer is using an application that installed MSDE Can the two products coexist without problems Thanks!! hi, yes, MSDE 2000 and SQLExpress can coexists... SQLExpress installation will upgrade the installed COM based binaries (SQL-DMO) to SQL Server 2005 level, but they have been tested to be ret ...Show All

• tiomeg Pass a parameter to SSIS from .NET App

  I'd like to pass a parameter value from a ASP.NET application to an SSIS package. My SSIS package pulls data from SQL and loads it a flat file based on the parameter value. Is this possible Sweet! Thanks :) Very much possible. Check out the example @ http://www.codeproject.com/useritems/CallSSISFromCSharp.asp More details on "Loading and Running a Package Programmatically " @ http://msdn2.microsoft.com/en-us/library/ms136090.aspx Thanks, Loonysan ...Show All

• Blast Reinstall Sql Server Express After Developer Edition

  I had to uninstall SQl Server 2005 Developer Edition because of hardware requirements, and reinstall Express Edition download version. But SQL Server Database Services fails with this message: SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . Error Code: 28006. The first time I installed Express the flow of setup ended well without any message. How to act     <Scope Type="FeatureInstallStateScope" Id="1">             <Property Id="SQL_Engine">INSTALLSTATE_ABSENT</Property>          &nb ...Show All

• ajliaks Create SnapShop

  Hello, I'm using Reporting Services 2005. Is there any way to create a snapshot report from the report While user generated the report he would like to save the current report as a snapshot (The report contain several parameters). Is there any way pass to the report URL reqest to generate this report as snapshot Thanks Idan This is not possible. Snapshot generation is always based on the report's default parameters, you can not pass in parameters to generate a snapshot. You could use the viewer control to simiulate this, but it would mean changing the report's defaults before calling CreateReportExecutionSnapshot, and the user would have to have the correct permission. ...Show All

• ykessler 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

• Craig Celeste Does it exist a boolean data type in SQL SERVER ?

  Hello. A question please. To define a column of a table in SqlServer, Does it exist a boolean data type Thanks... Yes, it has a data type for this, this is bit (it is an integer value with the constraint to only allow 0 and 1 (and NULL of course)). HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Atiz Implementing Sql Server Express within a Strict Domain Environment...

  I am looking for some assistance from the grand knowledgebase out there concerning the implementation of Sql Server Express 2005 on a client's strict domain environment. I am designing and implementing a pos software that resides on registers and a server within a number of stores. The registers are running WePos and the server is running Server 2003.  I run an instance of sql server express on all devices. The registers read the server when it can see it but when it cannot it reads the local instance. I am seeing a number of performance issues and I am trying to tweek the installation and coding of SSE on all devices. Any words of wisdom for me out there Thank you, Sir Robert   Hi, can you explain wha ...Show All

• Amos Soma Custom Formatting SQLXML Result

  Here's what am doing: I have a couple of SPs that can only return data in the format i want when i use FOR XML EXPLICIT. The problem is if am using SQLXML then the data cannot be returned as XML since formatting is done by the client (which only gives me the option of raw/nested) and therefore the result i get is not formatted as i need it. Is there a way i can format the result from the SP in the same way as if i were just using FOR XML EXPLICIT on the server side. Example of output formatting expected: <Patients_List> <patient> <Field name="forename"/> <Field name="surname">Patience</Field> </patient> <patient> <Field name="forename">Ada ...Show All

• xecoy Executing SSIS Package - SQL 2005 Express

  Hi,  I have created SSIS Package using DTS vizard in SQL 2005 Express. Help me out to execute the Package.   Thanks Even I am also trying for the Same. Update me if you get a solution. ...Show All