Addition to Jason's comment I would say post your question in proper way that everyone should understand quickly.

Microsoft has introduced a new feature in SQL Server 2008 - Change Data Capture that helps to track the database changes.

Checkout the belo link

-Abhijit

You can identity it by running the sysprocesses query.

When you run the query you will receive the same message saying "database is in single_user mode".

If you check the resultset you...

Thank for you replies. I have already done it by using SSIS- FTP task.

Smart Answer. I agree with with you but the thing is is no one know this then how could you identify it.

oh sorry here is the link

http://answers.yahoo.com/question/index?qid=20070429222309AAYDhyU

Any SQL / Windows jobs overlapping to each other or taking longer time than the usual. THsi could be the reason also.

I have already tried the command provided. see the problem is I can able to read the files on local drives c:, d: but i am for able to read...

I was facing the same issues on my development enviornment. I seperated the mdf & ldf files on different drives & this solved my issue.

for reference you can read the...

Thanks for replying 1st :).

I did tried with the fullpath of the server as you specified, but it is not returning "0" for all.

I just want to read the files...

you can also run the below query to get the details

select * from msdb..sysjobactivity

Assuming this post belongs to SQL server 2005, you can use the below query to return all SP in the database

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE'

Gail,

I read in one of the article we can turn off the message by running the traceoff flag 803

hey thxs for th eprompt reply.

As per the database records I have to convert the record to know whether it is midnight / nooon.

And the expected results is

12/24 instead...

I have already done this but this allows user to create other objects also. I want to restrict the user upto create procedure permission level.