as Ninja has asked, why?

there are many reasons why your db might be getting slow,including non existance of indexes, data files and log file sitting on the same volume, poorly...

you can not use the data grid view in that manner, the nearest you can get for what you want is using the listview with grouping. else you will have...

the reason is, the dev studio will be waiting for resources which might have been deadlocked.

how the data looks is really the business of your reporting tool. Which tool are you using for reporting?

In most case in your reporting tool you can use the grouping...

did u get this one resolved?

you take 70-431 to be mcts, and yes to your other questions

did you enable your broker

ALTER DATABASE TestDB

SET ENABLE_BROKER

did you try rebuilding your front end app.

can't we get someone from MS to explain why they don't show us the wrong answered questions?

the MCITP:database admin is sort of a replacement for the old mcdba on 2000. i would advise you to do the mcitpB admin....

But any attempt to connect to my local server remotely fails (neither mixed mode nor windows only).

which server are you trying to connect to? 2005 or 2000

did you get a solution for your problem?

pardon my misunderstanding what exactly are u supposed to be doing.

why do you have [where  AlertDate >  (select CAST(getdate()-@day AS varchar(50)))]

it might be helpful for you to post your code and then we can take it from there.

you will have to:

create a signed assembly in .net  environment

create an asymentic key on sql server for the .net assembly

grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly

probably create...