The trigger route seems like it can be pretty painful.

How many procs can update this table?

If there are only a few, then would creating a separate table that...

Run the proc on the linked server???

EXEC serverame.databasename.schema.proc

Or, create a job on the linked server and start it like this:

EXEX servername.msdb.dbo.sp_start_job @job_name = 'My job'

Be sure that they are not used.

Remember that the data being used by sp_blitzindex is re-set after every restart of SQL server.

So, if the server was re-started...

Jeff Moden (6/19/2015)

---

Michael L John (6/19/2015)

---

The unfortunate part is that it's sometimes very difficult to get the crowd to see the importance of doing it "right" and what "right" means....

Lynn Pettis (7/8/2015)

---

Won't work since the OP wants the numeric values converted to integer values:

select cast(Data as int) from #TestData where Data not...

Try using a UNION ALL.

If the name of the column is simply "ID", regardless of case, that's probably not a good practice.

It means nothing. Would table_name_ID make more sense?

As for naming conventions in...

+ 1000 for what Steve said.

As an example, the import wizard will convert every number to a float. You really do not want to use floats in your database. ...

This causes data inconsistency where 50% of the code was saved to the DB and 50% was not - seeing that a stored proc is not transactional and therefor does...

The only approach to get this working is AFAIK to use a loop of some kind (like sp_MSFOREACHTABLE) and within this loop you use dynamic SQL to execute the query...

Is your connection string something like this:

Persist Security Info=False;User ID=DOMAIN\USER;Password=PASSWORD;Initial Catalog=AdventureWorks;Server=MySqlServer

That is not going to work. This is what you would use for SQL authentication.

To use Windows authentication, this needs...

It is not the case in a relational model of a database when a B row is added and a C row is added. They can (B row and C...

The unfortunate part is that it's sometimes very difficult to get the crowd to see the importance of doing it "right" and what "right" means. If it's overwhelmingly impossible...

Megistal (6/19/2015)

---

Trying to get that structure normalized as much as possible (Having two or more child tables mutually exclusive linked on the same parent table) while preserving a "DRY" column...

You have been given the answer to your problem in both the error message you are getting, and in the post that Phil provided.

Use WITH REPLACE in your restore...