For the events you do capture in profiler, try running them yourself in query analyser and see how fast / slow they are...  Use the default profiler setup - it...

Hmm 9GB - impressive amount of space

Could you post the code of your UDF?  Is it a simple procedure using a lookup table and some division?  For a small app a while ago that worked with...

You'll need to put the UDF in as the result of the case statement rather than the column alias name...

Also know that you can press SHIFT+ENTER rather than ENTER to...

also check to ensure that the SET options are the same for both connections.  Are you using anything fancy like indexed views - they only work (without extra hints to...

Look at the GRANT and DENY transact SQL statements in Books Online.

If you also want to restrict it somewhat from administrators, you can do several things...

a) Create a trigger for...

Your application is using connection pooling, which isn't necessarily a bad thing (is usually good!).

Effectively ADO.NET will keep a connection open to your database for subsequent application "connections" to reuse,...

The first "1" means to start at number 1.  The second "1" means to increment by 1 for each row.  So 2, 4 would give a sequence such as

2,...

Well caught with the UDF hole.  That's the sort of thing you could overlook and wonder why a select statement is returning garbage results.. Thanks!

Good to hear you are on track    Let us know how you get on - am interested to see final solutions and how well...

SQL itself is not designed to output a variable number of columns based on its input.  The idea is that you have a sql statement which will always produce a...

Integrated security is "Windows Authentication" - same thing.

You can run SQL using Windows only authentication, or you can run it in "mixed mode" authentication - in this case, authentication can...

Your old SQL 2000 installation was using a default instance, hence you could just connect with the computer name (GermanShepherd).

But you installed your 2005 as an instance - thus you...

And how do we get the account group?  I don't see it in your table DDL you posted...

Is your ultimate goal to put this into a spreadsheet or do you...

So all DB access is via your library?  From what I can see, giving them the DB won't help anyway because they need to develop against your library, not your...