Steve, can you give an example where using IN Vs OR would be advantageous.

Thanks.

Purrrrfect, thanks Sanjay.

If you have a subscription to MSDN, you may be able to download it through Microsoft's site. Try calling Microsoft, they will be able to offer some solution as well.

-R

Thank you.

This promotion has ended (June 30th, 2007). It's a bummer.

It's a known issue, (although I am using SP2) I am still having this issue.

Found an alternate solution, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=473590&SiteID=1

Bingo, thank you Ninja.

CREATE TABLE dbo.UserActivity (UserActivityId INT NOT NULL IDENTITY(1,1),

UserName VARCHAR(100), LoginTime DATETIME)

INSERT INTO dbo.UserActivity (UserName, LoginTime)

VALUES ('Peter',...

CA XOSoft. They have a product (WANSyncHA SQL) that provides server (DB) wide DR solution.

Found it, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=569664&SiteID=1

I am stuck at the point where web service needs to be created. Can someone show how to create or enable web services?

Thanks.

How do I access that tool?

Found it here,

http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

I found a way to do this through SSMS. Register SQL Server 2000 and select the database, then click Export Data that opens Import and Export Wizard. But there is...

That was a scary moment. I was able to enable sa. The problem happened when I was trying to create a SSIS package that dropped all logins. Can someone point...

Found the cause, the database restore worked fine. There was a replication that was turning the identity property (on 2005) to off. So we basically turned off the replication for...