Answer Questions

• Leo Kent How to determine mirroring role?

  Once I have identitied that mirroring is enabled on database via SMO Database.IsMirroringEnabled, I need to determine the mirroring role. I noticed an enumerated type - MirroringRole, but no SMO method/property to access it. I have tried to query the sys.database_mirroring table directly, but this fails with an exception on the mirror database - as it is being mirrorred :-( What is the recommended way to determine the mirroring role Thanks, Nick You don't need to connect to the mirror database (you can't, as you have experienced). You can connect to the master database on the mirror server and execute the following query: SELECT m.mirroring_role_desc FROM sys.database_mirroring m JOIN sys.d ...Show All

• Charles Tam Referencing one item's hidden property in order to set another's hidden property

  Hello, I have a group I'll call G4. The header table row for G4 contains 3 textboxes containing the sums of the contents within G4. The header table row for G4 is visible while it's contents, including the G4 footer table row, is kept invisible until the report user drills down into the group. When the report user drills down into G4 the footer table row becomes visible and the sums of the contents of the group are displayed for a second time. At this point I want the sums in the header to be set to invisible when the sums in the footer are made visible by the drilldown. When I try to reference the hidden property of textbox66 in the G4 footer in order to set the hidden property of header textbox57 in the G4 header I get ...Show All

• mschelstrate Views Very Slow!

  Hello, From what I have read from various sources, views as an Oledb Source component source are very slow. In practice I have experienced this as well - they are painfully slow. One of the most recent books out on SSIS documents this fact and says to use an ad hoc query instead. I'm curious if someone from Microsoft could expxlain why this is in more detail. I have clients ask this question, and would like to know for my own purposes as well. Further it would be nice to know if this is expected to change in v.next. Thanks much   dcb99 wrote: Darren, I'm asking why _Microsoft_ says that you should  use a SQL statement within the Oledb Source instead of a view.  They ex ...Show All

• good1ed Sql Delete Question

  I don't know if this is where I should post or not. I am trying to figure out how to get this select statement which generates all of the records I need to delete. Here is the select statement. SELECT * FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 I tried writing the Delete statement like this, but lo luck. DELETE FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 How would I re-write the statement t ...Show All

