In general, you will detach a db when you want to disable, or otherwise curtail use of it.

This has the effect of "deleting" it from the server, without actually deleting...

re:

what i am trying to pull out is a dataset where I do not have duplicate records because, for example, the record has 'SS18' in code1 and 'SS18' in code3....

if present select the record. If not then check code2 for 'SS18' OR 'SS19'. If present then select the record. If not then check code3 for 'SS18' OR 'SS19' If...

This returns the 1st instance of 'SS18':

SELECT top 1 * FROM #REF

WHERE 'SS18' in (Code1, Code2, Code3)

Using Office 2007, one can:

- Install: 2007 Microsoft Office Add-in: Microsoft Save as PDF

- With plan displayed in MSMS, hit ALT-PrtSc

- Open new doc in MSWord 2007

- Hit Ctrl-V to...

I believe the Explanation here is more fundamental than "Stored procedure calls...", instead having to do simply with the declaration of the...

I think your prob is not in the SQL.

In MSMS, if you send your Results to Text, you get this:

1234567 89

123 ...

Do it in one operation:

EXEC sp_MSForEachTable 'ALTER TABLE ? ADD CONSTRAINT ck_FieldName CHECK...

I'm unsure what you were trying to achieve here, but your example lead me to this interesting phenom:

In effect, the statement:

SELECT @dummyvar = name FROM foo

acts like a...

You can use Query Analyzer(2000) to query 2005 dbs.

PaulB (7/6/2009)

:blink: do you mean... trash referential integrity?...

Sometimes a DBA's gotta do what a DBA's gotta do...

here's fast, less typing:

print ('1 ' + '2 ' + '3 ' + '4 ' +'...')

- Start Profiler

- File Menu / New Trace

- 'Events Selection' Tab

---- Uncheck all except Stored Procedures RPC: Completed (and maybe TSQL:SQLBatchCompleted )

---- Check 'Show all columns'

---- Ensure 'Text...

select substring ('ABC123',4,3)