<div>
what about using sp_MSForeachDB?<br />
here a small sample:<br />
<br />
exec sp_MSForEachDb ' select * from ?..sysfiles '
</div>


what about using sp_MSForeachDB?
here a small sample:

exec sp_MSForEachDb ' select * from ?..sysfiles '

<div>
agree 100% with angelIII- he got me on these... take a look at <a href="http://www.databasejournal.com/features/mssql/article.php/3441031" rel="ugc">http://www.databasejournal.com/features/mssql/article.php/3441031</a><br />

</div>


agree 100% with angelIII- he got me on these... take a look at http://www.databasejournal.com/features/mssql/article.php/3441031 [http://www.databasejournal.com/features/mssql/article.php/3441031]


<div>
Fine.<br />
But there are are several files for each database and i need to build the attach command with all the file names in one line.
</div>


Fine.
But there are are several files for each database and i need to build the attach command with all the file names in one line.

<div>
you could cal commands, what is the script you want t use
</div>


you could cal commands, what is the script you want t use

<div>
the script is as follows:<br />
sp_attach_db @dbname = N'dbname' , @filename1 = N'db &nbsp;file path' @filename2 = N'db &nbsp;file path', @filename3 = ........<br />

</div>


the script is as follows:
sp_attach_db @dbname = N'dbname' , @filename1 = N'db  file path' @filename2 = N'db  file path', @filename3 = ........


<div>
Thanks angelIII - my email stopped and did not get notified 
</div>


Thanks angelIII - my email stopped and did not get notified

<div>
<div class="content wysiwyg-content">
I have a cursor loop on sysdatabases and i need to query the sysfiles table for each database in system to build an attach script for all databases.<br />
How can i switch the current database dynamicaly inside the cursor. Use keyword doesn't work
</div>
</div>


I have a cursor loop on sysdatabases and i need to query the sysfiles table for each database in system to build an attach script for all databases.
How can i switch the current database dynamicaly inside the cursor. Use keyword doesn't work

How to switch database dynamicaly in T-sql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.