If you subscribe to SQL Server Magazine, they have very interesting puzzles almost every month by author Itzik Ben Gun. I like them, I could solve just few of them.

Thanks, Goerge.

This is exacltly what I want. It worked perfevtly.

Yes I tried GSquared suggestion. Post #512562 .

It does not matter. I changed it to one select statement but result is the same, Catch does not catch the error.

I tried to reproduce your code, but it complains about (@stmt), apparently you did not test this code prior to posting.

But my point anyway is that Catch block cannot...

While I was typing my reply, Antonio suggested an idea of placing primary ticker in to Firm table.

OK, but we want to have tickers together, in one place, which is...

Thank all of you for your input.

Yes, and I also got error while trying to sum on bit. But I would not like to switch it to tinyint in order...

In case if you want to get exact actual execution time of a stored procedure to calculate its average, minimum, maximum execution time, I can also sugget using sys.dm_exec_query_stats system...

Thanks. That's what I wanted.

Ah sorry, I thought you're asking about 2005. I don't think you can do anything with 2000 for what you need.

You can use couple of things:

1. sp_spaceused -- run it in context of your db

2. Here is a script which I use for myself. If you want on kb level,...

To drop statistics, you need to qualify it with its table name like this:

Drop statistics my_table.my_statistics

But let me ask you a question: why it bothers you ? It occupies very...

Try this (I did npot test it but it may work in your situation):

begin try

-- script to connect to your db

end try

begin catch

-- nothing

end catch

This is what comes to my mind. This is not complete list, I am sure other members will add some more.

- blockings

- tempdb size

- empty space left on hard disk

-...

With the only exception of April 2008 issue, TechNet Mag usually has very small section for SQL Server. And I also love this site, SSC, but this is not a...