InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 16:07:48 GMT20http://www.sqlservercentral.com/Forums/Topic1404610-392-1.aspx[quote][b]John Mitchell-245523 (1/9/2013)[/b][hr]The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:[code="sql"]SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME LIKE '#temp%'[/code]John[/quote]Ooppss.....My Apologies.Wed, 09 Jan 2013 03:45:40 GMTShadab Shahhttp://www.sqlservercentral.com/Forums/Topic1404610-392-1.aspxThe your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:[code="sql"]SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME LIKE '#temp%'[/code]JohnWed, 09 Jan 2013 03:23:48 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1404610-392-1.aspx[quote][b]John Mitchell-245523 (1/9/2013)[/b][hr]The error is occurring in the stored procedure itself. Do you get the same error if you run just the EXEC line?John[/quote]No, it is not giving me the error it is actually giving me the result of sp_spaceusedWed, 09 Jan 2013 02:44:50 GMTShadab Shahhttp://www.sqlservercentral.com/Forums/Topic1404610-392-1.aspxThe error is occurring in the stored procedure itself. Do you get the same error if you run just the EXEC line?JohnWed, 09 Jan 2013 02:29:35 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1404610-392-1.aspxHi all,I am trying to stored the output of sp_spaceused into a temp table as follow.[code="sql"]if exists (select 1 from sys.objects where object_id=OBJECT_ID(N'#TEMP'))create table #temp (name nvarchar(50),rows nvarchar(50),reserved nvarchar(50),data nvarchar(50),index_size nvarchar(50),unused nvarchar(50))insert into #temp exec sp_spaceused 'dbo.Emp'[/code]i am getting the error as below[code="sql"]Msg 8114, Level 16, State 1, Procedure sp_spaceused, Line 178Error converting data type varchar to int.[/code]Now if we observed closely in my temp table there isn't any column with datatype as int.So i am not able to figure it out, why is it trying to convert the column to int when it can stored it nvarchar.Wed, 09 Jan 2013 02:24:24 GMTShadab Shah