I generally haven't much luck with the SQL Server sp's; I presume they act on the same data I can find in the system views / functions, but never what...

I use temp procedures for debugging purposes (for reports only, they don't modify data) at our customer sites. I just copy the object definition, modify the name, and I'm ready...

One benefit is that I can tell the constraints and/or indexes I create to support my customers vs. those they may have created. I have a highly varied customer base...

I typically follow this naming convention:

TableName_PK

TableName_FK01 etc.

TableName_CK01 etc.

similar with indexing:

TableName_CLIX

TableName_NCIX01 etc.

As far as typing, with copy / paste, or tools like Red Gate, not so much typing...

I could sleep at...

Personally, I name everything I can name ... makes queries of the system tables / views / functions easier to filter. Might also be unresolved control issues, though.

"Control your own...

Thanks for the quick response and (formerly unknown to me) information. I rarely use default syntax as I work with a variety of technical and non-technical personnel, and it seems...

I appreciate the reply, but it seems to be directed at how to retrieve dependencies rather than force them to be created.

Current indexes:

PK__TransEve__DF98CDDD2839B111UNIQUE CLUSTERED [nId] NULL

Seeks = 351616926Scans = 109342Lookups = 5

UX_TransEventsQueue__event_id ...

The error log has been reinitialized. See the previous log for older entries.

Logging SQL Server messages in file 'H:\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

Authentication mode is MIXED.

System Manufacturer: 'HP', System Model: 'ProLiant DL385 G5p'.

Server process...

Here's one (Kaspersky AntiVirus):

deadlock-list

deadlock victim=process5c1ddc8

process-list

process id=process5c1ddc8 taskpriority=0 logused=304 waitresource=KEY: 25:72057608316911616 (e41265cf7a76) waittime=914 ownerId=42667222210 transactionname=user_transaction lasttranstarted=2014-03-26T09:22:54.950 XDES=0x8c4675970 lockMode=X schedulerid=7 kpid=6228 status=suspended spid=364 sbid=0 ecid=0 priority=0...

I've done a similar thing, using a table variable; I do

INSERT INTO @Table (@TName,@CName)

SELECT N'XYZ',N'abc'

UNION ALL

SELECT N'XYZ',N'def'

UNION ALL

SELECT N'MNO',N'ghi'

<etc.>

then check if these values exist in the data dictionary.

What I'm hoping...

Grant,

Thanks for the info, I wasn't aware of that function (yes, I realize I should spend the time to look into all the DMV/DMF's).

BTW, whenever I'm confronted by an issue...

Thanks, I'll cook up a test on a much larger scale. I was hoping the "quick" test would show not only the operator difference but some indicator why the difference.

Thanks...

I think I found the problem -- I was running the script in one session, then checking the results in another.

~ Jeff

Other than missing the END statement (which exists later on in my script), I'm still not seeing anything incorrect.