Just a hunch, but what if you created the function in MSDB system database?    Might be handy alternative, so that any database could...

Your problem is your SELECT syntax in the nested query.  Your syntax is trying to assign multiple variables (FileNumber, ClientNumber, Client, etc), which you cannot do in a subquery.  I...

Jeff; I have to disagree.  It is usually a very good thing to do, storing image/report/binary data with the SQL data. 

• It is more consistent, as the binary data is...

Assuming the question is about which style of JOIN to use, you should be using the ANSI92 standard of {INNER | {LEFT | RIGHT | CROSS} OUTER } JOIN  ...

I hoped that putting a "GO" after each statement would make it commit...

I thought you might have, but was not sure if that would be the difference.  I...

I can work around this by creating the temporary table before the IF statement and doing INSERT INTO #Tmp1 instead

It is not a workaround, it would be the preferred...

Yes, deny privileges will override whatever other rights you have granted.

I assume you are using Windows authentication for users to connect to the database, and you are using a domain. ...

Trying to be respectful, but No, it was not done.  Or at least it was not done correctly.

Your error message indicates the Windows user account does not have permission to...

Dominic:

It appears that you are not familiar with some of the basics in web development.  From you reference to "products.asp", I assume you will developing "classic ASP" website, not .Net...

Neither OSQL nor Query Analyzer use ODBC, they use the native SQL Library. (Yes, the SQL Server ODBC library also uses the native SQL library, but the difference is that...

Here is a function I wrote that would handle the same type of structure to whatever level you have.  The WHILE loop continues as long as new properties (users) are...

While a few of the things you will want are available in SQL Server itself (e.g. active connections, database sizes), most of what you will want are provided by SQL...

...I meant that XML column is stored the same way as TEXT column and that takes 16 bytes for empty values...

I do not think this is true anymore.  I believe...

In theory the above INSERT statement should throw a foreign constraint error...

I thought so, too.  I guess this is an interesting application of the UNION ALL statement.  It seems...

You might want to also consider a "hybrid" design.  Build your tables with all the attributes (elements) that you know and understand now. Then provide an extra column of datatype XML...