I have done some installations, but I didnt face any critical problem. Thats why I am curious about others experiences.

"ApexSQL Data Diff 2008" I am using. working fine for me.

Using SSMS

Right Click on

Management->DatabaseMail

and try to send test mail to ensure you have configured properly.

search in google and scribd.com

No. SQL Server is only for Windows OS

Yes. We are using it for the Past 6 months without any problem in SQL 2005 SP2.

Hi

If 2 servers are not in same domain, use certificates to mirror. i faced the similar problem and resolved by using certificates.

muralidaran r

SSCrazy,

can i deny all permissions on all tables after granting execute permission to required procedures.

what user role i have to create or assign/remove for this user?

thanks

Can I Restrict all permissions to a table and give access to that table via a stored procedure? How?

Thank you qtsohg.

Your suggestion works.

Hi

Thank you for your reply

Now I am working with development DB. I have little experience in installing SQL Server, Attach/Detaching Databases, Scripting and Creating Databases.

As you said I am planning...