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.
| Author |
Topic |
|
pdube
Starting Member
2 Posts |
 Posted - 2012-02-28 : 10:06:10
|
| Hi,I am running Windows 7 with SQL Studio 2008 and am trying to generate scripts from a 2008 R2 database. I get no result, no error message. I have no problem generating scripts from databases on other SQL servers.When I go onto that specific server and generate the scripts from there it works fine.What's wrong? |
|
|
pdube
Starting Member
2 Posts |
Posted - 2012-02-28 : 10:51:05
|
| I just found the error: I was trying to generate only the indexes on all tables, but if you set "Script CREATE" to False nothing gets generated. I thought it meant "CREATE TABLE" but it seems it also means "CREATE INDEX"...So it looks like I have no way of generating only an indexes creation script. |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-02-28 : 10:56:00
|
| If you only want to script out the indexes you can use PowerShell for that----------------------------Junior DBA learning the ropes |
|
|
|
|
|
|
Generate Scripts does nothing