OracleBoy (7/24/2013)

---

Hi thk for the reply ,

I want to know the size attribute to pools , memory , cache ...

It's not possible to know if user can create for...

In SSMS, you can right click an object and select 'View Dependencies'.

Zeal-DBA (7/25/2013)

---

hi Eric,

thanks for such a good explaination, actually there are already multiple running applications and it is not possible to remove logins from sysadmin role or cant modify any...

The simple truth of the matter is that if the users are members of SYSADMIN role, then they own your database. Your organzation doesn't have one or two DBA's, it...

mohan.bndr (7/24/2013)

---

Thanks all you guys for responding,but I believe in the older version of SQL Server (200 and below) can only possible.... am i correct ? and for SQL 2005...

Are you sure you personally are a consultant?

If you're paid a salary by your employer, then you're no more a consultant than the receptionist is, even if your...

You can call your process whatever you want, but what really matters are requirements, ticketing of tasks and bugs, source control, peer review of code, seperate dev / qa,...

Steve Jones - SSC Editor (7/19/2013)

---

djackson 22568 (7/18/2013)

---

Unmentioned in the article is an issue the industry needs to address, which is that a lot of vendors develop software that requires...

jdbrown239 (7/18/2013)

---

Thanks

Thanks Sean that worked. I also found that substring worked too.

update XDDDepositor

SET XDDdepositor.WBeneName = Vendor.RemitName,

XDDDepositor.WBeneAddr = SUBSTRING( Vendor.RemitAddr1,0, 35),

XDDDepositor.WBeneAddr2 = SUBSTRING( Vendor.RemitAddr2, 0 , 35),

XDDDepositor.WBeneCity = Vendor.RemitCity,

XDDDepositor.WBeneState = Vendor.RemitState,

XDDDepositor.WBeneZipPostal...

In addition to protecting login credentials of accounts, another layer of security is at the firewall configuration level with IP blocking. That way, even if someone finds a sticky note...

The best service that data professionals can do for the benefit of mankind is to keep the database locked down and secure.

Obviously this concept of data philanthropy, sharing corporate data with the world for the good of hunamkind, should be left up executive management. Please run it past your boss first.

Based on news stories, it seems to me that the vast majority of data breaches, and the ones that the most massive in scale, are the result of inadequate role...

anon_tyrant (7/15/2013)

---

RDP is the real tool, laptop is only needed if you need to connect somewhere besides home or work. I finish up work at 5, go home and...

I have a beefy desktop sitting under a rarely used desk, and I VPN into that from a laptop. Thanks to VPN, the laptop is a cheap $350 model and...