The issue was with the login Replication_user.

The password policy was setup to expire the password of that user and so the password was expired which caused the issue.

Once the password...

The issue was with the Windows login Replication_user.

The password policy was setup to expire the password of that user and so the password was expired which caused the issue.

Once the...

Please let me know how you resolved that issue.

Thank you sir! Got what SSMS's role is.

But, is there a solution where we can explicitly close such sessions? which made the server performance usage to 95%?

Kindly let me know...

SELECT definition

FROM sys.system_sql_modules

WHERE definition LIKE '%xp_cmdshell%';

 

Source: The Real Danger Regarding the xp_cmdshell Setting - SQL Server...

What is a valid owner? Kindly let us know.

Thank you!

 

• This reply was modified 5 months, 2 weeks ago by  Meera.
• This reply was modified 5 months, 2 weeks ago by  Meera.

Jason, were you able to succeed?

We too do have SP using dynamic SQL. We are on move towards 2022 from 2014.

Thank you Brian! Thanks for the hints.

And yes, I read the doc, but can't think beyond.

What exactly the scan means for the field "user_scans" being with the table "sys.dm_db_index_usage_stats" ?

Like, there are tables in our DB which aren't used for sure as the module is...

apillay2 (6/12/2012)

---

I have found exactly the same error. The following steps helped me.

1. Make sure that you are executing in 32 bit.

2. In the Show...

Hi ! No one to help me ?? 🙁

Hi Arun,

Though its been few years i guess you might see this post.

I tried using your solution for catching the error log in SQL 2008 R2. But the thing is,...

After refering to the below link,

http://www.sqlservercentral.com/Forums/Topic262686-8-1.aspx

i got the light. Actually i had...

The error is appearing only when using the DateAdd function.

So is there any other query to find the date of last year??

Please any one reply..

Hi !

Is there a link betwn the parameter value and the value which conditions it ?

Like City Table:

No City

1 ...