Can we schedule profiler at some specific time, becuase in profiler GUI i could find RUN button and the stop time option not start time option any where?

what exactely replay means here?

As its a part of replication, some times the transactions which is already replicated doesn't get clear from transaction log.

In that case it would get clear by::

sp_repldone

It would not harm...

Thank you very much 'Chad' for this excellent explanation! and make the concept clear to me.

Many Thanks to you!!!

Cheers,

Deepak

if you are looking for hard disk capacity etc.

its xp_fixeddrives

cheers,

Deepak

Check who is having sufficient previlages to do that, otherwise i dont think if there is any way......except if you have enabled C2 auditing on the server. Which is disabled...

Thanks Shiva,

it worked after comment the

--and u.name like ''tester''

line, what could be the harm to run undocumented procedure sp_MSForEachdb

as i have to execute it my...

Shiva,

I am also using SQL 2005 and again tried your big script, but again no luck. See the result below

(0 row(s) affected)

name ...

you need to alter the tempdb database in this case(means need to increase the size of DB) from the query analysir, in this situation you might see all the DBs...

Shiva/murthykalyani thank you very much for your respond.

Shiva, your script for all the databases is not giving any result don’t know why.

murthykalyani, from your script the below part

select substring(db_name(),1,30)...

sp_helpuser is not giving the desired result and its not possible to run it if you have huge no of users - to run it for individual user is not...

Chad, thanks a lot.

Does any specific authentication needs for this concept.

Or normally sql authentication/Mix mode can be used - as usual.

And server IP or its name + with any user...

Just keep the server out of firewall - makes it visible across the internet who is haveing its address/Uname/Pass etc.........if its possible-it looks strange to me..........there must be either some...

Yeh, ive heard this before also. large data would be slow and its not secure coz your DBs are hosted into someone else server.

But I am intrested to know what...

at last its done!!!!!! :):):)

In below three simple steps.......

1.) Create Role ViewSPs --create role ROLENAME(choose the database in which you want to create role)

2.) Grant View Definition...