Answer Questions

• Margriet SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), wh ...Show All

• Vladimir Tchalkov MVP Alternate Synchronisation Partners

  Yes, I know synchronisation to alternate partners is deprecated in SQL2005 but.... In SQL2000 there is a Sync Partners tab in the publication properties dialog that allows you tick a checkbox for each co-publisher to be enabled as an alternate synchronisation partner. What is the equivalent in SQL2005 I've set up replication in SQL2000 following these instructions http://support.microsoft.com/ kbid=321176 and it works. Now I'm trying to do ...Show All

• Javier Canones How can I get or set a foreign key's 'on update cascade' or 'on insert cascade' by SQLDMO?

  Hello,everyone!   I have a problem with sqldmo's KEY object,please help me!   When creating a foreign key constraint with 'on update cascade ' or 'on delete no action ' by T-SQL,we can do like this:    ALTER TABLE [dbo].[myForeignTableName] with nocheck     ADD  CONSTRAINT [FK_mykeyname] FOREIGN KEY    ([myForeignColumn])    REFERENCES [dbo].[myPrimaryTableName]  &nb ...Show All

• Hital File System Task Problem

  I'm trying to realize a file system task that rename files from a foreach loop container. So that means the task have a variable in the source connection. This variable got the value (as an expression) of "c:\\.....\\" +@[User::ForeachloopVar ]. But an error message appears when i run it.The message is File System Task: An error occurred with the following error message:  "The given path's format is not supported." When i don’t use th ...Show All

• Metaman ForEach from query

  Hi All I'm sure this is a simple thing to do, but I'm new to SSIS and trying to catch up fast. I want to execute a query on the database which will give me a path and a filespec, say: c:\apps\testapp1 and fred*.csv No problems here. I then want to feed them into a ForEach loop and interate through all the files matching the filespec at that location. I can't figure this out at all. Thanks for you help in advance. FG ...Show All

• Choccie_Mark Schema Ownership

  Hi, I have this user that was given ownership of a couple of schema's and now I want to delete the user but an message appears saying I need to transfer ownership before doing so. The boxes that where ticked in SQL Server won't untick so how do I go about removing ownership of the schema and which user would of had ownership prior, it would have been the inital default user. Anyone...please... Would you care to explain how one u ...Show All

• Cheryl Marland [Transfer SQL Server Objects Task] Error: Table "XXXXXXX" does not exist at the source.

  Does anyone know what could be causing the error on Transfer SQL Server Objects Task   I tried to develope a SSIS project in the Business Intelligence studio to transfer table between databases on the same server.  However, I have been getting the following error: [Transfer SQL Server Objects Task] Error: Table "XXXXXX" does not exist at the source. Is there a setting that I need to change to make this work   Thank you for ...Show All

• Josh Williams x64 Opteron running SQL Server 2005 in 32-bit?

  Hi, I installed SQL Server 2005 Ent. on an x64 AMD Hammer server running Windows 2003 Server Std. x64 ed. When I open SQL Server configuration Manager and view advanced properties of the SQL Server (MSSQLSERVER) then the 'Running under 64 bit OS'-parameter is set to 'No'. When I try to change this to 'Yes' and press OK the system changes the parameter back to 'No' Does this mean that my x64 server is running SQL2k5 server in 32-bit mode Can an ...Show All

• Boman copying data to SQL Server from an Oracle database

  What is the most straightforward way to copy tables and views from an oracle database into a sql server 2005 database thanks for any suggestions. Marilyn Mount your Oracle server and database as a linked database in your SQLServer environment. Then perform a standard insert-select (or select into). If you also must make data transformations you should use DTS (or what's the name nowadays is). Best ...Show All

• Anlino Tx replication works in 2000 but not in 2005?

  Hello, I've got a simple transactional replication set up. I have a separate publisher, distributor, and subscriber with 76 articles (tables only) being pushed from the distributor. I have this exact setup with the same tables and data working in the SQL 2000 environment. I am testing replication on our SQL 2005 test servers before moving to production, however when the distributor attempts to push out the initial snapshot I keep getting ...Show All

• samcneal Yet Another SQL Server Express 2005 April CTP install failure

  I can't get SQL Server Express installed on my Compaq TC1000 Tablet PC. I look at the install log summary and it says: The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.   So I look up the hardware requirements.  I need at least 1024x768 resolution: check.  I need a pointing device: check.  I n ...Show All

• rpesq Is there any built in facility to encrypt a column data in SQLSERVER/MSDE

  Hi Is there any built in facility to encrypt a column data in SQLSERVER/MSDE Thanks Anji Reddy Strong, column-level encryption is possible in SQL 2005. Thanks, Clifford Dibble For a couple of examples, see: http://blogs.msdn.com/lcris/archive/2005/06/09/427523.aspx http://blogs.msdn.com/lcris/archive/2005/06/10/428178.aspx Laurentiu ...Show All

• p818632 SQL Server Alert Notification Systems

  Greetings, SOURCE: http://www.desktopalert.net This is our web-based alert notification service that we are interested in integrating seamlessly with Microsoft’s Notification Server as well as 3rd Party content management systems and ad servers. The differentiating feature in the offering is in its secure Jabber-based instant messaging client/server products and the upwards of 2048 bit security model and optional biometric / ...Show All

• Stevefs Hi Everybody, Sql Server 2005 SE installation problem

  I faced the following problem while installing Sql Server 2005 SE "Error 193 Installing .NET Framework 2.0" while installing Sql Server 2005 Please help me to proceed further You can also try installing .NET Frameworks 2.0 directly by calling \Redist\2.0\dotnetfx.exe. This will give you the full UI installation of .NET Frameworks 2.0 which may have some better error messages. i have the same error.  did you work around it ...Show All

• TimGL How to run DTS package/upgrade in SQL 2005.

  Hi All, I am following instrucation in the following doc to migrate dts package. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp In step 2. Right-click the DTS Packages folder in Solution Explorer and select the Migrate DTS 2000 Package option. This starts the Integration Services Migration Wizard . I don't see "DTS Packages" folder what am I doing wrong. Thank you in advance. Satish Patil ...Show All