Multiple databases on a server – SQL
My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards
Answer Question
| February 15, 2010 5:23 AM
PostgreSQL, SQL, SQL Database, SQL Server databases
My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards
Answer Question
| February 15, 2010 5:23 AM
PostgreSQL, SQL, SQL Database, SQL Server databases
hardware requirement for sql 2005.
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
Answer Question
| November 25, 2009 12:20 PM
SQL Server 2005, SQL Server databases, Windows Server 2003
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
Answer Question
| November 25, 2009 12:20 PM
SQL Server 2005, SQL Server databases, Windows Server 2003
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 [...]
Answer Question
| October 13, 2009 9:39 AM
SQL Server 2005, SQL Server databases, Windows Server 2003
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 [...]
Answer Question
| October 13, 2009 9:39 AM
SQL Server 2005, SQL Server databases, Windows Server 2003
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.
Answer Question
| January 17, 2012 10:56 PM
Database Expert, SQL Server databases, Windows Server 2003, Windows XP
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.
Answer Question
| January 17, 2012 10:56 PM
Database Expert, SQL Server databases, Windows Server 2003, Windows XP
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.
Answer Question
| September 18, 2009 12:36 PM
Microsoft virtualization, SQL Server databases, Virtual Machines
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.
Answer Question
| September 18, 2009 12:36 PM
Microsoft virtualization, SQL Server databases, Virtual Machines
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.
Answer Question
| July 9, 2009 4:20 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, 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.
Answer Question
| July 9, 2009 4:20 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases
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 backup). So now [...]
Answer Question
| July 7, 2009 2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, 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 backup). So now [...]
Answer Question
| July 7, 2009 2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005
Shrinking a SQL Server database
What is the best way to shrink a database? What are the alternative methods?
Answer Question
| July 6, 2009 4:57 PM
SQL Server database, SQL Server Database Consolidation, SQL Server databases
What is the best way to shrink a database? What are the alternative methods?
Answer Question
| July 6, 2009 4:57 PM
SQL Server database, SQL Server Database Consolidation, SQL Server databases
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?
Answer Question
| April 26, 2009 6:28 PM
SQL Server, 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?
Answer Question
| April 26, 2009 6:28 PM
SQL Server, SQL Server databases
Connecting a SQL Server database with Visual C++ and .NET
How can I connect a SQL Server database with Visual C++ and .NET?
Answer Question
| August 12, 2009 2:48 PM
.NET, SQL Server, SQL Server databases, Visual C++
How can I connect a SQL Server database with Visual C++ and .NET?
Answer Question
| August 12, 2009 2:48 PM
.NET, SQL Server, SQL Server databases, Visual C++
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?
Answer Question
| April 26, 2009 2:46 PM
SQL Server, SQL Server databases, SQL Server performance, SQL Server Query
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?
Answer Question
| April 26, 2009 2:46 PM
SQL Server, SQL Server databases, SQL Server performance, SQL Server Query
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
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?
Answer Question
| November 12, 2009 4:48 PM
SQL Server databases, SQL Server stored procedures
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?
Answer Question
| November 12, 2009 4:48 PM
SQL Server databases, SQL Server stored procedures
Merging the MDF and NDF files of SQL Server databases
How can i merge the MDF and NDF files of SQL Server databases?
Answer Question
| March 28, 2012 6:25 PM
MDF, Merging MDF and NDF, NDF, SQL Server databases
How can i merge the MDF and NDF files of SQL Server databases?
Answer Question
| March 28, 2012 6:25 PM
MDF, Merging MDF and NDF, NDF, 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?
Answer Question
| March 16, 2009 5:25 PM
SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
How can i attach a database created in SQL Server 2005 to SQL Server 2000?
Answer Question
| March 16, 2009 5:25 PM
SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
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 copy. How can we [...]
Answer Question
| March 6, 2009 4:56 PM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases
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 copy. How can we [...]
Answer Question
| March 6, 2009 4:56 PM
Disaster Recovery, Disaster recovery (DR) testing, Disaster Recovery Database, Disaster recovery planning, Log Shipping, SQL Server, SQL Server databases
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?
Answer Question
| March 3, 2009 7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query
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?
Answer Question
| March 3, 2009 7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query
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?
Answer Question
| February 25, 2009 8:48 PM
SQL Server 2000, SQL Server Database Shrinking, SQL Server databases, SQL Server Enterprise Manager
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?
Answer Question
| February 25, 2009 8:48 PM
SQL Server 2000, SQL Server Database Shrinking, SQL Server databases, SQL Server Enterprise Manager
