BCP OUT tables from any database

/*

exec dbo.spo_bcpout

EXECUTE THIS SCRIPT TO CREATE TABLE BEFORE EXECUTING THE PROCEDURE FOR FIRST TIME.
THIS TABLE WILL STORE ALL THE TABLE NAMES WHICH HAS TO BE BCP OUT FROM ANY DATABASE.


CREATE TABLE [bcp_tables] (
[tablename] [varchar] (200) NOT NULL 
) ON [PRIMARY]


*/
CREATE PROCEDURE dbo.spo_bcpout as

SET NOCOUNT ON

SET QUOTED_IDENTIFIER OFF

DECLARE  @tblvar_tablename TABLE (srno INT identity , tablename VARCHAR(200))

DECLARE @totcnt INT
DECLARE @cnt INT
DECLARE @sqry NVARCHAR(4000)
DECLARE @tblname VARCHAR(200)
DECLARE @FileName VARCHAR(50)

INSERT INTO  @tblvar_tablename
SELECT * FROM dbo.bcp_tables 
----where tablename like '%author%'

SELECT @totcnt = COUNT(*) FROM @tblvar_tablename
SET @cnt = 0

WHILE ( @cnt < @totcnt )
BEGIN
SET @cnt = @cnt + 1

SELECT @tblname = LTRIM(RTRIM(ISNULL(tablename,''))), 
               @sqry = 'bcp "SELECT * FROM PUBS..'+LTRIM(RTRIM(ISNULL(tablename,'')))+'" queryout  "'
FROM  @tblvar_tablename WHERE srno = @cnt



SET @tblname = 'c:\'+@tblname+'.txt'

SELECT  @sqry = @sqry + @tblname + ' "  -Uusername -Ppassword -c -o c:\output.txt '

EXEC master..xp_cmdshell @sqry

END