You can create a trace without using profiler. Take a look at sp_trace_create in Books Online.

Steve Jones - Editor (2/23/2009)

---

I've asked about the a la carte versions of SQL, but I think MS avoids that to prevent a nightmare of support issues. Which features do...

Any possibility of posting the code for the query? That usually helps in these cases.

It sounds to me like what you need is a view with a row_number column, instead of adding a column to the actual table. That way, you can include...

I think it would be nice if you could customize an installation and price. For example, if Standard edition was the baseline and had exactly what it currently has,...

You can't really do that as part of a view. You could do it in a proc with dynamic SQL, but a view doesn't have variable column names.

I actually ran into a business card one day that claimed the owner of the card...

Jack Corbett (2/23/2009)

---

How else would you refer to The Thread? We do not the gender of The...

Is there an ID column in your view? If not, what is that column called?

If you look at The...

Use DateAdd. Like this:

declare @String char(7), @Year char(4), @Day int

select @String = '2009044'

select @Year = left(@String, 4), @Day = right(@String, 3)

select dateadd(day, @Day, '1/1/' + @Year)

You can use seconds...

I'm going to go with explicitly granted permissions, or explicitly denied permissions. That's the best guess I can come up with.

My first thought was "regular login, granted database owner...

Take a look in Books Online (or MSDN) at how the various join types work. You're looking for "Nested Loops Join", "Hash Join" and "Merge Join". Draw a...

I would expect those queries to execute in the same way. SQL is probably going to turn both of them into a nested loops join, which means they'll do...

Judging by these, I'd make feed_num the first column in the index, then err_cd, then symbol. That should satisfy all of the queries you've posted so far. One...