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...
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? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.
Microsoft virtualization, Virtual Machines, SQL Server databases
I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.
SQL Server Database Migration, SQL Server databases, SQL Server 2000
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...
SQL Server Express 2005, SQL Server databases, SQL Server database
What is the best way to shrink a database? What are the alternative methods?
SQL Server Database Consolidation, SQL Server database, SQL Server databases
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?
How can I connect a SQL Server database with Visual C++ and .NET?
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?
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?
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.
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)
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?
How can i merge the MDF and NDF files of SQL Server databases?
How can i attach a database created in SQL Server 2005 to SQL Server 2000?
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...
SQL Server, SQL Server databases, Disaster recovery (DR) testing
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?
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?
SQL Server databases, SQL Server Enterprise Manager, SQL Server 2000
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...
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...
SQL Server 2008, Small Business Server, SQL Server databases


