Edit: Double posted. Deleted the content.

Jeff Moden (8/15/2012)

---

If it were a prerequisite for speaking, I'd still wear...

Bumping the curent thread would have been an acceptable alternative to double posting. I'd seen this thread yesterday as I was...

As for the tweaks:

USE AutoDispatch;

go

declare @BatchSize int;

set @BatchSize = 10000;

WHILE @BatchSize > 0

BEGIN

DELETE TOP (@BatchSize)

FROM t1

FROM dbo.yConnections t1

...

SQL_ME_RICH (8/15/2012)

---

Lynn - thank you again! So - based on what you have constructed, it looks like if my PROD db is a db called 'AutoDispatch' and my ARCH...

You can also do some reading on EXCEPT and INTERSECT in Books Online. These could be used to identify rows that exist in one table and not another or...

Apparently no one responded here so OP started a new thread here. Please post any responses in the new thread.

Something like this should work, but it may need some tweaking depending on how many rows will be deleted, especially the first time.

DELETE FROM t1

FROM dbo.MyTable t1

WHERE EXISTS(SELECT 1 FROM...

Are the table structures the same?

To be sure, you want to delete rows from PROD where they already exist in ARCH, correct?

Also, do both tables have a PK defined?

Let's create a user, say abc, in database xyx and map it to the login IDTENT. Grant it some rights in xyz. Now let's create a login named,...

The rest of my comments above still stand.

You need to cast @lastdate back to a character string if you...

Pablo Campanini-336244 (8/15/2012)

---

Hello, thanks for your help...... here is what I do:

Let me know if it works.....

CREATE DATABASE someDatabase

GO

USE someDatabase

GO

CREATE USER abc FROM LOGIN imstestuser<< this is also a SQL...

It isn't the questions that are getting worse, nor is it the answers.

Does not tell me how you have...

Pablo Campanini-336244 (8/15/2012)

---

Hi

The command:

CREATE USER abc FROM LOGIN testLOGIN

creates a "database" login, not a SQL Instance login.

Please create also the sql ID at an Instance level.

Then connect to the SQL...