• SAP SQL database cluster

    Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when the...

    Sabi1330 pointsBadges:
  • Import AS/400 files into SQL server

    Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)

    Yenyen5 pointsBadges:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • Linked SQLServer

    Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

    Db23290 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • sql2005 with share point 2007

    I installed sql server2005 and sharpoint 2007 for two times in two seprate windows server2003 but i give same error when i want to start share point : failed to start the database service MSSQL$Officeservers.repair this product by selecting it from the add/remove programs menu. now how can i do?...

    4425195915 pointsBadges:
  • Execute SSIS package in SQL Server 2005

    how to execute SSIS package in sql server 2005

    Sangeeth30 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000?

    Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a query tool for SQL Server 2000 and SQL Server 2005

    Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Drop Database Connections

    Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

    Javad5 pointsBadges:
  • How to create new ramco test server?

    Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

    Amitshukla60 pointsBadges:
  • Running queries causing system to hang

    A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The machine is...

    WindowsServerATE335 pointsBadges:
  • Error running an ASP.NET application in SQL Server 2005

    I have SQL Server 2005, version 9.0, installed on my system with VB.NET 2005 and IIS server running. When i tried to run an application created in ASP.NET, it showed me the following error: The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • The XML page cannot be displayed

    I am using sql server 2005 with vb.net 2005 and IIS server installed. I tried to run the application created in Asp.net,but it showed me the following error. The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or...

    Sajad5 pointsBadges:
  • Create text file to OS400 folder by using Microsoft SQL Server 2005

    Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to...

    Sql200920 pointsBadges:
  • HTTP 505 calling SQL Server Web service from SAP PI 7.1 SOAP Adapter

    Hi, I have a SAP PI 71. scenario where I need to call a Web Service exposed by an SQL Server 2005 app running on widows 2003. The SOAP adapter call fails with an HTTP 505 indicating mismatched HTTP versions. it appear that sap is speaking 1.0 and sql server is speaking 1.1. Do you know of any way...

    Ziglmorf5 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • SQL Server Linked Server Security Context

    Hey everyone, I'm working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use...

    Lvance16115 pointsBadges:
  • SQL Server 2008 extended stored procedures

    I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP's from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the DLL is not there is...

    KH155 pointsBadges:
  • SQL Server 2005 – Analysis Services can’t Right click and create new Data Source

    In SQL Server 2005, under the analysis server, we cannot right click on Data Sources and choose "new Data source". Only Reports and Refresh are available.

    Swish19765 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following