Answer Questions

• jdaddy18 Help on replication from SQL 2005 to DB2/AS400

  I was trying to set up a replication process to move data from SQL 2005 to DB2/AS400. To get it started, I have create a simplest table (say, PERSON) on SQL 2005 server, and the same table (PERSON) on DB2/AS400. I have only one column SSN (of type int). I have journaled the table on DB2 end. I was able to have successfully configured publisher (on SQL 2005) and subscriber (i.e. a pushed subscription). I used transactional replication. And I ...Show All

• Janaka how to setup LOCKS in ATL OELDB Consumer?

  in sql server, we can use TABLOCK to lock a table, but how can i do this in ATL, without using a SP i worry if two user perform db.Update() at the same time and refer to the same row, there may cause a problem. i fond this line in the OLEDB ref. Locking can occur with any of the methods that interact with rows on the data source. These include IRowsetLocate::GetRowsAt , IRowsetLocate::GetRowsByBookmark , IRowsetUpdate::Update , and othe ...Show All

• Red Maple FTP Task caching

  Is there a way to manage the cache when a file is being FTP'd from a server It writes the file to the d: drive but caches it to c: first. Can I add a command line switch to tell it not to cache the file first Thx Sorry, but I didn't implement it. I'm trying to help someone who implemented the task and now can't get it to stop filling up the system drive with cached TIFs. ...Show All

• zippy1981 List Property - can grow/can shrink

  I'm trying to generate a report that will simulate Avery Standard form 5388 - a basic 3 x 5 index card. I'm using a list and a table to generate the output. Basically I have the list sized at exactly 3 x 5. I'm limiting my rows to be returned to 5 rows so that the table does not grow too large, and I'm using the Page Header to handle the top space, and have placed the list/table regions within the body region to handle the left margin. The ...Show All

• Jongo SSRS 2005 XML datasource & report subscription question

  I'm working to enable subscriptions on some reports that have an active directory web service as a datasource as well as a standard datasource to a SQL server db. I'm admittedly new to reporting services '05, but some research tells me I can't do the job with the current configuration. As the AD web service is an XML datasource, I'm not sure if I can pass an expression...and the reporting service manager won't let me store the credentials on ...Show All

• Atilla Koklu Class does not support aggregation

  Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) Program Location:    at Microsoft.SqlServer.Management.UI.VSIntegration.ISqlToolsVSHlpFactory.CreateHierarchyWrapper(Guid& clsidInnerHier)    at Microsoft.SqlServer.Management.UI.VSIntegration.SqlWorkbenchHierarchy.CreateHierarchyWrapper(Type typeToW ...Show All

• BillyD Proper Method 4 modifying XML data column in CLR (.Net 2.0)

  Hello, I have been doing some proof of concept scenarious where, I use XML column field to store untyped but well formerd XML (i.e. I do not bind to a schema). I am using XmlDocument to load the data from the table and access nodes and make some alterations. My code looks like this: xmlRecord = new XmlDocument( ); xmlRecord.LoadXml(aRow["XMLData"].ToString()); strTemp = xmlRecord.SelectSingleNode("/adf/pros ...Show All

• rosebud75 performance issue with trans log on tempdb?

  I am running in to a tricky issue, and am hoping someone here has seen something like this before. Here's the basic sequence I am working with. A temp table #A contains some number of rows (in this case, about 45k rows). 1. Create temp table #B and insert a subset of the rows in #A (in this case, the subset happens to be 100% of #A) 2. Perform a few dozen updates to #B, using data from permanent tables. 3. Update the rows in #A with #B, ...Show All

• Arrgh Source and Destination table equality

  I have searched the SSIS forum for an answer to my question, and I think I have found my answer but what i have read does not come out directly and answer my question. I am attempting to create an SSIS package that imports data from a Visual Foxpro table into a SQL Server table. From what I have read, the source and destination tables must match column for column. Is this correct My SQL Server table has a few more columns in it. However, i c ...Show All

• Steve Meister Modify SSIS Package

  I have created an SSIS export package by right-clicking on a database, choosing 'Export Data', specifying all settings using the wizard, and choosing to Save the SSIS Package, with the SQL Server option checked. I now want to run the package, and schedule it to run on a regular (daily) basis. The problem I am having is that I can't find the SSIS Package anywhere! I have looked in Microsoft SQL Management Studio, at virtually every element in th ...Show All

• Jason Hayes RS 2005 - Evaluation Version

  Our RS 2005 - Evaluation Version has expired  .... does anyone know if it is possible to copy existing RS reports from an evaluation server to another server How is this done Thanks. RS 2005 is already installed on the new server.   You can use the reporting services configuration tool to configure the new report server to use the existing report server database. Connect the configuration tool to the report server, then u ...Show All

• rignack Also for Sql server 2000

  i get this error when i wanna install sql server 2000 http://img287.imageshack.us/my.php image=error4pt.png Hi there, sure, just save in the title bar of the screenshot that you tried to install the Enterprise Eval Edition on your computer. If you want to use the SQL 2000 on client computer you have to use the MSDE (like the below poster told) or you get the developer edition which exposes the same featu ...Show All

• mjt SQL Server 2005 Management Studio can't be found

  Sorry if someone already covered this, but I can't find anything about it. I just installed (3 hours ago actually) SQL2005 Standard Edition (from the Launch event) on my machine, and i don't seem to have a shortcut to the SQL Server 2005 Management Studio anywhere. I looked for a likely executable, but couldn't find it anywhere.  This wouldn't bother me as much if I could use Enterprise Manager from 2K, but SQL2005 will not allow it t ...Show All

• Boggles2626 Microsoft.SqlServer.Management.Smo Backup and Restore classes

  Hi, Hopefully someone out there will be able to help me with this question. I'm trying to setup my C# program to use the Backup and Restore classes to perform backups and restores on an SQL Express 2005 database. From the documentation I've read... it seems that when you go to restore the database, it's a good idea to backup the current transaction log. But when I do this using the Backup.SqlBackup method I get an error saying that no data ...Show All

• Ravi Teja SQL Server 2005 Programming

  This may be a stupid question but i'll ask anyway. Can you create applications that use the ReportViewer component of SQL Server 2005 Reporting Services in a Visual Studio .NET 2003 project No. The ReportViewer component as well as the VS report controls shipping in VS 2005, require the .NET 2.0 Framework. -- Robert ...Show All