If u can have down time for the current database then try detach and attach

it will be easy and fast

Try This....

Say we have a table with 1000 rows
and there is no column which can identify a row(i mean no Identity or unique column)

now if we want to select a set of rows from this table how can we do that?...

change the query from where class and see


FROM dbo.AccountTypes
INNER JOIN dbo.Users AS c ON dbo.AccountTypes.AccountIndex = c.AccountIndex
INNER JOIN dbo.BillingTransactions ON c.UserIndex...

DB mirroring means what ever changed you do on primary DB will also get applied on Mirror Databases

that includes DB structure and data

ID_short is a truncated version of ID_Long

say if ID_short has limited number of characters,then u can use
ID_short=substring(id_Long,X,Y)
or
ID_short=left/right(id_Long,X)

Hey,

i didn't get you but from what i understood

don't u think these 4 statements are not similar

FILENAME LIKE ''%'+ @FILENAMETEXT +'%''
FILENAME LIKE '+ @FILENAMETEXT +'%''
...