Glad you got it back and working again.

Looks like you need to do some research on JOINS for starters.

http://www.sqlservercentral.com/stairway/75773/

What have you tried so far in getting your result?

whats the full error message from eventvwr?

17058 is usually cannot open a file, usually down to permission errors.

The fist link I detailed constains the information on this, but from a command prompt you want to run something like the below

net start MSSQL$INSTANCENAME -m"SQLCMD"

or

net start MSSQL$INSTANCENAME -m"Microsoft SQL...

this will get you your requirements

declare @tbl table (id int, nom varchar(20) ,actif bit )

INSERT @tbl values(1, 'un', 1)

INSERT @tbl values(2, 'deux', 0)

INSERT @tbl values(3, 'trois', 1)

INSERT @tbl values(3, 'quatre',...

I get what your trying to do, I just dont know how you are ending up with the replaced_replaced_replaced_dbname.

Something must be changing the search for and replace with parameters, why?

Pause all the passive nodes so SQL cannot fail over.

Then start SQL using -m and give it an application which you will connect with (Management studio or SQLCMD), as it...

I'm unsure on how it removed them from the server as it shouldn't and I just tested a simple transfer of 1 SQL and 1 Windows login no problem.

For transfering...

Only if you set the @SearchFor to a different value.

Can you post your full query and your expected outcomes.

As long as you can login to the Windows console session as an account which is in the Windows Administrators group you will be able to login to SQL.

It effectly...

Ensure you are an administrator of the Windows server where SQL is installed.

Start SQL in single user mode using the startup flag -m

Then you will be able to login to...

REPLACE will work with underscores

DECLARE @OrigString VARCHAR(100)

DECLARE @SearchFor VARCHAR(100)

DECLARE @ReplaceWith VARCHAR(100)

SET @SearchFor ='DBName'

SET @ReplaceWith = 'Replaced_DBName'

SET @OrigString = 'Newdb.[DBName].dbo.TableName'

SET @OrigString = REPLACE(@OrigString, @SearchFor, @ReplaceWith)

SELECT @OrigString

Sorry, think you got confused with what Gullimeel was asking.

Please detail the output of the sys.dm_db_index_physical_stats query

Also from your original select statement, how many rows did it return?

Also from my...

Something like this?

DECLARE @OrigString VARCHAR(100)

DECLARE @SearchFor VARCHAR(100)

DECLARE @ReplaceWith VARCHAR(100)

SET @SearchFor ='DBName'

SET @ReplaceWith = 'ReplacedDBName'

SET @OrigString = 'Newdb.[DBName].dbo.TableName'

SET @OrigString = REPLACE(@OrigString, @SearchFor, @ReplaceWith)

SELECT @OrigString