Answer Questions

• _cham Merge Replication Using RMO

  i have done web synchronisation using RMO, where replication is happening on both ends, i want to perform one way synchronisation where a sales guy wants to update only his details to the server , and not to update the data from the server, can anybody help me on this task , the code for synchronisation i have taken out from msdn for Merge Replication using RMO programming .. Thanks http://blog.csdn.net/longrujun/arch ...Show All

• Peter Chr. Ryskin SSIS setup for team work

  I would like to setup SSIS project so that multiple developers can work on same project. I am having issues with protectionlevel properties while another developer opens the package created by other developer. Can anyone guide me on setting up project so that multiple developers could open the package and run (not simaltaneously though). Also tips on setting up source safe or team foundation will be appreciated! Thanks Mahesh Use ...Show All

• Guruper Can't connect to data source

  I've got a report (2005) that is sourcing from an AS2000 cube. Everything works fine in the BI Dev Studio, it builds and deploys without a hitch. The report has a shared data source and is using a generic login (i.e. it's not set to my NT login). However, when I navigate to the Report Server and try to run the report, I get the following error message... Cannot create a connection to data source On the Report Server, I'm using the sa ...Show All

• samsonknight messages aren't getting through after backup / restore on a different server...

  after restoring a database and regenerating keys, I'm trying to queue messages, and they're all hanging out in sys.transmission_queue with the following message: An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. I can't find any documentat ...Show All

• Giedrius Banaitis yukon's transactional replication

  Hi yukon gurus, Does yukon transactional replication supports immediate update on subscriber with text, image and binary data types tnx and regards, ArisenX y Although it's not documented clearly anywhere, yes it's supported provide publisher/distributor is SP4 or higher. tnx, my present setup is transactional replication with immediate update(push) subscription, will this be ok if my pub ...Show All

• skmichi Error: Server Agent cant find dts file

  Im trying to schedule an integration sevice package with no anvile. I have tried both running it in Agent under Integration services and operation system (CmdExec) and still wont work. Under CmdExec, the command is /FILE "C:\Documents and Settings\ebuah\My Documents\Visual Studio 2005\Projects\Swamp_Solution\FIRSTTIME_DOWNLOAD\SSIS_ACT.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF. In the advance tab, I checked outfile to a ...Show All

• Armin Prosch How can I connect to Microsoft SQL Server 2005 CTP with Microsoft SQL Server 2005 Express Manager?

  I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally but when I connect to Microsoft SQL Server 2005 CTP, I failed! when I open SQL Configuration Manager, I find the SQL Server had been running, after I opened "Attribute" window, I find "This account" box had been checked, and "NT AUTHORITY\NETWORK SERVICE" was displayed in Account Name edit box, "**********" was displayed in "Password" edit box. I think that t ...Show All

• VegasDave transfering data from as400 to sql server

  Hi, I am receiving an error when trying to download some tables from the AS400 to SQL Server. The error is An OLE DB error has occured. Error code 0x80040E37 An OLE DB record is available Source "IBMDA400 Rowset" Hresult 0x8004005 Description CPF9812 File TXX in library MNTPFT not found However I can download any other files from the library MNTPFT except for the ones that contain TXX. I also can get that file manually from th ...Show All

• tez_uk SQL Server default file directory and authentication mode

  How do you find/set the default file path for newly created databases How do you use T-SQL to find and/or set the authentication type of a SQL Server  There is no easy way to find these type of settings from with TSQL since they are stored in the registry. SMO Settings class exposes these but then you have to do it from the client-side. Anyway,  I blogged about solving this problem last week using SQLCLR TVF. You can find ...Show All

• merwinp Object reference not set to an instance of an object

  I enter http://localhost/reportserver and get the error message from Reporting Services:: "Object reference not set to an instance of an object" along with a link to Get Online Help. I click the link to get the "Details" and am told "We're sorry, there is no additional information in the error logs or knowledge base. I've run the RS Configuration Manager many times to try different options, I've also run SQL Server Co ...Show All

• jyabc168 Pictures not displaying

  I tried to search for this but couldnt get a satisfactory solution.. We have pictures stored in a table as BLOB files. When I try to display them through RS it just shows 'X' in that field... Any help is appreciated.. You need to set the MIME type to JPG: "image/jpeg" If you know these are all JPGs then you can hardcode, if you store the MIME type as a field in the database, then you can ...Show All

• amontania Issue Loading Data from Flat File

  I have come across a strange bug that I can't get to the bottom of. I have a source Excel spreadsheet with approx 30000 rows in it, I have saved this out using Excel 2003 as a csv file which contains all of the source rows. Using a Flat File Source I am only getting approx 15000 rows through, I have re-saved the spreadsheet as csv and it stops at exactly the same point.  However, if I use the excel spreadsheet as the source I get ...Show All

• JBG sp_changedbowner bug?

  in studio sqlserver 2005 beta 2 press button new query, use adventureworks entry text: sp_changedbowner 'sa' press execute - result ok entry text: create procedure anyproc .... go  sp_changedbowner 'sa' script  ending  only if press stop button entry text: sp_changedbowner 'sa' script  ending  only if press stop button   I am unable to repro this on build 1307. ...Show All

• NickBuck Load a SSIS package via Web Service: The package failed to load due to error 0xC0011008 "Error loading from XML.WHAT IS THAT?

  Hello, I have a big problem and i'm not able to find any hint on the Network. I have a window2000 pc, VS2005,II5 and SQLServer 2005(dev edition) I created an SSIS Package (query to DB and the result is loaded into an Excel file) that works fine. I imported the dtsx file inside my "Stored Packages". I would like to load and run the package programmatically on a Remote Scenario using the web services. I created a soluti ...Show All

• Shiloy SQL select events entered between 9am and 5pm on the same day

  Hello, I am trying to select appointments that were entered in a database table between 9am and 5pm. CREATE TABLE [Appointment] (  [appId] [int] IDENTITY (1, 1) NOT NULL ,  [appDate] [datetime] NOT NULL ,  [patientId] [int] NOT NULL ,  [practiceNum] [varchar] (50)  ... below is the psuedocode of what i would like to do select patientID and appDate from Appointment where appDate lies between 9am and 5pm of the current da ...Show All