• KFitzgerald Strange SqlBulkCopy Exception with SQL Server 2005

  Hello, Wondering if anyone can help with a strange exception thrown while using the SqlBulkCopy class. I am using the class to transfer records from a DataTable in memory (approx 11,000 rows) into a SQL Server 2005 table. Initially, the WriteToServer method was timing out a la KB913177 ( http://support.microsoft.com/default.aspx/kb/913177 ), however I downloaded the hotfix, which eliminated this issue. Now, I get a new exception thrown, as follows: System.Data.SqlClient.SqlException: OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Power_Avg' . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Da ...Show All

• Rothariger messages stuck in sys.transmission_queue

  Sorry for the stupid question, but I can't seem to figure it out... There are 119 messages that are stuck in the transmission queue, all for the same queue. When I check the status of the queue (via sys.service_queues), is_receive_enabled = 1, is_activation_enabled = 1, and max_readers = 3. When I check to see if there is an active queue monitor (via sys.dm_broker_queue_monitors) there is nobody watching this queue. What would cause this queue to be active, enabled but have nobody montioring it Is there something internal that went wrong that made these (outbound) messages get stuck in the transmission queue, and is not showing up in the views How can I get these messages "un-stuck" and flow through the system A problem I ...Show All

• GoDaddy Apriori algorithm [SQL Server 2005 and ASP.NET]

  Hi I am working on academic project using SQL Server 2005 & Visual studio 2005.  Using Apriori algorithm to find the association between Patient City and likely diseases. I have created PATIENT table with Patient_Id, Patient_name, Age, City attributes and Diseases table with Disease_Id , Disease_name . Connected these two tables, MANY - MANY [M:N]. Got a third relation with Patient_Id and Disease_Id attributes. I am just inputting some dummy  data into patient table and disease tables to make Apriori algorithm work. When a new Patient City is entered into patient table, System checks Patient table for same City previously stored and using Third relation, pulls Disease that associated with the ...Show All

• testorp Full-Text Search

  I am trying to create a full text index on a column in a table and the data type is Image, but the TYPE COLUMN FILE EXTENSION is in another table. there is no way of creating the type in the same table. the wizard will not allow me to pick the data type field from another table. is there a work around this issue Emadkb If you are using SQL 2005, you can make an indexed view and build fulltext index on the view. However that do means you dup the storage for the image columns. Adding a column to the table is not an option Thank you so much....I was wishing there is another solution. emadkb hey Feng Tian I hope you could help me in FullText Search. No one e ...Show All

• PedroCGD SQLAgent2005 not starting

  I installed SQL 2005 successfully but sqlagent is not starting, giving the following error: SQLServerAgent could not be started (reason: Error creating a new session). And in the agent log I see the following error. Message [298] SQLServer Error: 208, Invalid object name 'msdb.dbo.syssessions'. [SQLSTATE 42S02] Can anybody give any ideas how to solve this Thanks... Thank you so much for that post. Thats what fixed my issue this evening. Doesn't work for me. Yes - the agent starts, then it fires up the SQL Server instance, and then the agent terminates with the same error message. Ideas Hello, I had the same problem, my r ...Show All

• alphonso SQL 2005 v9.0.2047 (SP1) - The query processor could not produce a query plan

  Hi Everyone: *Before* I actually call up Microsoft SQL Customer Support Services and ask them, I wanted to ping other people to see if you have ever ran into this exact error "Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services." I would have searched the forums myself, but at this moment in time, search is broken :( If anyone has run into this error before, what conditions would exist that this could happen That is, if I can sniff this out with suggestions from the community, I would be happy to do so. It is an oddity because if I alter a couple subqueries in the where clause [ i.e., where tab.Col = (select val from tab2 wh ...Show All

• MartinHowe Vertical Database Design

  What kind of luck have you guys had with vertical database design I'm working with a front end developer who wishes to use a vertical design for Items and item attributes, as the client appears to have a firm requirement that new attributes can be added at any time. the developer has what I am begining to think of as "magic code" for importing the data into the tables. He's apparently going to write this in .NET, and plans for it to know the data type (varchar, etc.) when importing it - and also allow for the script to dynamically add attributes. THis sounds fun, however, the more stuff we get, the worse the database will perform, I'm thinking - only it will be exponentially slower than a conventional design. In addi ...Show All

• Thegamingchoice WMI Event Watcher - Pointing directly to a machine name

  Hi, I am using a WMI Event Watcher task to watch for files dropped into a directory over a network drive. It seems to work fine when it is pointed to a physical drive name, but not when I use a machine name. I.e. This works - SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"C:\\\\temp\\\\folder1\\\\folder2\\\folder3\"" This fails - SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\ \\\\\\\\machineName \\\\folder1\\\\folder2\\\\folder3\ " The failing code do ...Show All

• Whoisit visibility for a field

  I have a field on a report where on occasion, will display 'PR'. We need to have this field hidden if that is the value of the field. I wrote an expression for visibility like: iif(Fields!ThisName.Value="'PR'", false, true), however it still diplays. Is there something else that I need to do here Thanks for the information Yep, I tried that and then the field is always hidden. I think I did find the problem. The data is being pulled from an AS/400 database through SSIS, but there are trailing spaces. So now I tried this =cstr(Fields!ThisName.Value).TrimEnd="'PR'"; however now I am getting "The hidden expression for the textbox "TTLNAME&qu ...Show All

• pmarreddy Extremely slow Excel MDX

  Using Excel as a client is most of the time exceedingly slow. For example writing a simple query of the type: SELECT [Measures].[Some Measure] ON 0, [Product].[Product-Version].[Product] ON 1 FROM [Cubename] in Management studio is in Excel transformed to: SELECT NON EMPTY HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({[Product].[Product-Version].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS  FROM [Cubename] WHERE ([Measures].[Some Measure]) which takes several times longer to execute. As one starts drilling down it becomes increasingly worse with excel producing MDX that takes 100:s of times longer to execute then if I handwrite the mdx. This is with a very simple cube where Some Measure is no ...Show All

• dczraptor SSAS2000 cube. Number of rows processed is equal to 0

  I created a copy of the cube in the same database. Then substituted fact table with different table that have same structure as old one. New table contains 1000 rows. New cube processes with no errors but number of rows processed is equal to 0. If I browse to the fact table in Cube Editor I can see that the table is not empty. Why cube does not pick up any rows Got it. The subset of data that I had in new fact table had no corresponding entry in one of the dimensions. Thanks Check the log file and get the SQL or while processing cube get the SQL from "Process" window and run that sql in Query Analyzer to check are you getting data ...Show All