We created a seperate login. And gave db_owner permissions for the remaining databases. But my doubt is about the server level permission.

We are assigned public server role to that login....

SA account is already disabled. so I need to give public server role and map as dbowner for remaining databases right?

I am re-framing my requirement.

We have a team working as DBA (Offshore). We have 5 user databases. One database has the secure data and doesn't to reveal the data to...

What about the test1 database?

Are they able to access the data from the test1 database?

Trying to findout the way that how to calculate the additional disk spaces required for the existing database?

It is showing available free space is 20MB for that database.

I calculated the database growth based on the backup sizes for a month.

Is that ok? Do you have any another script to calculate database growth

I need for existing database.

If database current size is about 350GB and growth is about 70GB/month. How do you calcaulate the D:/Drive free space and L:/Drive free space

Thanks Robert.

I do have another question

The report is using the stored procedure. If I execute the sp and choose one username that doesn't exist database it will display the msg...

Thanks all

Perry, I am not getting clarity how these availability groups works for reporting.

I do have another doubt

We are planning to have only one secondary replica (only one read only copy)....

I am re-framing my question about the sensitive data.

Currently we are using 3 production servers. In one production server we have one database has sensitive data.

Suppose we have Server...

Hi Perry thanks for your link.

The client have some business agreement. ServerA databases never mix with ServerB database. Also we are worrying about the load also. If we keep all...

That is not related to parameter sniffing.

Why because we are passing 3 input parameters. Those are default parameters. We are not changing either in SP or Report also.

Just tested the...

No recent password changes to the service account.

How to figure out is this causing by the firewall?