Viewing 3 posts - 1 through 3 (of 3 total)
I think this line from SQL Server HELP provides answer. It was a suprise to me. It seems that nvarchar(20) is a different type than nvarchar(26). Interesting at the least....
September 13, 2004 at 8:14 am
#522757
Try to use dynamic sql for this. For example create such a stored procedure
CREATE PROCEDURE rp_Table
@TableName nvarchar(100)
AS
DECLARE @sql nvarchar(4000)
SET @sql = 'SELECT * FROM ' + @TableName
-- print @sql
EXEC sp_executesql ...
April 27, 2004 at 7:26 am
#504326
It is not possible to use Reporting Services with MSDE.
February 20, 2004 at 12:16 am
#494866