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.
Answer Question
| April 27, 2009 10:49 AM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server
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.
Answer Question
| April 27, 2009 10:49 AM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server
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 [...]
Answer Question
| April 26, 2009 4:20 PM
ODBC, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, SQL Server Management Studio, Vista, Windows Server 2003, Windows XP
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 [...]
Answer Question
| April 26, 2009 4:20 PM
ODBC, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, SQL Server Management Studio, Vista, Windows Server 2003, Windows XP
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? and if i have to [...]
Answer Question
| April 23, 2009 4:28 PM
Microsoft SharePoint, SharePoint 2007, SQL Server 2005, SQL Server error messages, SQL Server installation, Windows Server 2003
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? and if i have to [...]
Answer Question
| April 23, 2009 4:28 PM
Microsoft SharePoint, SharePoint 2007, SQL Server 2005, SQL Server error messages, SQL Server installation, Windows Server 2003
Loading an XML file’s dataset into an existing SQL Server 2005 table
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?
Answer Question
| April 20, 2009 2:52 PM
SQL Server 2005, SQL Server Dataset, SQL Server tables, XML
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?
Answer Question
| April 20, 2009 2:52 PM
SQL Server 2005, SQL Server Dataset, SQL Server tables, XML
Execute SSIS package in SQL Server 2005
how to execute SSIS package in sql server 2005
Answer Question
| April 15, 2009 11:02 AM
SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS, SSIS Package
how to execute SSIS package in sql server 2005
Answer Question
| April 15, 2009 11:02 AM
SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS, SSIS Package
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 something like this. Can [...]
Answer Question
| April 14, 2009 7:46 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server 2000, 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 something like this. Can [...]
Answer Question
| April 14, 2009 7:46 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server 2000, SQL Server 2005
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?
Answer Question
| April 14, 2009 7:22 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?
Answer Question
| April 14, 2009 7:22 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
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.
Answer Question
| April 13, 2009 12:53 PM
ERP applications, Ramco Test Servers, SQL Server 2005, SQL Server databases
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.
Answer Question
| April 13, 2009 12:53 PM
ERP applications, Ramco Test Servers, SQL Server 2005, SQL Server databases
Drop Database Connections
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)
Answer Question
| April 13, 2009 8:12 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)
Answer Question
| April 13, 2009 8:12 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL
Do all versions of Microsoft SQL Server 2005 support database mirroring?
Do all versions of Microsoft SQL Server 2005 support database mirroring?
Answer Question
| April 8, 2009 5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
Do all versions of Microsoft SQL Server 2005 support database mirroring?
Answer Question
| April 8, 2009 5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
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 [...]
Answer Question
| April 6, 2009 8:02 PM
SQL Server 2005, System performance, Windows Server 2003, Windows Server Performance
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 [...]
Answer Question
| April 6, 2009 8:02 PM
SQL Server 2005, System performance, Windows Server 2003, Windows Server Performance
Renaming a SQL 2005 server
What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.
Answer Question
| September 21, 2011 5:54 PM
SQL 2005, SQL Server 2005
What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.
Answer Question
| September 21, 2011 5:54 PM
SQL 2005, SQL Server 2005
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 then click [...]
Answer Question
| April 4, 2009 5:44 PM
ASP.NET, IIS, IIS Server, SQL Server 2005, VB.NET 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 then click [...]
Answer Question
| April 4, 2009 5:44 PM
ASP.NET, IIS, IIS Server, SQL Server 2005, VB.NET 2005
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 try again [...]
Answer Question
| April 3, 2009 6:38 AM
A name was started with an invalid character, ASP.NET, Extensible Stylesheet Language, IIS, SQL Server 2005, The XML page cannot be displayed, VB.NET, Visual Basic .NET, XML, XSL, XSL style sheet
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 try again [...]
Answer Question
| April 3, 2009 6:38 AM
A name was started with an invalid character, ASP.NET, Extensible Stylesheet Language, IIS, SQL Server 2005, The XML page cannot be displayed, VB.NET, Visual Basic .NET, XML, XSL, XSL style sheet
How to implement an Entity Relationship Diagram into a working database?
I need to implement a ER diagram into a working database. I’m hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement “Is a” relationhips, how to implement has a [...]
Answer Question
| April 3, 2009 12:52 AM
ER diagrams, SQL Server 2005, SQL Server database diagram
I need to implement a ER diagram into a working database. I’m hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement “Is a” relationhips, how to implement has a [...]
Answer Question
| April 3, 2009 12:52 AM
ER diagrams, SQL Server 2005, SQL Server database diagram
Acces rights for all user of an SQL SERVER 2005
Hi all, have you an idea how can i export the list of users and there acces rights of an SQL SERVER 2005; THANK YOU
Answer Question
| April 2, 2009 3:43 PM
SQL Server 2005, SQL Server permissions, SQL Server user permissions
Hi all, have you an idea how can i export the list of users and there acces rights of an SQL SERVER 2005; THANK YOU
Answer Question
| April 2, 2009 3:43 PM
SQL Server 2005, SQL Server permissions, SQL Server user permissions
Backup Performance Compare
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.
Answer Question
| April 7, 2009 4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.
Answer Question
| April 7, 2009 4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance
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. [...]
Answer Question
| March 31, 2009 8:40 AM
AS/400 Text File, OS/400, 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. [...]
Answer Question
| March 31, 2009 8:40 AM
AS/400 Text File, OS/400, SQL Server 2005
How to migrate a database from SQL Server 2000 to SQL Server 2005
Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?
Answer Question
| August 10, 2010 6:22 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration
Can someone explain in detail how to migrate a database from SQL Server 2000 to SQL Server 2005, including which components need to be migrated?
Answer Question
| August 10, 2010 6:22 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration
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 [...]
Answer Question
| March 30, 2009 12:29 PM
HTTP Error 505, SAP PI, SAP PI 7.1, SAP Process Integration, SOAP, SQL Server 2005, Web development, Web services
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 [...]
Answer Question
| March 30, 2009 12:29 PM
HTTP Error 505, SAP PI, SAP PI 7.1, SAP Process Integration, SOAP, SQL Server 2005, Web development, Web services
