SQL Server Databases

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

Data updation issues in a SQL Server table

I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?

Dumping a table in a SQL Server database

How can you dump a table in a SQL Server database and convert the script into text?

Transferring a database and writing a database script in SQL Server 2008

I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?

Acquiring the AdventureWorks database for SQL Server 2005

How can I get the AdventureWorks database for SQL Server 2005 SP1?

Recovery models for SQL Server databases

What are acceptable recovery models for the Master and MSDB databases?

Adding a password to a SQL Server 2005 database

We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

Creating a username and password on a SQL Server database

How we can create a username and password on my SQL Server database?

Importing SQL Server 2005 tables from one server to another

My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?

Deploying SQL Server Express to host databases off a mapped drive

I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area is considerably less open, I can’t...

Script to restore database permissions during a migration to SQL Server 2005

We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

Assigning data distributions to SQL Server 2005 databases

In SQL Server 2005, we have two databases. We want the first one to store tables, and the second one to store views of the tables in the first one. We have achieved this if the tables and views are in the same database, but is there a way to do it with two?

Consolidating SQL Server databases

How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

Moving a database from SQL Server 2000 to SQL Server 2005 and back again

I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

Error message while implementing mirroring between two databases on separate servers

I've attempted to implement mirroring between two databases on separate servers. The database names are exactly the same but I've been receiving the following error: Alter failed for Database 'databasename'. (Microsoft.SQLServer.Smo) An exception occurredwhile executing a Transact-SQL statement or...

Backing up and copying a database across SQL Servers

I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

Obtaining the value of certain columns in a SQL database

I have created the following trigger that inserts data into a SQL table when a specific column is updated. I would also like to obtain the current value of certain columns of the updated row. To do this, I've been using the INSERT command, but I keep receiving NULL values in return. This is the...

Implementing a test system with SQL Server log files

We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...