| Author |
Topic |
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
 Posted - 2010-02-04 : 08:52:14
|
| The table design window is empty when I try to design a new one using the enterprise manager. Did somebody experience this one? Please help. Thanks in advance.For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 08:56:57
|
| why you need to do this from window.why cant you use t-sql create table? |
 |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-02-04 : 09:05:17
|
| The table design window is the much easier approach, though we can use the T-SQL create table. But, it is quite annoying and can loose patience sometimes. Especially when you're on hurry. I prefer using the design window most of the time.For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 09:15:15
|
| i always prefer create table statement |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-02-04 : 09:47:45
|
| Ok, that's youre preference. Have you encountered this problem?Anybody could help me plssss. thanks.For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-07 : 02:43:58
|
| Isn't the table designer supposed to be empty when you create a new table? Then you start typing in your columns.The "regulars" here are highly skilled in SQL Server, I doubt any/many of them are using the GUI tools for this type of job, so there may not be anyone around who knows much about it.Here's a question:How do you change the name of a Default Constraint in table designer? You can't (AFAIK), so if you copy a column from another table, and then change it as appropriate, it has a constraint name based on the table/column it came from - very confusing, and the sort of thing that full time DBAs like to be in control of and avoid!Personally I think those sort of issues have actually got worse over the versions ... |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-02-08 : 20:25:35
|
| I'm sorry...What I mean by "empty" in the table design is that... I have seen only white window, I can't type anything. No columns, no captions, no controls. A blank window with a white back ground.Just a comment, Its a matter of preferences. You are on a hurry, then if you feel doing the design using T-SQL by typing is much easy then that's fine. Writing T-SQL is a case-to-case basis, and I think those skilled ones are always looking for a fast approach..For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-09 : 09:12:48
|
I think the reason for creating scripts, rather that using GUI, is more likely to be because the DBA needs to have a set of scripts that can be applied to multiple databases.For example:Create script. Apply to DEV database.Discover a problem, restore from backup, modify the script, redo (with GUI you have to remember what you did before, and redo it from scratch - not very fast!)Then apply the scripts to a TEST / QA database for testingThen apply the scripts to a LIVE / PRODUCTION database.Using GUI for those last two steps is a) very error prone (you might forget a step) and b) slow  For us another benefit of scripts is that they are stored in our Revision Control System, so we have a "history" of any changes we made in case we need to go back and check how we got to where-we-currently-arehaving said that, I quite often use the GUI tools but NEVER save from there - instead I use the Generate Script button... except that SQL 2008 is generating lousy constraint names for scripts (compared to how SQL 2000 worked)Sorry, don't know why you are getting a blank popup window. Might windows be running out of resources? in which case a reboot should fix it. |
|
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-02-12 : 02:21:24
|
| Yah, as I have said, it's by preferences, a case-to-case basis approach.I already reboot but didn't solve the problem. :-(Let me try to install Service pack 4 for this. I get back the soonest..For fast result follow this...http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2010-02-12 : 13:03:36
|
| If the window is black you have an issue with your enterprise manager installation. Alternately you could have corrupt MMC on your workstation.try running it from another workstation.Also I reccomend aganst using a newer version of enterprise manager. on an older sql server.I saw some very wierd stuff.Think, databases getting thier data swapped. |
|
|
|
|
Table creation is blank