Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Create Table on on database using sp_msforeachdb

Author  Topic 

jemacc
Starting Member

42 Posts

Posted - 2010-08-09 : 17:31:52
''?''

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-09 : 17:40:53
Use a WHILE loop instead.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-08-10 : 03:47:20
Also refer this
http://beyondrelational.com/blogs/madhivanan/archive/2008/05/13/simulating-undocumented-procedures.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-12-29 : 09:53:52
quote:
Originally posted by jemacc

''?''


What forced you to delete your question? [;]

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jemacc
Starting Member

42 Posts

Posted - 2010-12-29 : 10:19:02
I pasted over it in error.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-29 : 11:01:10
So put it back then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -