I'd work in sp_msforeachdb as well as my favorite means to search all procedures:

SELECT * FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%INSERT%'

OR ROUTINE_DEFINITION LIKE '%UPDATE%'

i.e...

exec sp_msforeachdb 'INSERT #my_procedures (db_nm, procedure_nm)

SELECT ''?''...

I'd begin by deciding what columns have to match in order to consider two rows a duplicate of each other. Also ensure you have a candidate key in the...

There isn't one to my knowledge. From the GUI you can either go into the properties of the role or the properties of the object.

You sure you want to...

You can also go into report manager and use Upload File. Or enter the properties tab of a report and under General -> Report Definition click "Update" for existing...

There's a bunch of utilities that can do this for you. A google search for "decrypt stored procedure sql server" should yield results.

This should work...

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%mycolumn%'

I think you're confused about the licensing issue there Adam, you can run multiple instances on the same physical hardware without purchasing additional licenses. If you're using CALs, you...

The traditional way is to create a set of identical audit tables to those you are updating/deleting and create audit triggers... something like:

CREATE TRIGGER aud_myTable_upddel

ON myTable

AFTER UPDATE, DELETE

AS

IF @@ROWCOUNT...

There was a good article on consolidation on this site a while back. I'm sure if you searh for it you can find it.

I did a server consolidation project...

I'd be a little concerned if I were you. The key constraints are there to preserve data integrity. I'd recommend you fix your data first so that it...

Since you're posting in the SQL Server 2005 forum you should also consider using PIVOT to do this.

If you want to strip out the time, the fastest way (supposedly) is to do something like this...

DATEADD(dd, CONVERT(FLOAT, GETDATE()), 0)

I think that's what you're getting at...

Read up in BOL on how foreign key constraints work?

You're trying to do an insert to a table and violating the constraint listed there on the Building_Id column. Make...

I do something like this right now. You're going to want to query the following tables in your ReportServer database:

dbo.Catalog (contains report names and locations, as well as data...

Well, you need to create a column, create a key/certificate and create the procedures necessary to encrypt and decrypt the data in the column. I've found some good posts...