monilps (4/27/2016)

---

I checked the query and it works fine, can you please make sure you have selected everything. Also objname and newname are different. I am trying to rename PrimaryKey...

I may work on this more tonight, but I can't replicate your problem.

Not sure about anyone else but I am still lost.

The DDL for the table ETLPreparedStatement, please.

Sean Lange (4/26/2016)

---

Alvin Ramard (4/26/2016)

---

Tempted to...

ThomasRushton (4/26/2016)

---

Do it. They'll thank you later when they don't get...

You may want to review the legal issues involved if you are considering mirroring PII information from the EU to the US.

I wonder if we should mention the legal issues that may be involved in doing this: http://www.sqlservercentral.com/Forums/Topic1780501-1550-1.aspx

https://msdn.microsoft.com/en-us/library/hh994726(v=sql.10).aspx

Start with Books Online, the SQL Server Help system. There is a lot of information there to get you started.

New persopn (4/26/2016)

---

Hi All,

As per client request we are capturing Server level audit information to File. Now they want file information needs to be in table format.

Can someone please guide...

Modified previous code to include object information.

select

dbprin.name PrincipalName,

dbprin.type_desc PrincipalTypeDesc,

dbperm.class_desc,

dbperm.permission_name,

dbperm.state_desc,

...

FYI, code using system views instead of the 2000 backward compatibility views:

select

dbprin.name PrincipalName,

dbprin.type_desc,

dbperm.class_desc,

dbperm.permission_name,

...

Brandie Tarvin (4/26/2016)

---

[headdesk]

Seriously. SERIOUSLY?

Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this link.

SELECT b.name,...

Can you recreate the issue with a sandbox database in a test/development environment?