The default trace captures file growths, iirc.

Here is what would help, based on the sample data you provided what are you expecting to see from the query? Please provide that as a separate table and...

Unless you disabled the default trace, it is already running.

The trace is light weight and does not appreciably affect system performance (or at least in my experience).

Why do you need the user ids to be sequential? You will also get gaps if you delete users from the table as well?

This does not look like SQL. What are you trying to accomplish and how?

julie 75341 (6/2/2013)

---

Hi and thank you again for your reply. Sorry -my fault for not giving more info - you know what its like when you almost tear your...

julie 75341 (6/2/2013)

---

Hi - I have gone back to how I was trying before (similer to your recommendation) and only got even more errors 🙁

I am not having much...

Now a question for kiran.vaichalkar, what is it you think that IDENTITY_INSERT does?

Without seeing what you see, can't really tell you. What I can say is that rebuilding indexes does not eliminate fragmentation, it reduces it.

Mirroring is done at the database level in SQL Server. This should have no affect on other services that are also running on the server.

Yea! I got one right today.

IIRC, DBCC CHECKDB is not run automatically by SQL Server. If you need this run you need to do it manually or using a scheduled process.

I ran this:

select

soundex('Kelly'),

soundex('Bentom'),

soundex('Kelly'),

soundex('Benton')

And got this:

K400B535K400B535

Looks to me that your code is working.

What version of SQL Server are you using? Are just getting nothing in return or are there any error messages.

Sorry, got it backwards. Long day already.

Feel dumb for not asking for the backup command being run.