Thanks a lot

Ok.

Thank you for valuable time & coordination.

John Mitchell-245523 (2/7/2014)

---

So local Windows account instead of domain accounts? Exactly the same principle, except that the linked server process won't work. You'll have to search to find...

One more thing which I want to ask again:-

If the users(Windows Logins) are located in a single machine where the SQL Server exits then what should be the procedure.

Kindly reply.

Suresh B. (1/31/2014)

---

Subrata Bauri (1/31/2014)

---

Actually I want to list out all the inactive users(windows) which are not able to login into the OS & henceforth they are not able to...

I'm...

This will work when users are disabled in SQL Level not...

Thanks for your reply.

I have few nos. of Windows Login Users in my Server System (OS & SQL Server Level) & One of them is blocked (Account is disabled in...

Thank you Sir,

Please clarify what is difference between Permission to connect to database engine and Login in the Login Properties windows ?

Thanks for your reply.

Code executed in the SQL Server 2008 R2 Platform successfully But it does not give any result.

<address>your mobile numbers</address>

this will repeat on basis of how many Mobile number found.

drew.allen (9/13/2011)

---

If you don't supply a time, it defaults to midnight (00:00:00.000). So the datetime that your comparing to is '2011-05-31 00:00:00.000' which is less than the datetime on...

Thanks for instant reply.

That is one I have in mind.

Ignacio A. Salom Rangel (7/27/2011)

Hi Subrata, Ninja's point is a very good one. If the application supports a newer version of SQL, it will be better to upgrade to a...

Ninja's_RGR'us (7/27/2011)

---

I feel the need to point out that sql 2005 is about to go out of support.

Any reason why you're not upgrading to 2008 R2? Or even Denali...