Look up sqlcmd in Books Online.

The command line argument you're loking for is "-h" the value you should supply is -1.

In a SQL Server database you basically store data in tables, so using a table for this kind of storage seems like the most logical solution.

A couple of hints: familiar...

Try this:

declare@querynvarchar(max)

set@query

= (

selectleft(Script.Query, len(Script.Query) - 9)

from(

selectScript.Query.query('Query').value('.', 'nvarchar(max)') as Query

from(

selectQuery

= N'

selectTABLE_CATALOG + ''.'' + TABLE_SCHEMA + ''.'' + TABLE_NAME collate Latin1_General_CI_AS as QualifiedObjectName

from'

+ sys.databases.[name]

+ '.INFORMATION_SCHEMA.TABLES

union all'

fromsys.databases

for xml path(''), type

) Script (Query)

)...

Single characters and most symbols are excluded from full-text indexing. Most of them are listed as "noise words" (look them up in Books Online) and are listed in noise-word files...

Changing the isolation level of a transaction to SNAPSHOT will cause an exception.

Repro:

-- step 1 start

create databaseSnapshotPromotion

go

alter databaseSnapshotPromotion

setallow_snapshot_isolationon

go

alter databaseSnapshotPromotion

setread_committed_snapshoton

go

useSnapshotPromotion

go

create tabledbo.test

(

cint

)

go

-- step 1 end

-- step 2 start

settransaction isolation level read committed

begin...

Turning ANSI_WARNINGS off should not be a permanent solution. ANSI warnings prevent data corruption that may be caused by inconsistent use of data types (e.g. truncation) and operations where divide-by-zero...

Answers inline.

Carl B. (4/21/2009)

---

Hi Matija,

I don't suggest to set these database settings at connection time. I wrote : "I ask this question because our ALTER DATABASE statements are not...

Are you suggesting setting these database settings whenever you connect to the database? That's not necessary. You should set this when the database is created, and only use those that...

You're using DTS on SQL 2005? Any special reason?

With SSIS you can redirect error rows in the Data Flow Source.

IMHO, if "getting through the project" is the goal then why...

What's the data type of the MCTR_ENTITY column?

Is this a typo?

The values are the same.

Are there any triggers on that table?

As stated in the error message, you cannot drop an index that is being referenced by a foreign key constraint.

You need to drop all constraints referencing the index before you...

What does the dbo.Eur_RMISWebInterface_GetProductImagesForWeb procedure do?

No problem. 🙂

Post Back and let us know how you get on!

I am not aware of such a limitation but it would seem that indexes on computed columns are not supported by FTS.

Is there another unique column that you can use...

You can join the two tables and use a CONTAINS predicate on each of them with the same search argument.

E.g.:

select<column list>

from<table 1> t1

<inner or outer?> join<table 2> t2

ont2.<common key> =...