select 
	[Name]
into
	[C:\INETPUB\WWWROOT\SERVICEMANAGER\SERVICE\APP_DATA\SERVICEMANAGER.MDF].[dbo].[Client] 
from
	[C:\INETPUB\WWWROOT\SERVICEMANAGER\APP_DATA\ASPNETDB.MDF].[dbo].[Client]

yields:

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Client' in the database.