I have a global temporary table in SQL Server 2008 R2. I need a script generated the same way we generate the scripts through "Script table as" -> "Create to" in SSMS.
I didn't actually create the temporary table. I'm simply trying to use its schema to create a table so I can permanently store the data in my table during a transaction.