SQL Server 2005

SQL Server 64-bit Memory Requirement

We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what...

Migrating data from a SQL Server 2005 database to SQL Server 2000

I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical...

SQL Server 2005 Memory

SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb...Server must be re-started. What could cause this?

Acquiring the AdventureWorks database for SQL Server 2005

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

Using indexes in SQL Server 2005

What is the main purpose of using indexes in SQL Server 2005?

Linked Server Question

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however...

SQL SERVER 2000, 2005 & 2008

Can Sql Server 2000/2005/2008 exist on the same machine

Investigating SQL Server 2005 memory issues

We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates...

Storing large data files in SQL Server

What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

Merge two companies into one network

The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log...

Syncronizing between Distributor and Subscriber in Merge Replication

HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to act...

A Smart Developer

I have been out of touch from VB Programming for a long long time. In front of me is a task and I am ambitious about doing it in a quick & smart way. I work for a small businessman (a shop keeper) who buys Steel wireropes from wholesalers & sells it as a retailer. Currently he has a manual (cash...

Concatenating two note fields into one, but need them to be on their own line

sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

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?

Differences between SQL Server 2005 and SQL Server Express

How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?

sql server 2005 mirroring

i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

Upgrading to SQL Server 2005

I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

How to backup a SQL Server database

Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible... What is our best option?

Running scripts in SQL Server 2005

How can I run scripts in SQL Server 2005?

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?