Answer Questions

• Rajat_Katyal Analysis Services service won't start

  Can anyone point me in the right direction I haven't used SSAS in a few months and I went to start the service in SQL Server Configuration Manager and I get an error pop-up message: The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details. However the event log has no useful info - just says the service started, then it stopped - no error related info. There are no logs generated in ..\MSSQL.1\. Every other service starts - database, SSIS, SSRS, Agent, Browser and FullText. I'm running Sql Server 2005 (with SP1) on Win XP Pro (SP2). Any help appreciated! There were a few Information type events that said that Ana ...Show All

• Bartosz format datetime column

  Hello, I am wondering if someone could help me with formatting datatime column. Goal - keep column in datatime instead of convert to varchar Current - '2006-06-21 16:54:33.000' Wants - '2006-06-21 16:54:33' Any help is appreciated! -Lawrence Code Bits declare @time datetime set @time = '2006-06-21 16:54:33.000' select @time , convert ( varchar ( 255 ), @time , 20 ) declare @time datetime set @time = '2006-06-21 16:54:33.000' select @time, convert(varchar(19), @time, 121) What transformation are you referring to Is it a DTS/SSIS package If so that can format the data accordingly. Please elaborate on your problem. The datetime va ...Show All

• igorbaITALY NULL in Temp Tables

  Forum, I am looking at another report code (constructed by another user) and wanted to know why the user coded the word NULL after each field in the Temp tables. What does the NULL tell me and why would the user use it Sorry for the Newb question ... I'm still learning the language and could not find any information in the help files. Report Code /* Billing Status */ SET NOCOUNT ON CREATE TABLE #Appt( FacilityId int NULL , Visit datetime NULL , OwnerId int NULL , DoctorId int NULL , CompanyId int NULL , ApptSetId int NULL , CasesId int NULL ) CREATE TABLE #Temp( Visit datetime NULL , PatientId varchar(15) NULL , PatientName varchar(90) NULL , DoctorName varchar(60) NULL , ApprovalResults text NULL , Description va ...Show All

• Tonito01 Do we really need query based optimisation?

  Hello, I was playing with the Query based optimisation in SQL2005. - it is not available by default, you have to enable the query log in the server properties - it generates 1 out of 10 queries log entry - 1 out of 10 query is still a large number of log entries if you have many users and many cubes, 1 out of 10 does not filter any redundant queries. - I also tried to use this mechanism to create an usage audit log, Log table becomes bloated very quickly. - tried to optimise the partitions based on this mechanism and did not see any performance boost. I wonder in which cases this option really makes a difference. I went through all the dimensions design best practices I could find and I finally came to the conc ...Show All

• FlashyPants run openquery(mdx) through a linked server

  Hi, I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error: OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.". Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING". And, I am sure that I have made the MSOLAP provider Allow inprocess. What can i do for this. Ple ...Show All

• giddy Where or IIf clause

  hey there Using Business Intelligence Manager/Reporting Services Data/layout/preview screens. Can someone please explain where I would put these clauses and guide me to correct them This will eventually be a drill down report - but just for the summary page Field 1 = 'tracker' Field 2 = Count where 'closedby' and 'receivedby' are = to 'tracker' Field 3 = Count where 'closedby' = 'tracker' and 'receivedby' not = 'tracker' Field 4 = Count where 'receivedby' = 'tracker' and 'closedby' not = 'tracker' I am looking to put them in layout view in a field in a table - yes/no thank you thanks Adam But this is not giving the right result. I have dropped data into excel to c ...Show All

• hrubesh SQL CE Installation Location

  Hi, When the battery dies the SQL Ce installation vanishes. Especially the following dlls which were copied into the \Windows directory during installation are getting vanished when the battery dies. sqlCese30.dll sqlCepqp30.dll sqlcemme30.dll sqlceer30EN.dll I guess this is because of the fact that RAM content vanishes when the power goes off. Is there a way i could install the SQL CE in the Storage Card I can install the Compact Framework in the Storage Card but not the SQL CE. I have installed the CF, My application in the Storage Card. Just because of this SQL CE does not allow me to choose the installation directory, i have to install the SQL CE everytime the battery dies out. Y ...Show All

