Hi John,
thank you for the reply, i found the issue. the public role is having deny select checked in the create and grant script.

Hi All,
Thank you very much for your valuable suggestions about the issue i faced. i found the solution for this issue, the user is trying to see the...

Hi,

I am Installing the SQL 2012 from command prompt. yeah we can run the .exe file as well from the installation media, but I want to run through command prompt....

Hi,

Thank you for your valuable time and support. Now I got to know about this, thank you very much. I have need a small help. I have downloaded sql server...

Thank you Jack,

for the valuable information I will check it and see what can be changed.

Thank you in advance.

Hi PuJain,

Thank you for the script, when I run the query I found that Last Select is ‘Null’ what does this 'Null' mean.

Thank You Bhuvnesh for the quick reply,

But it’s difficult to find the table which is not been used more than a month as my server was rebooted since 65 days....

Hi,

Its a dedicated SQL Server machine, no other application is running in that.

Hi Dbasql79,

The page files are set to 4096MB in both of the drives on C: and D: So total allocated page file size is 8192MB and C: drive...

Hi Gail,

Thank you for the reply, I will raise a CR and then I will reduce the ram memory for the SQL Server, but a doubt on this as how...

Hi,

Thank you for the reply... how to get back the memory which is used by SQL Server as we need some for OS as well. Here my concern is that...

Hi All,

Thank you for the reply, I have configured the logshipping on this database and from starting the log's are not getting restored to the destination database from the copied...