now that the soap box has been brought out...:hehe:

I would like to see creation and modification information as well as a unique identifier. You may also want to have a...

Ryan,

I like your solution. I am not sure that the different solution has an advantage. It was just my preference. I have been using similar code for years for...

Add a column that creates a unique id per row. Select the minimum value into a table for this new column based on the columns that will make the...

If you want to avoid issues in the future you could ad a primary key field tha is an int and make it an identity field. This will give...

I would like to echo the sentiments of not using "Select *" in code. In addition, If this code is not limited to an intranet, I would reccommend making...

Boris Goldshmit (3/14/2008)

---

Just out of curiosity, what prompted your companies to move up from standard to enterprie edition?

I am trying to convince a major client (3000+ users, very...

I am not sure which version of SQL Server you are using, bu in SQL Server 2000 I created a DTS package and transferred the data over. If I...

Matt Miller (4/29/2008)

---

Q (4/29/2008)

---

When I read the question the first time, I believe I read it as the author intended; however,

Jeff's response made me think about a couple of...

I believe that certifying a product can run in 2005 only in compatability mode is so companies can move forward with upgrades. Some products will not run in 2005...

Just to add confirmation to what has been said earlier.

If SQLSERVER 2000 is installed first Installing SQLSERVER 2005 on the same box has not caused any issues for us as...

When we upgraded from 2000 to 2005 we tested running everything in 2000 compatability mode. We did not see any degredation in performance. I will concede that we do...

When I read the question the first time, I believe I read it as the author intended; however,

Jeff's response made me think about a couple of possibilities.

Possible exceptions.

If...

Jack,

Until you posted the info about sp_MShelpsolumns I hadn't looked at the stored procs, but it looks like with just a couple modifications to the insert statement, you could create...

Jack,

wouldn't this query work in 2000?

select * From syscolumns

where autoval is not null

to get more specific info

select a.name as ColumnName ,b.name as TableName

From syscolumns a

inner join sysobjects b

on...

It is easier for me to use

select * from sys.columns

where is_identity = 1

because I know it works and I have used this query.

If check boxes were used instead...