since this is a one off, i would generate the statements, and copy/paste/run like this:

select

'ALTER TABLE '

+ quotename(object_name(object_id))

+ ' DROP COLUMN '

+ quotename(name)

from...

most users cannot run this unless you grant it explicitly either: (GRANT VIEW SERVER STATE TO [myDomain\developers]

)

SELECT client_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@SPID

is [Developers] a role, or a placehoder for your...

since you said the PartNumber is the first field, then yes; but it also depends on how selective that single column is.

if there's a lot of common values, SQL...

the issue is not the trigger, but the tables/objects the trigger is manipulating.

for example, if your trigger is inserting into master.dbo.MyAuditTable, you probably want to GRANT INSERT ON master.dbo.MyAuditTable TO...

Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.

Instead i started with a ...

at our shop, we use a lot of LINQ; generally, the developers write whatever they want, and if they hit a performance block, then that call gets modified to use...

like the error is telling you, because there are foreign keys in place, in this case you'll need to drop and recreate the foreign keys, i think; you can find...

Andrew in my shop, all databases on development boxes are switched over to simple recovery mode; i don't need a point in time restore on development that log backups would...

have you considered adding a full text index on the pdfs themselves? you'd obviously need to modify HOW you search after you have that in place.

first example i found when...

it's rare that a procedure explicitly names the database while in the same database; i really think it's affecting another database: this snippet from your proc really makes me think...

the procedure deleted from the database [HPApps], which i suspect is NOT the same db thatt proc exists in.

so if the produdure exists in [LocalDB], the permisisons chain is broken,and...

you have to alter your trigger. your staticly written trigger did not change to now match the new results from columns_updated() function

columns updated uses a map to say which columns...

Chris can you take a look at the specific stored proc that is raising the error?

ownership chaining is probably disrupted in this specific case.

you can get that error "The...

another issue is that query is going to use integer division and return incorrect totals

something in the query needs to be multiplied by 1.0 so that the datatype is expanded...

--

--fix any views that happen to have changes to their underlying tables they query from

declare c1 cursor for

select name from sys.views

open c1

fetch next from c1 into @viewname

While @@fetch_status <>...