Jeff,

I just forgot that all the input parameters are optional except @strTableName parameter.   

& the snippet will only work if you have a static SQL...

In my case, i have to...

redirect the output to a text file which will let you know what exactly the problem is?

isql -Q"select * from table" -Sserver01 -dDatabase01 -E -oC:\isqlerror.txt

--Ramesh

Righly said... Even with limited & known no. of population groups, you cannot bury the features provided by the server........

Do you have any text/ntext columns in the table?

--Ramesh

Vijay,

You can debug the query by checking the authors.txt file.. It contains the vital error information

--Ramesh

The function @@ROWCOUNT is updated only and after every DML statement is execueted.. This function can be used in this way....

DECLARE @rc tinyint , @var varchar(50)

SELECT @var = emd.tpa_id from dbo.EMPLOYER_DIVISION...

Look at the following thread.....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=295213

--Ramesh

Thanks a lot. 

I used 4 different queries to get the desired results...and a lot more in other processes..

--Ramesh

By adding a column with def. value will only let you know when the record was inserted & not updated.. to achieve this you can add a timestamp column which will...

Avinash,

In current release, you cannot do this... But you can set triggers to do the job..

--Ramesh

what type of validations you want to do?

If you've a simple validations, you can always restrict the rows by having a WHERE clause..

Cursors will never perform better in most of...

Jeff,

Thanks for the query...

--Ramesh

You can use the sp_executesql stored procedure....

DECLARE @strSQL NVARCHAR(255)

DECLARE @strDBName SYSNAME

SET @strSQL = 'SELECT * INTO central.dbo.Table1 FROM ' + @strDBName + '.dbo.Table1'

EXECUTE sp_executesql @strSQL