I don't have a clue. Would the ANTS Profiler from Red Gate work?

If just the tools supplied by SQL Server, sp_depends or sys.sql_dependencies, are not enough, you migh also want to consider looking at Red Gate's SQL Dependency Tracker

In order to really provide an answer, a lot more detail would be needed regarding what the data structure looks like. It could be something as simple as providing an...

Great. Thanks for the reply.

I should have looked at the INSERT statement. Missed it. That explains things nicely.

How about something like this? It doesn't provide for a zero based sequence number, but it does put the numbers in the correct order. Indexing could be an issue to....

The only way to do it is to build it out completely, but I have to agree, are you sure you need a cursor?

Here's an example, ugly though it...

rose_red1947 (11/14/2007)

---

Hi

I have two fields, first field is with identity values like

1,A

2,B

3,C

4,D

5,E

6,F

7,G

8,H

9,I

10,J

I need to delete values 3,C and 7,G after this i want to rearrange identity values to get...

Those are settings that the tool the user is accessing the database from must set. They are controlled per connection.

What do you mean by "data created at the database level"?

Do you mean, is it more or less performant to create a GUID or some other type of primary key...

Megha Yadav (11/15/2007)

---

Yes I do understand the importance of the foreign keys for maintaining the integrity ................but what the question is that if the system is working without it why...

SQL Noob (11/14/2007)

---

zip codes are one thing, but a lot of times you have varchar data where a sales person fills it out and just puts in the wrong data...

SQL Noob (11/14/2007)

---

there are no good and bad or black or white in SQL, only gray areas and what is good for your situation

we have very few FK's where i...

Personally, I'd say yes, add the constraints.

Everything Michael Earl said is true. You can simply rely on the fact that the application has the integrity covered. However, as a DBA,...

Well, let's say you have 30 different fields, all customizable by the user. This particular user only uses 5 of the fields, the other 25 lie fallow. When you insert...

Congratulations. Wonderful achievement.