if i read youre request wrong, and you wanted to review the results of your trace, i use this:

--SELECT * from sys.traces

declare @TraceIDToReview int

declare @path varchar(255)

SET @TraceIDToReview = 3 --this...

Tripped over this same issue myself, even wrote an article about it long ago;

this is a much-improved-since-that-article version of a proc I've created this procedure named "sp_ScriptAnyTrace"

which scripts out...

Jim i am thinking something more like this, i think; i'd need the DDL and sample data to really make a solid mockup

CREATE VIEW VW_TimeSheetStatus

AS

SELECT

CASE

...

JimS-Indy (3/8/2013)

---

I have a TimesheetMaster table which requires 1 or more "approvals". I've created an eventlog table to keep track of approval events. Now, if any approver rejects a timesheet,...

from my snippets on finding dependencies for a specific column name;

SELECT

depz.referenced_schema_name,

depz.referenced_entity_name,

objz.type_desc,

colz.name AS ColumnName

FROM sys.sql_expression_dependencies depz

INNER JOIN sys.objects objz ON depz.referenced_id=objz.object_id

LEFT OUTER JOIN sys.columns colz ON objz.object_id =...

doing the alter database [dbname] set single_user with rollback immediate is great, but only if your connection is using the database.

if you are looping thru them all, i can...

Yes print messages are available as part of the. Net connection object but you have to add a event to it i believe in order to extract them. I have...

i believe he's not talking about the registry for installed machines, but rather the saved connections that SSMS might have connected with in the past.

those connections are stored in a...

maybe i'm reading the requirement differently;

it sounds like the Developer has db_ddladmin.

if the developer creates a new object, he of course has access to it, because he was the creator,...

interesting that it's different for the 4k sectors;

in your code, i guess you'll check the size,and if it is zero, try the 4k sector size method instead?

that'd work i...

sure: here's the same databases as a new backup, but placed on a disk with sector sizes of 512:

hope this helps!

CodeTestDBs-512.zip

this is a view that I create to show me all the extended properties:

CREATE VIEW VW_CURRENT_EXTENDED_PROPERTIES

AS

SELECT

'' AS...

easy peasy!

The error could be on my side, or maybe something is different on my backups that you should double check against.

!edit!

something i was thinking: my 2008/2008R2/2012 backups are...

tried your code, and it doesn't work on all situations;

it found SQL2005 as version 611 just fine, but only that for me.

For others(i have all on my dev machine), it...

if the view "dbo.myview" references any objects in another database, a linked server or a schema different than dbo, then that's breaking the cross database chain.

you said it was referencing...