Answer Questions

• tibballs How to make a File Share Subscription running on Vista?

  I recently migrate to Vista.   I had a bunch of reports with file share subscriptions that were running fine on XP.   After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager.   As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’.   I thought that this was the signature of a successfully configured subscription.   But surprisingly, there is nothing in the file share. The directory is empty.   Anybody has an idea why   Anybody knows how I could possibly find information on my ...Show All

• SnowyT Errors with combined use of transactional and merge replication - SQL2005

  I am investigating the feasibility of a configuration with 3 databases on SQL2005 DB_A is an OLTP database and serves up transactional publication pub_txn - with updateable subscriptions DB_B is a subscriber database which subscribes to pub_txn DB_B is also a publisher which serves up merge publication pub_merge DB_C is a subscriber database which pulls pub_merge =============================== Updates on DB_A are successfully replicated to DB_B Howvever, when DB_C pulls updates, it doesn't find the update sent to DB_B =============================== Updates on DB_B are successfully replicated to both DB_A and DB_C =============================== Updates on DB_C initially failed with the error Msg 916, L ...Show All

• Buddhist SQL & Passwords

  If it's possible, I'd like to embedd a password in an app that connects to a supporting SQL database. The idea is... the user doesn't use the password... only the app when interfacing with the dB to prevent others from taking the dB for something else. Anyone has a guide The dB is already fully operational. I was thinking about encryption, but I don't want to slow down the dB. I would need to know how to add Password to dB and how to send password from the program. Thanks. It uses Windows...[Database properties: Modify Connections]. I tried SQL Authentication by adding a user and password in the boxes, hoping that the dialog would add it to the dB - but no luck. ...Show All

• Johan Nyvaller Deadlock at trigger

  a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. i trid to change isolation as SERIALIZABLE or REPEATABLE , but i cannot solve the problem. i guess the "while loop" affects the result because i try to cancel the loop and execute smoothly. How to solve the deadlock Thx ----------------------------- i used the following commands to change isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE begin transaction commit transaction ----------------------------- the code are as follows: declare setskuCursor cursor local static for select item, qua ...Show All

• Sean D Wright Can not open SQL Management Studio

  All of a sudden out of the blue today, Sql Server Management Studio refuses to load and open. I'm running Windows XP x64. Sql Server Dev. Edition x64. (Release version.. There were never Beta versions on the machine) When I open the program this dialog opens: --------------------------- Microsoft SQL Server Management Studio --------------------------- Package 'Microsoft SQL Management Studio Package' failed to load. --------------------------- OK --------------------------- (It appears twice and then the UI fails to open) Also, in Visual Studio 2005, when I try to make a database connection in Server Explorer, I get this error --------------------------- Microsoft Visual Studio --------------------------- Cou ...Show All

• Avi Gershon SQL Server 2005 SP 2 December CTP authentication fails

  Hi, if I try to install SP 2 using SQL Server authentification (sa) it fails. The following lines appear in the file "Hotfix.log": 01/03/2007 14:08:23.859 Authenticating user using SAPWD 01/03/2007 14:08:23.875 Validating database connections using Windows Authentication 01/03/2007 14:08:24.171 Pre-script database connection failed - continuing to wait for SQL service to become responsive to connection requests ... repeated 60 times ... 01/03/2007 14:13:33.625 The following exception occurred: SQL Server reagiert nicht vor der Skriptausfuhrung Date: 01/03/2007 14:13:33.609 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\instance.cpp Line: 1411 Why does it try to use Windows Authentification although I have tol ...Show All

• Michael Herman - Parallelspace Question on Microsoft Association Rules

  I build a data mining model to predict what are the best studying methods for the student to pass the examinaton. Create Mining Model StudentAssociation ( Student_No long key, Gender text discrete predict, PassOrFail text discrete predict, StudyMethod table predict ( MethodName text key ) ) Using Microsoft_Association_Rules ( Minimum_Support=0.02, Minimum_Probability=0.03 ) The mining table will contain all the methods that the students use, no matter their examination is passed or failed. The value of PassOrFail will have either 'Pass' or 'Fail'. According to the above model, can I query the best studying methods Or I should only train the model with the student who pass the examination, and ignore all the failed. Tha ...Show All

