Viz, can you let me know how or what your network admin did to fix this problem.

Thank you.

Why do you think log shipping is better than replication. Can you name some third party tools?

Thanks.

Mohammed,

I am trying to design a solution for high availability (HA) and disaster recovery (DR). We have two production database servers and two database servers, each for HA & DR.

Initial...

Steve, how do I clean the cache on the workstation.

1. Can you name some of those utilties to check the channel.

2. How do I check the user is actually able...

XP Pro SP 2

We've tried

1. Logoff and log back in to workstation.

2. Restarted the machine (this worked before, but not working anymore).

This is not through any application (.NET or VBA), he was trying...

Sorry folks, the problem was the SQLServerAgent was disabled.

Thank you John.

Thank you Mohammed, our databases sizes are not that big and they are not high transaction db either.

We have a testing environment (with more than 100 tables) where we want to take backup only certain information from few tables (few hundred rows, from 10 tables).

We do a...

I want to be able to export all data from tables into XML files and import them into the respective tables.

So as an example,

I want to export all the data...

Thanks Farrell for the solution. But is there a way to do this in a single query.

Thanks Gopi Nath.

What would happen if there are begin transactions and commit transactions within the SP that are being called.

The following is pseudo code.

SP1

BEGIN TRANSACTION

    EXEC SP2 {

...

Angus,

Here is an example of what you are looking for.

CREATE TABLE dbo.Category (CategoryName VARCHAR(250), CategoryId AS CHECKSUM(CategoryName))

ALTER TABLE dbo.Category ADD CONSTRAINT

   UK_CategoryName UNIQUE NONCLUSTERED (CategoryName)

INSERT INTO dbo.Category (CategoryName) VALUES('Category 1')

INSERT INTO...

Thank you David.

I think CHECKSUM function should be good enough for what I am looking for.