Sql experts-need one query

[Bairagi From Bapatla]

Oka 2dbs lo bairagi ane user unnadu, vadiki read access and deny write access permission unnai.

aa 2dbs meedha eppudu aa access poyina ventane naku alert email ravali idhi requirement

query help cheyandi please ela rayalo

[Bairagi From Bapatla]

Ltt

[SANANTONIO]

https://solutioncenter.apexsql.com/sql-server-auditing-how-to-be-alerted-about-important-auditing-events/

 

https://www.quest.com/documents/change-auditor-for-sql-server-datasheet-67985.pdf

emanna use avthada idi

[kum5758]

need a help too

oka column undi adi ey database objects (store procs, views, function) lo using inka SSIS packages lo using telusukovali SQL lo

any website?

[Fish]

Just now, kum5758 said:

need a help too

oka column undi adi ey database objects (store procs, views, function) lo using inka SSIS packages lo using telusukovali SQL lo

any website?

Separate thread veyyi so that all can see

[pachimirchi]

1 hour ago, kum5758 said:

need a help too

oka column undi adi ey database objects (store procs, views, function) lo using inka SSIS packages lo using telusukovali SQL lo

any website?

sys.all_sql_modules.definition lo search cheyyi using sp_msforeach db

 ssis solution lo search cheyyi using column name or write the definition of ssis package (xml) into a table and search or use a text search tool in the folder that has all ssis packages

[pachimirchi]

you could also use a object search ssms addin like redgate sql search or something similar.. 

[kum5758]

sql search using for db objects

ssis ku yeah XML parsing cheyali

Thanks

[pachimirchi]

13 minutes ago, kum5758 said:

sql search using for db objects

ssis ku yeah XML parsing cheyali

Thanks

alternatively ,less than 25 packages vunte ,  you can use trial ssis documentation tools like BI documenter that generates chtml files for searching .. XML parsing oddu ankunte  nvarchar max lo pedesi kooda search cheyyochu

[Pipucbn]

4 hours ago, Bairagi From Bapatla said:

Oka 2dbs lo bairagi ane user unnadu, vadiki read access and deny write access permission unnai.

aa 2dbs meedha eppudu aa access poyina ventane naku alert email ravali idhi requirement

query help cheyandi please ela rayalo

http://www.msbicoe.com/post/2012/04/05/Automatically-Transfer-and-Synchronize-SQL-Server-logins-SIDs-Passwords-and-Permissions.aspx

njoy broder... dhantlo ne download the package link undi at the bottom and modify according to your need

[SwamyRaRa]

Gp