It's simple...provided you don't skim over the code, miss the 'truncate', see the 'delete' and...

If you create extra partitions in addition to the default partition you can choose to process only selected partitions, for example the partition that holds the latest data. In order...

Using a Witness server as a remote Distributor is not something I've ever tried, but in theory it should work. However, if you lose that server, both your HA strategies...

OK, but that document refers to Subscribers on a separate server. The configuration that you have (if I understand correctly) is that your subscriber is also your mirror, so I...

Try adding it as an attachment then.

Why do you want to do this - mirroring and replicating between the same servers? Is it so that you can run reports against the second database on the Mirror...

To post the error image, save the captured image on your PC and then select the 'img /img ' tags from the IFCode Shortcuts box and enter the location of...

Have a look in the Database Mirroring Monitor at the 'Unsent log', 'Time to send log' 'Time to restore log' values. If they are increasing then your network is struggling...

Be aware that if you have any remote logins set up on the instance, e.g. if you are using replication, the sp_dropserver command will error; you'll need to drop the...

Because the name of your database in numeric, you'll need to wrap it in square brackets:

INSERT INTO Noor.dbo.NTasks SELECT * FROM [706].dbo.GVTDPTASKS

Ok, then you'll want to do something like:

SELECT * INTO databaseB.dbo.table FROM database.dbo.table

assuming that the table in databaseB does not already exist. If it already exists then you can use:

INSERT...

Wilfred van Dijk (8/4/2009)

---

You're starting from the wrong direction. First, specify your requirements (how many databases, type of database, how many users, which features do you need etc) This leads...

Found the answer to my own question while answering someone else's! 😛

The link below confirms that for Windows Server 2008, SQL 2005 is supported at SP2 and above.

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

Far too many points to cover to provide a comprehensive answer. A few questions would be:

1. What version and edition of SQL Server 2005 will you be using?

2. Do you...

Welcome to the forum!

There are a few ways in which you could accomplish this:

1. A job that executes a stored procedure or T-SQL statements to copy/move the data.

2. A custom...