quote:

---

chrhedga 364

---

Cool. Now what?

--

Chris Hedgate @ Apptus Technologies...

A different approach using NEWID() is shown here (http://www.sql.nu/read.asp?id=4), and it works nice if you have a small table (like with 10 rows).

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Well, not really. SQL Server can't be clustered to share the workload, so partitioning your tables is your best option.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Just noticed that you are using SQL7, and SCOPE_IDENTITY is new for SQL2K. As far as I know, in SQL7 there is no similar function, so you have to rethink...

@@identity returns the latest created identity value in any table, for the current user session. This means that if your procedure inserts a row into table A, and there is...

Probably the forum called 'In the enterprise' would be best for this discussion, but since the thread is already started here, what do you want to ask?

--

Chris Hedgate @ Apptus...

It sounds like there may be a trigger on the table that does an insert in another table, thereby upsetting the identity value. Checked that?

--

Chris Hedgate @ Apptus Technologies (

I think T-SQL will be enough if that's the way you want to go. Look at Oracle, most DBAs are still only using PL/SQL, even though it is possible to...

Fully qualify the table names in the query (that is always a good thing to do):

use mydatabase

go

exec master.dbo.xp_sendmail @recipients = 'myself',

@query='select o.name,o.id,o.xtype,o.parent_obj,o.crdate,u.name createdBy

from yourDB.dbo.sysobjects o join yourDB.dbo.sysusers u ON o.uid=u.uid

where...

One detail in the article that is worth mentioning though is #4d. This range partitioning is a great feature in Oracle, that I would love to see in SQL. Right...

Running XP Pro as well, domain user and no problems changing my password. Just to make sure, you aren't referring to servers running on your own computer and in your...

This article shows a couple of alternative ways to do it:

http://www.sql.nu/read.asp?id=7

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

But we are contractually obligated to not comingle client data -- so views are our only option

---