The script generator associates the permissions with the object scripts. So, when you are generating you script of the objects, you have to be sure to set the Include...

My guess would be that something is using the table and has a schema lock on it as a consequence (note that opening the table, or opening the designer on...

Are you receiving any messages? Anything in the system event log, or the SQL Server log?

dnlandes (9/30/2008)

---

With this data and this map I get all the info in a table. Yay! But It puts OfficeTradingAs on one row then moves to the next row and...

Just to clarify some stuff that may not have been clear:

1) This is a vendor-product generated query, I cannot rewrite it. I have sent suggestions to the vendor...

SSMS (Management Studio) uses SMO (SQL Management Objects) directly, so the SMO libraries are installed anywhere that SSMS can run.

If you are doing development, you might need a separate SDK,...

GilaMonster (10/7/2008)

---

That query still can't use any indexes due to the leading wildcards on almost all of the filters.

Do your users really enter middle portions of account numbers, phone numbers...

If this is for SQL Server 2000, then you have posted it in the wrong forum as this is a SQL Server 2005 forum. Nonetheless, since it is already...

Much better, thanks.

Just checking: is this really for SQL Server 2005 and not SQL Server 2000?

Andrew Gothard (10/6/2008)

---

Adding indexes to the system would not be an option for a couple of reasons;

1) If - as is extremely likely - the app's a...

This is just a copy of what you had in your original post, it is not useable.

Please see this link for more information on how to ask for help in...

No. You can update all of the fields in a table at once, but you do need a separate Update statement for each different table.

this should make it easier:

SELECT o.name as TableName, c.name as ColumnName, i.name as IndexName

, o.schema_id, i.object_id, c.column_id, i.index_id

, i.type_desc as IndexType, ic.is_included_column

FROM (sys.columns c

Join sys.objects o ON c.object_id =...

You just need to filter the trace correctly. Once you do that, the trace will produce no more data than a TRIGGER ON SELECT would.

Yes, multiple update statements inside a single transaction.

Alternatively, write a stored procedure to do this, and pass your array in as an XML variable.