It really depends on how you manage it. The current interface does not allow for setting to render Excel only. But you can setup subscriptions to email to folks, or...

In profiler there is no stats option. But if you can alter the table you could add a tigger to create stats into another table. I also believe (which I...

Are you talking about they log into IIS with windows authentication and IIS uses their account to login to SQL? Or you are using a generic account for IIS which...

What do you mean. Do you have a report you want people to access and when they do it provides Excel without the definition or how exactly?

sp_helpfile I think is what you are after.

You might need to restore all of our databases starting with master if it was damaged as well. Can you open QA and connect to the server or not?

Commit occurrs at the end of the batch, however the transaction log will not truncate if it grows due to the size of the transaction. Consider if you insert 5...

I prefer to use the query execution plan to provide the info I want to know but you can use all sttas are usefull if you are looking for a...

These just background processes that take care of normal SQL Server operations.

Run

DBCC UPDATEUSAGE (dbname)

in query anaylzer. The data sometimes need to be refreshed.

I want to say thou that the number can be different when there are pages allocated in the database...

Tables and data Oracle should have an improt tool for that. However code for procedures, functions and triggers may require you to translate to Oracle or find a tool that...

How does login occurr for the processes. If it is a generic user thru ASP then it will be limited. If the user must login first (to the admin section...

"If you ask them how they do it they do not have an answer."

So is that how you reconginize them?

I always say it comes...

I can write/draw/protype it all out on paper but gave into the other crowd when they required us to track all our changes including a comment that we have to...

RIght because the parameter is apparently being set to '' and not null.