• narasiman_jayachandran_2b5374 SSRS 2005 and XML Document as Data Source

  I'm new to SSRS 2005, and having a very hard time getting something I thought would be trivial to work. It would appear that if you want to report from XML data, there are a variety of ways to do so. I would just like to use a simple document that was created by serializing to disk. I don't even have a fancy query. Can someone help me with an start-to-end from which I can build upon and add complexity Thanks. C:\XmlData\Customers.xml contains a single Customers table; 3 Customer rows with an ID , FirstName , LastName . (I'll try pasting it as a follow-up). My DataSource type is 'XML' and the ConnectionString is the simplest of URLs "C:\XmlData\Customers.xml". Credentials are set to 'none' . My suspision is that I am not ...Show All

• Davids Learning SQL Create Trigger syntax

  Hi, I have the following SQL and for some reason, I do no know why the keyword "REFERENCING" is not recognized by Microsoft SQL 2005 CREATE TRIGGER CDYearTrigger ON CDs AFTER INSERT REFERENCING NEW ROW AS newData FOR EACH ROW WHEN ( newData . Year IS NULL) ..... (This is not the complete code, but i keep on getting the error ' Incorrect syntax near 'REFERENCING'.') Does this has any SQL syntax or it just doesn't work on Microsoft SQL 2005 (Trial version) That is what I learned from school, and was wondering is there really a keyword call "Referencing" Thanks in advance! that is not a valid keyword in sql server 2005  he ...Show All

• Javfarary Unary Operator. Strange error.

  I have regular dimension, but with unary operator defined for the attribute that is at topmost level in the userdefined hierarchie. If I run a query using a lot of sets in the where statment und the dimension with unary operator isn't mesioned in a query i get a cellset filled with errors #Error File system error: The record ID is incorrect. Physical file: \\ \D:\OLAP_DATA\MW_X_2_0_1.0.db\ArtikelPaket.0.dim\11.Group.Group.ostore . Logical file: . ArtikelPaket is the dimension with the unary operator. An SP1 hotfix will be released soon to fix the problem. The bug happens when a member has more than one children, but only one of which is rolled up to the parent ...Show All

• ackermsb Linked Server Object Listing

  In SQL 2000's Enterprise Manager, upon selecting a linked server the accessible tables and views would be displayed in the right pane. This does not seem to be the case with SQL 2005's Management Studio. I'm seeing this behavior (or lack thereof) with links to a variety of platforms: Sybase ASA, Oracle, and MSS 2000. To rule out a permission problem, I've confirmed the ablity to query sysobjects, ALL_TABLES, etc. Is this a driver or configuration problem, or is this functionality simply absent Try manually issuing select * from sys.servers while running under the same security context you use while in SSMS. You should be able to see rows for any linked server you have a remote or linked login to ...Show All

• nattylife Red X of death

  I receive the Red X of death when I'm working with SQL Server 2005 community edition. Microsoft Money is causing this to happen. Whenever I move my mouse over an entry in Microsoft Money, I get an OutOfMemoryException and then all the windows in SQL Server 2005 community edition get a big red X. SQL Server 2005 community edition at that point is either not usable or it bombs on it's own. I wrote a budgeting application for my family's use and I was using Access with no problems, but then I upgraded. It's important for me to run queries while using Microsoft Money. Anyway, I'm looking for suggestions to keep this from happening. Here are the details. OS: Windows XP with Service Pack II (all patches installed) Microsoft Money 2 ...Show All

• VenkatB Realtime record count for table...

  Here's a little sql 2005 script I wrote: 1. Start by running this script.... declare @x int select @x = 1 while ( @x < 75000) begin insert into myTesttable values (@x) Select @x = @x + 1 end 2. While the script is still running, I want to know how many records are in the table. From the same query window as the script, I have run both of the following statements. select count(*) from mytesttable witn (nolock) select count(*) from mytesttable witn (tablock) Instead of getting the answer immediately, they run only after the original script has completed. They seem to be "blocked". How can I get a near realtime count of the number of records in this table while the script populates the table ...Show All

• careyr PPV's, Loops & Child Packages - Bug or By Design

  It would appear that if a Child package is called more than once from a Parent using the 'Execute Package' task, then after the first execute the Parent Package Variables are not applied to child package. I.E we build dimensions in a master database and these are then loaded to a number of topic specific datamarts. We simply pass Parent variables to the child that hold source & target connection strings, the first time the package is called the correct database is accessed, subsequent Executes ignore the variables and use the original values. Manipulating the (our) event queue to run the package once results in the correct behaviour Are packages cached when they are called from a Parent if so is there a flag that I have missed to fo ...Show All

• Patrick Keller Drill Down with Grouping

  Hello alll I developed a report working fine with 5 levels of drill down. Each level is a group. When I drill down to the lower levels unable to see the column headers. Is there any way to freez the column headers, so user should be able to see what value they are reading ...Show All