Hi Eddie,

Thanks for the quick response. That is what i have been checking in books online as well.

Is there any workaround to trace/audit the DML operations from using sql profiler?...

Here is where am getting confused?

Difference between windows collation and sql collation?

what is relation between collation, code page and sort order id ?

John, thanks for the quick response and that makes sense. I have checked with a join query and fail's and i had to specify the COLLATE DEFAULT_DATABASE and it works...

One doubt,

Does the SQLSortOrder is tied up with the collation name or the code page????

I have created a database with collation "SQL_Latin1_General_CP1_CI_AS" and when i say

sp_helpdb 'db1'

Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52

Similary i...

Thanks guys.

Fine. Thanks for the information.

Thank You.

One question, can i remove the existing certificate using which i have installed using serveice account.

again, open mmc and this using computer account can i loaded it back?

yup. Thank you.

Now there's no problem. Just wanted to knw why GUI shown like that.

I dnt even see any err messages like below.

"

Could not allocate new page for database '<db>'....

Thanks Welsh.

That was really motivating.

I am new to sql. I will buy some books and study.

Thanks once again.

Thats what am wondering, it is not showing any event logged in SQL Server error log nor Application log.

Users reported that they were not able to save data.

I went...

Database growth is also fine.

My question was is there any such scenario where in Enterprise manager shows 0.0Mb.

Any known issue of Enterprise Manager.

Thanks.

Hi Welsh,

Both data and log files are set to unrestricted file growth and it is a cluster. There is lot of disk space available in the shared drive.

Thanks

Hi Welsh,

Thanks for the quick response.

How does the maxsize of the data file effects this???

Could you please elaborate with an example.

Am really wanted to know why this happens.

Thanks in Advance.

Hi Brian,

Thanks for the wonderful explaination.

Regards,

Yes, Am looking for something like cacls.exe. I dont want to change the permissions. i want to see whether he has read-wrte or deny permission on a particular folder.

Thank you.