Timeline for MS SQL Server: Dynamical create procedure / function / view / trigger in other database (sp_executesql)
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 27, 2023 at 20:12 | vote | accept | Thomas Franz | ||
| Jan 26, 2023 at 13:12 | comment | added | Thomas Franz |
@DanGuzman: you forgot point 5 where you don't know, which / how many databases are needed, so you can't hardcode the EXEC SomeOtherDatabase, because it could be any (even a database, that your coworker created 5 minutes ago)
|
|
| Jan 25, 2023 at 17:53 | comment | added | Dan Guzman |
You forgot to ask a question but I think you want EXEC SomeOtherDatabase.sys.sp_executesql @create_sql;
|
|
| S Jan 25, 2023 at 17:42 | answer | added | Thomas Franz | timeline score: 1 | |
| S Jan 25, 2023 at 17:42 | history | asked | Thomas Franz | CC BY-SA 4.0 |