SQL Server 2005

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?...

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?

Execute SSIS package in SQL Server 2005

how to execute SSIS package in sql server 2005

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...

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?

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.

Drop Database Connections

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

Do all versions of Microsoft SQL Server 2005 support database mirroring?

Do all versions of Microsoft SQL Server 2005 support 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...

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.

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...

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,...

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...

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

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.

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...

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?

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...

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...

Lotus Notes to SQL Server 2005 via linked server

I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB...