What may help is if could post the DDL (CREATE TABLE) statements for the tables, some sample data that is representative of the problem you are trying to solve, and...

Sqlism (8/7/2012)

---

Hi DBA's

why there are two ports 1433 and 1434 for SQL Server.

whts the purpose of two?

how are they different?

I came to know 1433 is for TCP\IP

1434 for UDP what...

Also, it may help if you post the error message you are still getting.

Welsh Corgi (8/7/2012)

---

I changed the connect for each execute SQL Task associated with each Event Handler and I'm still getting 43 errors.

How can I isolate the source of the problem?

Perhaps...

Smash125 (8/7/2012)

---

I got the solution what i wanted but not a good solution

SET ROWCOUNT 1

WHILE 1=1

BEGIN

DELETE FROM #Contact

WHERE FirstName IN (SELECT FirstName FROM #Contact GROUP BY FirstName

HAVING COUNT(*)>1)

IF @@ROWCOUNT=0

BREAK

END

SET ROWCOUNT...

Scott D. Jacobson (8/7/2012)

---

Do you have any more material on this or is it purely anecdotal? For instance, what's wrong with this?

SELECT Col1,Col2,Col3...

anthony.green (8/7/2012)

---

Nothing, Logshipping issues BACKUP LOG commands like you would do normally.

You have missed one key point out of your process.

When you change the database to SIMPLE, to shrink the...

gerard-593414 (8/7/2012)

---

I have a simple SPoc:

ALTER PROCEDURE [dbo].[TestSPR]

@P1 int

AS

BEGIN

SET NOCOUNT ON;

DECLARE @MyExec VARCHAR(100)

SET @MyExec = 'Select * from MyTable where MyField !=...

I use CTEs to breakdown development as well. Makes the code cleaner when the CTE is used instead of a derived table in the FROM clause, and it makes...

Sean Lange (8/7/2012)

---

Lynn Pettis (8/7/2012)

---

On a lighter note; with the help of my oldest daughter, my middle daughter is going to be attending Embry Riddle Aeronautical University in Prescott, AZ...

On a lighter note; with the help of my oldest daughter, my middle daughter is going to be attending Embry Riddle Aeronautical University in Prescott, AZ starting this fall!

Once there,...

If you don't have a backup file from prior to the record being deleted, you are out of luck in recovering the deleted records.

SQLRNNR (8/6/2012)

---

Lynn Pettis (8/6/2012)

---

It has to be a Monday, my mind immediately hit the sewer when I read your response....

JasonRowland (8/6/2012)

---

Oracle converts an empty string to null. If I could choose how SQL Server handled it, my 1st preference would be a type conversion error. 2nd would be the...

It has to be a Monday, my mind immediately hit the sewer when I read your response. I apologize.