Answer Questions
oysts Transactional Replicating hanging SQL Server 2005
Hi, It appears that every 5 or so days, my transactional replication is hanging. I see that I have a couple thousand undistributed commands and this number keeps growing. It forces me to generate a snapshot in order to sync up. When generating the snapshot, I will get frequent messages like "waiting for a response from server...". So I will keep stopping and starting syncronization. Eventually the snapshot will g ...Show All
JeevesIndia Is Installing SQL05dev and VS05pro on the same machine supported?
Hello, When SQL05dev is installed a SQL05 version of Visual Studio (SQL05-VS) is also installed (called the “SQL Server Business Intelligence Development Studio”). The SQL05-VS installs files into a “C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE” directory (and other directories - not described here). When the full version VS05pro is installed it installs/uses fi ...Show All
yanyee XML Source - Generated XSD or XML Problem?
Trouble with using the XML Source Adapter and generated XSD. The XML source is from a file. The XML file that, due to its origin I can not modify, has the following on each line (I've formatted it for readability): < xml version="1.0" encoding="UTF-8" > <Merge ActionType="M"> <OldID>23677451</OldID> <NewID>25116562</NewID> </Merge> They are messages from a que ...Show All
salama2 Upgrade from CTP15 to RTM
Is upgrading from CTP15 to Yukon RTM supported Specifically, we have a large number of data mining models which take a long time to build, and don't want to have to rebuild them all. thanks, Jesse Unfortunately there is no upgrade facility between CTPs and RTM. You will have to rebuild them (which is a good practice going to RTM code for any product an ...Show All
Bill Calkins OPENXML Syntax... How to use...nested reading of elements
I have a XML file with following structure and I want to extract all information of ITEMBOM for a particular Item and put into single table.I'm not sure to use openXML for nested data retrieval from elements. Any Idea ......... <lines> <line> <items> <item name=a> <ITEMBOM> <ITEMBOM> <ITEMBOM> &l ...Show All
C#2006 CLR Enabled
Can anyone tell me what this means and how to fix it I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error.... Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option I changed the 'clr enabled' property to 1 using sp_configure but I still get this error. Thanks Mike Thank you again Gorm! sp_c ...Show All
POSKOK Load Balance Clustering on 2005?
My company is planning on using a datacenter for our customers. These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server) If we move to a centralized database model we may need Load Balancing. I read that SQL 2005 will accommodate this so I called MS Support and no one could confirm this. My dilemma is that I need to report upon what our options are for the datacenter. ...Show All
Rakesh Kashnia Has anyone used Security Filters?
Dear Anyone, Has anyone here have ever actually used the Security Filters of a report model Can you please direct us to some more articles or maybe samples of the subject. The ones that are in Books Online are somewhat limited and does not have any samples. Thanks, Joseph FYI: there is a known bug in security filters which will be fixed in Yukon SP1. Your the man BOB!!! I think Security Filters would be the sub ...Show All
Tebby filtering rows that already exist in the destination table
Hi All, What is the most straighforward way of not importing rows that already exist in the destination table (as determined by a primary key value) Thanks. Regards, Daniel Method 2 here: http://www.sqlis.com/default.aspx 311 -Jamie Excellent, thanks. ...Show All
Christian Nordbakk Error 29503 - SQL Server 2005 DB Engine install Fails
Hi, I've just tried to install SQL Server 2005 Standard and I'm getting an error that I can't find any information on. In the log, I find Error 29503. A message after it indicates that it couldn't start the server. In the setup, I'm getting the error when it is trying to start SQL Server and it can't. I've tried to go to the services window to manually start the engine, but immediately after it starts, it shutsdown ...Show All
AdaByron Error at deployment time (SSAS 2005)
Hello all, May be somebody know what does this error mean: "Error 1 Exception of type 'System.OutOfMemoryException' was thrown. 0 0" I get it during deployment of cube after small changes I made in cube role. When I deleted the role to return project to prviouse condition which was working, I still get the same error. If anybody has any idea - it would be very appreciated. Thanks Inna Hello Inna Coul ...Show All
Diacono_Frost how do i use a secure non-windows smtp server with ssis?
my package requires a send mail task and i must use a secure non-windows smtp server. can someone please tell me how to configure the smtp connection manager so i can do this thanks. EricMadariaga wrote: I don't think that you can do that with the SMTP connection manager, that's what i was afraid of. microsoft should update the smtp connection manager to do this in the next service pack. however you should be able to w ...Show All
Die LTs Problem installing SQL Server 2005 express, In windows 2000
I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest. The error log is as shown: Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006 Process ID : 1008 e:\469a4a9ba4bfdc9d2db501289fb676\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/4/5 21:34:50 Complete: ...Show All
BarnDisplay Order by clause in View Definition when Select top 100 percent is used SQL Server 2005
I am getting errors such as ..."invalid column name 'Name'" and "Msg 4104, Level 16, State 1, Procedure vw_MWOrderValues, Line 3 The multi-part identifier "dbo.Orders.OrderID" could not be bound." when trying to use an Order by clause in View Definitions. (The second error happened when trying to subscribe to the view) See examples below. These were created in SQL Server 2000 and they work by usi ...Show All
A C&#35; fan Transfer Database Task Validation
when i am defining a transfer task. i am move DB from a 2000 SQL server to my 2005 sql server. it will not vaildate the LDF and MDF files on the 2000 server.. i am a administrator on the box. i think i have something configed wrong .. help !!! ...Show All