help with these query
-
im looking if exist Query do this 1-back up the database into specific path, 2-restore data from specific path. 3-return all of the user tables in specific database thx
-
im looking if exist Query do this 1-back up the database into specific path, 2-restore data from specific path. 3-return all of the user tables in specific database thx
Hi Ahmed, No, there doesnot exist any query for doing that. But you can do that using following commands: 1. Backup 2. Restore 3. select name from sysobjects where type = 'U' For details: http://msdn2.microsoft.com/en-us/library/ms186865.aspx[^] http://msdn2.microsoft.com/en-us/library/ms186858.aspx[^] http://www.windowsitpro.com/Articles/ArticleID/14375/14375.html?Ad=1[^] http://sqlserver2000.databases.aspfaq.com/how-do-i-get-a-list-of-sql-server-tables-and-their-row-counts.html[^] Hope that helps! Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.