There are no connection strings...

I posted my question concerning the Quote issue to the following URL since it is different than the initial question:

http://www.sqlservercentral.com/Forums/Forum392-1.aspx?Update=1

Thanks.:-)

I almost have the query constructed however I have an issue where I need to assign the value )') AS DB2 to a variable so that I can concatenate with...

Unfortunately it did not for the article was related to an issue with an Indexed View. Thanks.

@GSquared, I just created the Triggers & Table in T-SQL.

Thanks.

There is a Dynamic Management View named that I believe contains the words Information Schema that tracks changes to objects. It has everything that I was tracking in my DB...

I'm going to do it in a cursor but a While Loop would be preferable.:w00t:

Thanks.

It fails for people with sysadmin.

When I initially created it I could add tables.

Then I tried dropping a table and I got the same error.

The following day I get an...

Yes, I have a trigger for Insert, Update & Delete Table.

Thanks.

Jeff Moden (11/30/2011)

---

Ironically, you've shot yourself...

@dev all of thie information that I was gathering from the Database Triggers is stored in a DMV.

Do you know which one?

Thanks.

The problem was caused by a Database Trigger that I created.:sick:

I deleted all of...

Dev (11/30/2011)

---

Is there any Indexed View defined on the table? Following issue is related to 'ARITHABORT' setting. It might be applicable to 'ANSI_NULLS' as well.

PRB: Error "INSERT Failed"...

I tried creating a Backup Table with the Intent of Performing a INSERT INTO and I get the same error.

Please note that I did not create the original table.

CREATE TABLE...