We also can't assume that DateOfBirth isn't nullable.

SELECT TOP 1 *

FROM MyTable

WHERE DateOfBirth is not null

ORDER BY DateOfBirth DESC

Explain what it means to "get the person"; do you want to return the entire person row, just the person's ID, etc. ?

Dird (7/25/2013)

---

Why does it tend to fail (besides login issues) a lot? What kind of number is "a lot" of servers?

Although currently I'm just looping through 11 servers and doing...

Since your code needs to run against 2000 - 2008, perhaps...

I personally havn't had a need to do it, but since you have the inspiration, here is a link to get you started.

Mapping SQL Server 2000 System Tables to SQL...

Lowell (7/25/2013)

---

another possibility is to create the user with the "right" limited permissions, with the same password as 'sa' currently;

that should be easy to do , since everyone is logging...

Luis Cazares (7/25/2013)

---

As far as I know, those dependencies are only within the database. If there...

This situation smells like Entity Framework. I'll bet it's developers telling management they need sysadmin membership in production or else the application won't work.

Sean Lange (7/25/2013)

---

Sounds like you guys have kind of painted yourselves into a corner. There is a way to do this but it is not exactly best practice. Basically what...

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...