Answer Questions

• Nfrf External Activation and Notification Services

  I have been going over the samples from PDC 2005 and trying to run the External Activator program in section 2 'CLR Services'. After sending a message to the Inventory Queue, I see that 'dm_broker_queue_monitors' table has a row in the table, with the state column shown as 'NOTIFIED', but the ExternalActivator program never gets notified of the event and therefore never launches the 'InventoryServer' program. Querying the [ExternalActivatorQueue] shows no rows. Querying the [Inventory Queue] shows messages are waiting to be received. Executing the 'activator' command in the ExternalActviator program shows Notification service 'ExternalActivator' on SQL Server 'DBSERVER\' and Database 'In ventory' is connected to the database and working. ...Show All

• Alex Smirnov Backup Script Completing But Not Working

  I have a SQL Server Agent job that executes the script listed below (using a step of type "Analysis Services Command") to do a backup of an SSAS database on a nightly basis. The job takes a while (say 15 mins or so) and appears to be busily doing something (meaning the CPU's on the server have activity). However, after the script completes, there is no backup file anywhere to be found. Anyone have any idea what might be happening BTW, if I execute this command manually as an XMLA command while in a query window in SSMS, it seems to complete successfully (producing the .abf file) every time... Dave Fackler --------------------------------------------------------------------------------------------------------------------- ...Show All

• desilets Dim design / MDX help

  I have two queries one runs very fast and other very slow. The difference is very little is both. I must be doing some thing wrong is dimension design but not able to solve it. [Eq up 2sd %] - is a calculated member which I bring to Pivot table to test fast and slow running queries. When I look into profiler fast query has some events "Query Subcube" and then end query but for slow one I get "Query Subcube" then there is pause with Notification - Flight Recorder Snapshot begin then Server state discover begin/end and same group again and again. My Instrument Sector Dim has attributes (attributes -> <relation>) Instrument Desc -> Issuer Desc, Issuer Desc -> Sub Ind cd, Sub Ind cd -> Ind Cd, Ind Cd -> Inst ...Show All

• McWhirter xp_delete_file

  I created a maintenance plan to remove files older than 2 weeks. The plan executes successfully, but does not work. I notice in the log that the single quotes are doubled. I ran one command which worked, but others did not. Is there a problem with the command Here is a copy of the log: Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399 Report was generated on "SQL". Maintenance Plan: Clean Up Backup Files Duration: 00:00:12 Status: Succeeded. Details: Cleanup Master (SQL) Maintenance Cleanup on Local server connection Cleanup Database Backup files Age: Older than 2 Weeks Task start: 9/12/2006 7:34 AM. Task end: 9/12/2006 7:34 AM. Success Command:EXECUTE master.dbo.xp_delete_file 0,N''F:\SQLBackup\master'',N''ba ...Show All

• mattman206 anyone ?

  I've populated reporting DB's in the past using different techniques: 1. Have Transactions in Data Tier Write to OLTP AND Reporting DB Simultaneously 2. Log Shipping 3. Restore BAckups Nightly 4. Replication 5. DTS My question is what is the BEST Practice in SQL2k5. I'm all gung ho about using Mirroring but am not certain that this will be the best way to go. My thoughts are something along the lines of this 1. have OLTP Mirrored to what I'll call a "Staging" DB. This is NOT to be used for Failover just as a means of accessing read only data for the Reporting DB 2. Have 2 DBs on another box that are flattened (Denormalized) for reporting (ReportA and ReportB) 3. Use SSIS to Populate the Report DBs ...Show All

• Barron Gillon retrieve AM or PM

  HI Chaps very simple question this time Is there any method availabe to retrieve AM or PM value from date, IN TSQL hoping will get answer shortly regards, Anas Any of these maybe select convert(varchar(20), getdate(), 100) -------------------- Aug 10 2006 4:10PM select convert(varchar(28), getdate(), 109) ---------------------------- Aug 10 2006 4:10:41:593PM /Kenneth THANX FOR ALL YOUR REPLY I DID IT BUT MY QUESTION WAS IS THERE ANY BUILT-IN WAY TO RETRIEVE AM OR PM ANY WAYS THANX A LOT I JUST NEED THE VALUE AM OR PM NOT THE COMPLETE DATE you want quick and dirty (filthy dirty)- well here you go SELECT substring(convert(varchar(26) ...Show All

• Larkin Y Question about reportBuilder (Installation)

  Hi ! I've already ask this question a couple of weeks ago but nobody answer me so i'll ask again . We have a web application using ReportServer. Some of our client want to be able to create their own reports and to add them. So we thought that ReportBuilder could be a good idea. We would create model for them and using ReportBuilder they could create easily their reports. My question is how can i install ReportBuilder What i mean is reportBuilder seems to be working fine when he is install on the Server. What i want is to install ReportBuilder on different computer and configue ReportBuilder to connect to the Server. Is it possible How Do we need to buy licence Thanks ! Hi, do it from the Report Man ...Show All

• Learning VB Missing Integration Service Template - fixed now

  I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail... What do I need to do to fix it Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install. I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which ...Show All

• Minherz SQL 2000 - How to Reduce data files from 2 to 1?

  Hello, I have an 80GB database which consists of two data files. We recently encountered a bug associated with the use of multiple files (see KB Article #818096). Microsoft has a fix in SP4, but our vendor will not certify their application for SP4 (at least not without lots of $$). Therefore, I want to reduce the number of datafiles from two to one. I tried to restore the DB to a new database with only one file but it still wants to create two data files. I considered creating a new DB with one file and copying the data to this new DB, but the size is currently 80GB and we only have 50GB available. Does anyone have any suggestions for another way to reduce the number of files to one Thanks for the ...Show All

• billqu How to direct T-SQL executoin output to a file

  Is there a SQL Server 2000 equivalent of the Oracle SPOOL command like SPOOL 'C:\TEMP\MyFile.txt' which can be placed at the top of a series of SQL commands to direct the execution messages and results to the nominated file I want to use this in a Stored Procedure executed from within Access and capture all system and error messages at the server level. This will work if xp_cmdshell is enabled DECLARE @isqlString varchar ( 255 ) SELECT @isqlString = 'isql -Q "SELECT top 10 FROM TABLE" -E -o C:\Results.txt' EXEC master .. xp_cmdshell @isqlString hi, open sql query analyzer click on "query" click on "results to file" run a query. ...Show All

• GeorgeOu SQL Server 2000 and 2005 on one machine?

  Hi, i have SQL Server 2000 running on my notebook for learning purposes. Is it possible to run SQL Server 2005 on the same notebook without using virtual machines Thank you, Tobias yes this can be done. One thing that you will have to do though is to run each of them under a different instance name. You can only hae one engine listening on each instance name. For example you could have the default instance as sql2000, and a named instance as sql 2005. On my dev laptop and machine I am running <MachineName>\SQL2000 as sql 2000 <MachineName>\SQLEXPRESS as sql 2005 Express Edition <MachineName>\SQL2005 as sql 2005 Developer Edition As others have said, sure no problem ...Show All

• brianpmccullough Error: The component has inconsistent metadata

  I have a Source Query with this sql set as a property expression: "SELECT Category, Server_Name, Entitle_UserID,User_SubID,Start_Time,End_Time,Entitle_User_Name,Stat_Name,Stat_Count,Stat_Type,pk,create_date,run_num,Average,Median,Maximim FROM tbl_ws_stats WHERE pk > " + (DT_STR, 100, 1252)@[pk_var] There is a message : 'The component has inconsistent metadata.' Then when I click on the Source Query: 'The component is not in a valid state. Do you want the component to fix itself automatically ' I also notice that there are no columns on the Column Mappings tab and no way to add columns. How can I correct Thanks That's correct. There are no columns. Is there any way ...Show All

• PAULL SQL Server time zone?

  I don't know what is going on, here's the error message, could someone please answer thanks Server Error in '/' Application. been there done that, no one knows what that is over there, only told that I was shut out of the SQL database and no suggestions since. I know I'm not shut out of the database since I can upload other things besides new users to it, but if it is searching for something in the ASP.net program no one knows what it is. Thanks might it be possible that it was corrupted when the db was corrupted I didn't change anything so don't know how it would be changed unless it became corrupted in someway. Is there a way to check on this Paul ...Show All

• Maaloul Grand Total Needed

  I have two subreports (Revenue and Expense) that each have subtotals. This works just fine, but I need a Grand Total that would sum the two subtotals. How would I go about doing this So it looks something like this: Revenue Report (matrix) Subtotal Expense Report (matrix) Subtotal <~~~~ Need Grand Total here. I'm not quite sure how to implement that since my revenue and expense report have a column for each month in the current year. Maybe I should draw it out a little better:   Revenue Report(matrix)                           Jan    &nbs ...Show All

• Pedro Felix scheduling ssis package

  Hi there!! I have created a ssis package and now i want to schedule it on SQL Server Agent. How do we create new job for SSIS package Rahul Kumar hi gotta answer at: http://msdn2.microsoft.com/en-us/library/ms139805.aspx thanks and regards Rahul Kumar ...Show All