I'd say one generic 'code' data type is a good idea. I don't use udt's often, but lately Im doing more maintenance work than new design so maybe that's why!...

I use uniqueidentifiers to avoid the server trip, easy to generate on the client or middle tier, guaranteed unique.

Andy

Not sure that UDF would really help you, at best would just clean up the statement a little. Not sure how you could compress it all into one value, other...

You want to use column.dridefault.text. It doesn't work correctly without the ".text" portion. This is a default that you would enter in EM in the designer - I tested by...

It works, did you include the .text portion? As far as the defaults, its the difference in how you create them - one is part of the table definition kinda...

So you have 96 columns? Could you post DDL for the table and maybe a couple inserts with sample data, plus a sample of the calculation you're trying to do?

Andy

Have you set a specific lock time out value for QA? Check under Tools|Options.

Andy

Take a look at sysproperties. Just run a query something like this:

select name, value from sysproperties where object_name(id)='categories' and name='ms_description'

Categories is a table name in this case, from Pubs.

Andy

Easy enough to handle. If you have SQL2K then you can use DTS to move the logins. Even without DTS you can bcp the data from/to sysxlogins in master, or...

Not that I can find. You can always retrieve it using ADO, either by doing select name, value from sysproperties where object_name(id)='categories' and name='ms_description' or you can look at using...

Try objCol.DRIDefault.Text.

Andy

Might want to find an Oracle site. Some of our readers use both, but for the most part SQL Server is our focus here.

Andy

Pretty quick I think. You can run into problems if the files you're trying to use are from the CD...are read only.

Andy

Check your statistics, maybe rebuild them?

Andy

One way would be create your own function, maybe something like this:

Public Function NoDecimal(DataIn As String) As String

Dim J As Integer

Dim x As Integer

'default

x = 1

For J = 1 To...