• Dietz detach 6.5 compatible database in studio - HOW?

  I've got two databases showing in the studio tree, but they are marked 6.5 compatible and cannot be expanded. Worse, there is no way (apparently) in the menu of either database to remove, delete or detach them. How can I get these out of the system Thanks in advance. randyv No, that doesn't work because it is grayed out... It finally dawned on me that since I could not take any action directly on the database due to compatibility problems, but that the database was from 2000, there was no reason the level could not be increased. To make sure I had no problem with the application, this is what I did. I backed up the database on the 2000 server, then restored it as a different datab ...Show All

• white2grey Ralph Kimball Group SSIS webcast

  We see a lot of posts here related to data warehousing - it is clearly a hot topic with forum readers. You may be interested to see that the Joy Mundy of the Kimball group is giving the following webcast : Using SQL Server Integration Services to Populate a Kimball Method Data Warehouse featuring Joy Mundy July 11: 11:00 AM–12:00 Noon PT Anyone using SSIS in data warehousing will find this to be a most useful webcast - it was a hit at TechEd. I'm sure it will answer many questions and give great insights for forum readers. Donald The Kimball Group has a book "Microsoft Data Warehouse Toolkit" and a companion website www.msftdwtoolkit.com . This should provide you with good information. ...Show All

• Daniel Åkerlund Dialogue security Vs Transport Security

  Hi I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use Where do I configure the type of security being used What is the difference between transport security Vs dialogue security - Full security model Thanks Pl. chk the post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=608211&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost ...Show All

• Gavin C Stored procedure activated more than once

  Hi guys! Is it possible for a stored procedure to be activated more than once even if a message is sent only once After sending the message, I check the sys.dm_broker_activated_tasks and see that it activates more than once. Is there a way for me to prevent this from happening Thanks a lot! :) That stops it activating more than one at any one time. But that doesn't stop the procedure being activated twice, one after the other, even though there are no messages on the queue when the second is activated. If you never want more than one activated task you can set the max_queue_readers property to 1: ALTER QUEUE your_queue WITH ACTIVATION (max_queue_readers = 1); ...Show All

• Squiddy Integrate my app

  I wish sqlserver can send me a mail automatically after completing one job,there are alerts and notifications in job properties,which can perform my need Previously,i defined database mail,but failed who can tell me which is appropriate way TIA I saw your different threads in the groups, did you manage to setup database mail, this should be the first point where we should start. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• schreik INSTEAD OF Triggers

  Hi everyone, I have some doubts about instead of triggers. I used INSTEAD OF Triggers in Order Details table. There is a check constraint in the column that I create a triggre on since I wanted to determine which one are executed. The check constraint and my trigger both perform the same thing. However, when I insterting a record whose discount is bigger than 1, my trigger is executed instead of the check constraint as I expected. So what is the advantage of this This kind of INSTEAD OF Triggers eats (inactivate) the check constraint or another type of constraints which do the same thing with the triggers. In other words, are there any advantage of INSTEAD OF Triggers ...Show All

• aztec2_step SSIS Packages Dynamic Connections

  1) We are doing data migration from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design. 2) We have used SSIS packages and data flow tasks in which we mentioned connection strings for source and target containers. 3) We have a master execute package which contains series of execute packages in relational order. 4) When we execute this master package, we should be able to dynamically specify different source and connection strings for all packages. 5) Can we do it with dtexec option /Conn[ection] IDOrName;ConnectionString We know what to give for ID or Name but what do we give for ConnectionString. Will it be the source/target one Can we specify both source and target ones with which the data flow packages get executed. ...Show All

• Paritosh Mhaisekar DB Mirroring Monitor Job - Purge Old Data?

  Hi, Not sure if this question makes sense, but is it necessary to purge old data in msdb tables used by the db mirroring monitor job I'm just wondering if an insert into the data table every minute of the day would still be needed a month from now. I'm thinking this data would be useful for the purpose of "alerts" and to have access to its recent history, but other than that, is it recommended (or necessary) Would these records keep accumulating until manually purged TIA. Yes and by default that is the setting to keep the job log history. You can manually purge the data using SP_DELETE_BACKUPHISTORY and you can set to retain number of rows or worth of data from SQLAgent propert ...Show All