Nested Fetching

Hi all!

I'm trying to write a T-SQL statement that will allow me to do a maintenance for all user table for all databases on my server.

This is what I got so far :


DECLARE @cStatement varchar(255)
DECLARE @dStatement varchar(255)

DECLARE T_database CURSOR FOR SELECT '[' + CONVERT(varchar(64),name) + ']' FROM master.dbo.sysdatabases WHERE dbid>6

SET nocount ON
OPEN T_database
FETCH NEXT FROM T_database INTO @dStatement
WHILE (@@FETCH_STATUS <> -1)
begin
-- LOOP IMBRIQUÉ POUR PASSER AU TRAVERS DE CHAQUES ELEMENTS
-- DE LA BASE DE DONNÉES ACTUELLE.
EXEC ('DECLARE T_cursor CURSOR FOR SELECT ''UPDATE STATISTICS ['' + CONVERT(varchar(64),name) + '']'' FROM ' + @dStatement + '.dbo.sysobjects WHERE type = ''U''')
OPEN T_cursor
FETCH NEXT FROM T_curosr INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
PRINT(@cStatement)
FETCH NEXT FROM T_cursor INTO @cStatement
end
DEALLOCATE T_cursor
FETCH NEXT FROM T_database INTO @dStatement
end

DEALLOCATE T_database


But I get a sh**t load of errors :


Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.
Msg 16916, Level 16, State 1, Line 15
A cursor with the name 'T_curosr' does not exist.


Please help!!!

:beer: