Use the Row_Number() function, partition by location and row key, to find the duplicates. Then select from one to the next, not including the next duplicate. That should...

Tested:

set nocount on;

go

create table IndexTest1 (

ID int identity primary key,

Val1 int,

Val2 int,

Val3 int);

go

insert into dbo.indextest1...

It is possible to bulk update from Excel.

I don't understand your second question. Do you mean that the server is no longer configured for Windows authentication?

jojovenkat (9/2/2008)

---

Hi Jack

Here I have a question..

I am good at PHP mysql and java basics(not thru web applications/J2EE). I would love to learn ASP.NET and SQL...to develop applications. So where...

So, what you're trying to find is how many in a row have no duplicates? Is that correct?

That should work.

You could possibly use domain security instead. But use whatever works best for you for that.

You can definitely set up Express Edition to run on XP and have people on the same network access it. Has to be XP Pro, not XP Home, but...

Cool. Glad you got it up and running.

I'm afraid I don't understand the relationship between RowID and RowKey. How do you determine the range in which no RowKey can be duplicate?

I don't know if this will be a problem in your case, but the above code will track the gaps as if they were present.

For example, look at the second...

There can be an advantage to this when it comes to writing the indexes. I've read that, when you do this, indexes that are commonly joined together in queries...

When you say that you are connecting using SQL Express, do you mean Management Studio Express? I'm not sure, but I think I remember that having trouble connecting to...

I found this thread using your error message:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=815084&SiteID=1

See if that has what you need. If not, copy the error into a search string and go from there. That's...

In that case, you should be able to uninstall it from Windows Control Panel. You'll want to check around and make sure, first, that nobody is actually using it.

Right-click on SQL Server Agent in Management Studio, select Properties, go to Alert System, and make sure Enable Mail Profile is checked. Also make sure it's got Database Mail...