I need to select the field not hard coded data, how do I do that?

Thank you

How can I check if the script ran, if the db got smaller or what else got better? Thank you

This code is not working:AND @@spid(error on this), but that is ok I understand.Thank you

SELECT spid

FROM Master.dbo.sysprocesses

WHERE DBID NOT IN (1,2,3,4) -- Master, Tempdb, Model, MSDB

AND spid > 50

AND...

I have a light profiler running and all results go to the master db saved to the table. Is it safe to keep results at master db? also if the...

Thank you

There is note under script:

Note:

Use the CatalogCleanup.vbs script when your Commerce site is not running to prevent performance impact and to make sure that all temporary tables are deleted....

So, I don't need to delete temp tables?

Yes, I have all the permissions,but I am looking for the full script how to do this job, can you please provide it to me.Thank you

Yes, but I need to set up the job to run script:put db off line run script, put db back on line. I want to know if anyone familiar with...

Thank you

Can you explain how I can get to it?Thank you

Thank you, I get sort warning error under event class, what is this mean and how can I see where it is coming from

I want to set up sql profile, and I need your advise what are the negative sides you know

Thank you,but I am not login in, I am trying to see why I have this in SQL Logs, Our application is using websised and I am getting this error...

How can I check context the service runs under