Don't do double post!

All reply should be in this post:

http://www.sqlservercentral.com/Forums/Topic627895-146-1.aspx

We have double post all reply should be in this post:

http://www.sqlservercentral.com/Forums/Topic627895-146-1.aspx

Ok...can you post the info how did you find the solution!? - just for info ...couz we here are trying everyday to help...

I agree with Gila's solution ...this is the best way you can do!:cool:

Simple no!

These info are coming from Master database sys tables! You should write other code to enable or disable users...

Raghavender (12/30/2008)

---

Hi All,

can any body provide me How to find out Active and inactive logins of a SQL server logins.

Inactive logins means the logins which are not using for more...

I think better is to do with T-SQL !

Simple:

First Drop Constraint then

Add Constraint again

ALTER TABLE Your_Table

DROP CONSTRAINT constraint_name;

ALTER TABLE Your_Table

ADD CONSTRAINT constraint_name FOREIGN KEY (your_field) REFERENCES Ref_Table_Name(Ref_field) ON DELETE...

Anyway ...you are welcome!

😛

How many records do you have in you table!?

I don't know what is your code but you can look here that everything is OK!

CREATE TABLE TAB2

(

DATE DATETIME,

EMP INT

);

CREATE TABLE TAB1

(

DATE DATETIME

);

INSERT INTO TAB2

SELECT '01/01/2008', 123

UNION ALL

SELECT '02/01/2008', 123

UNION...

So do you have still problem with linking...

Sure that you are new here and you are welcome ... but please read carefully all the...

Yes he has skills to generate the code in professional way, simply he's Code Generator!

:hehe:

Yea ... no application which support this file format ...and from google results have info something with dos!

Is the Access file with password!?