Comments for SQLZealots https://sqlzealots.com This site discusses and shares thoughts and experiences in SQL Server. Thu, 06 Feb 2025 02:59:30 +0000 hourly 1 http://wordpress.com/ Comment on How do we provide xp_cmdshell access to a SQL login who is not a member of sysadmin in SQL Server by Stella https://sqlzealots.com/2019/03/03/how-do-we-provide-xp_cmdshell-access-to-a-sql-login-who-is-not-a-member-of-sysadmin-in-sql-server/comment-page-1/#comment-24051 Thu, 06 Feb 2025 02:59:30 +0000 http://sqlzealots.com/?p=1375#comment-24051 This is helpful information about resolving xp_cmdshell errors.

Like

]]> Comment on How to build comma separated string in SQL Server by Caroline G https://sqlzealots.com/2020/03/22/how-to-build-comma-separated-string-in-sql-server/comment-page-1/#comment-24050 Sun, 19 Jan 2025 20:04:37 +0000 http://sqlzealots.com/?p=1727#comment-24050 Interestiing read

Like

]]> Comment on Exception: The module being executed is not trusted. Either the owner of the database of the module needs to be granted authenticate permission, or the module needs to be digitally signed. by Anonymous https://sqlzealots.com/2022/10/12/exception-the-module-being-executed-is-not-trusted-either-the-owner-of-the-database-of-the-module-needs-to-be-granted-authenticate-permission-or-the-module-needs-to-be-digitally-signed/comment-page-1/#comment-24047 Tue, 05 Nov 2024 06:45:33 +0000 http://sqlzealots.com/?p=3838#comment-24047 thank you

Like

]]> Comment on How to recover “Recover Pending” database in SQL Server by Anonymous https://sqlzealots.com/2021/01/11/how-to-recover-recover-pending-database-in-sql-server/comment-page-1/#comment-24044 Sun, 20 Oct 2024 16:55:19 +0000 http://sqlzealots.com/?p=2873#comment-24044 Gracias,

Pude corregir la falla que presentaba mi base de datos con tu aporte.

Saludos!

Like

]]> Comment on Search a value in your database in SQL Server by Anonymous https://sqlzealots.com/2020/03/29/search-a-value-in-your-database-in-sql-server/comment-page-1/#comment-24043 Sun, 18 Aug 2024 19:19:16 +0000 http://sqlzealots.com/?p=1754#comment-24043 Nice script, Add TABLE_SCHEMA in the where condition (line 40), else it throws an error if there is more than one table with a different schema.

Like

]]>