Can you...

If you want to have control over the values in your IDENTITY column, I suggest that you don't use an IDENTITY column, or that you consider using SET IDENTITY_INSERT ON...

mcfarlandparkway (6/28/2016)

---

Thank you Eric, But didn't came nay results.

showing object name as delPersons ....I see only this.

Is there any way that they are handling this audit data from some where...

SQL Search[/url] is free and really useful when you are looking for references to database objects. Maybe it will help you track this down.

Sergiy, thank you for taking the time to write these informative posts.

I admit that I am guilty of following Paul White's recommendations as would a sheep and now I shall...

zouzou (6/28/2016)

---

I found out when i refer to an instance name inside the SSIS package it doesnt work when you deploy the package in sql job although in Studio is...

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server....

Have you verified that the SQL Agent service account has requisite permissions on the target SQL Server instance?

Jeff Moden (6/27/2016)

---

jeffe_verde (6/26/2016)

---

The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each file is...

zouzou (6/28/2016)

---

Hello there

I have an issue with my SSIS packages they run fine on Studio 2013 but when you try to run them as a SQL job in SQL...

jeffe_verde (6/25/2016)

---

I receive three versions of a file each day, which I then import. But the file names are such that my ForEach loop processes the files out of...

Paul White suggests that the NOT EXISTS ... INTERSECT form produces better query plans than the EXCEPT form, and that's why I use it. See here (in the comments).

UPDATE is probably better than MERGE.

If you are a fan of MERGE, please take a read of this[/url] and decide whether, perhaps, you should reconsider.

And rather than using this type...

Ed Wagner (6/23/2016)

---

Phil Parkin (6/23/2016)

---

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10%...

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10% import tax and GB...