SQL Server Databases

Trying to setup a Merge publication between two database Need Help!

HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I am...

Database Views in SQL Server

When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database. Software/Hardware used: SQL Server, windows xp and server 2003

If running two SQL Server db in two VMs, I should purchase two db servers?

If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

How to move SQL Server databases to a new drive.

I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

Issues rebuilding system database on SQL Server Express 2005

I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...

Shrinking a SQL Server database

What is the best way to shrink a database? What are the alternative methods?

Creating an 180,000 record database in SQL Server

I have to create a database for 180,000 records in SQL Server, and each of these records have 5 documents to be attached against them. How can i go about setting this up?

Connecting a SQL Server database with Visual C++ and .NET

How can I connect a SQL Server database with Visual C++ and .NET?

Improving performance on a large SQL Server database

We have a very huge SQL Server database, with approximately 700GB of data. Due to this, queries are running very slow. Could you please suggest few tips to improve performance?

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)

Passing data between two SQL Server databases

Is it possible to have a stored procedure in a SQL Server database look at tables in another SQL Server database by sending the second database name as a parameter to the stored procedure?

Merging the MDF and NDF files of SQL Server databases

How can i merge the MDF and NDF files of SQL Server databases?

Attaching a SQL Server 2005 database to SQL Server 2000

How can i attach a database created in SQL Server 2005 to SQL Server 2000?

Copying our disaster recovery database on a SQL Server

We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don't want to stop it and lose consistency between disaster recovery and the production...

Running a query on both SQL Server and Oracle databases

How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

Shrinking a SQL Server database

My problem is regarding SQL Server 2000. Whenever I try to access SQL Server Enterprise Manager, I am told that the disk is full, along with the tempdb log. I tried to shrink the database, but for some reason I am not able to do so. Can you help me?

Mapping files into SQL Server databases

I have used the split function utility in UNIX to split large files into multiple files of small length. However, the time it takes to map these files into my SQL Server databases has been reduced performance-wise but not tremendously well. To load 50 milion records, it is taking seven hours of...

Error message when finding a database on SQL Server 2008

I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: "The 192.168.0.7" server cannot be...