meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | 3 hours ago | |
| stats | profile views | 31 |
|
1d |
comment |
Errors keeping stored procedures through restore from backup Why all the down votes, folks? Too wordy, or what? |
|
1d |
comment |
Errors keeping stored procedures through restore from backup We decided instead to keep an ALTER PROCEDURE script going with all the changes made to the stored procedures that haven't been pushed live. This runs after the restore of the databases. It's a bit more hands-on than I was hoping for, but it should work. This is basically your idea of using some sort of source control. |
|
1d |
accepted | Errors keeping stored procedures through restore from backup |
|
2d |
comment |
Errors keeping stored procedures through restore from backup Thanks for the response. Could you clarify a bit on the concatenation of Unicode and non-Unicode? The dev team has specifically asked for a fresher dataset more frequently. It doesn't have to be every day, though, so I may implement your suggestion of restoring to a different name, and then once a week or so change the names (assuming I don't find the actual problem, which seems increasingly likely). |
|
2d |
comment |
Errors keeping stored procedures through restore from backup @JonSeigel, I have run the step that generates the CREATE scripts and find no errors in them--but of course there is no guarantee that the script is exactly the same each time. |
|
Jun 14 |
comment |
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified It seems the program by default is supposed to use Microsoft OLE DB provider, which is MSDASQL. Where does postgresql enter into this? |
|
Jun 14 |
asked | Errors keeping stored procedures through restore from backup |
|
May 13 |
awarded | Caucus |
|
Apr 23 |
awarded | Yearling |
|
Apr 16 |
comment |
Referencing multiple tables from a single table and store additional data Do parts and tunings apply to specific cars at specific times? Do certain parts and tunings exist only in certain games, but cars exist across multiple games? I don't fully understand the system you are trying to describe. At first blush it seems like you might want a table that puts together a car with its tunings and parts on a specific date, record that date in TimeSet, and that should handle it. I rather suspect I'm missing something, though. |
|
Apr 3 |
comment |
Why should an application not use the sa account I'd be hesitant to buy anything from a bunch of guys who think it's OK to leave the keys to the kingdom sitting in a config file in plain text. I know it's not your call, but if you can get The Deciders to see what a terrible idea that is, and what it says about the vendor, that might help your case. |
|
Mar 20 |
comment |
big db for managing user files and settings Each file gets a new record added to user_file table. There's no issue with multiple users having files recorded in the same table, because each record has the user's unique ID number in it. |
|
Mar 19 |
comment |
Best relational database structure for this data For something like Word, isn't "execute" a permission? But I see your point if for some reason executing or accessing an application isn't considered a permission. |
|
Mar 19 |
revised |
Best relational database structure for this data grammar, wording |
|
Mar 19 |
answered | Best relational database structure for this data |
|
Mar 19 |
comment |
Best relational database structure for this data Sure, give me a minute or so. |
|
Mar 19 |
comment |
big db for managing user files and settings That is not even close to following to the relational model. If you intend to implement this in MySQL, you certainly aren't going to want millions of tables, all but one of them with one record each. You shouldn't have any issue with the three tables in my answer, each having millions of records each. |
|
Mar 19 |
comment |
big db for managing user files and settings Per-user tables? So adding a new user means adding two new tables? |
|
Mar 19 |
comment |
Best relational database structure for this data I'm not convinced that Roles_Applications is a real thing. Given that all permissions are application-specific, it seems there are Applications_Permissions (what you have labeled Permissions), which may then be assigned to specific roles via a record in Applications_Permissions_Roles. Roles_Applications, in fact, seems to be describing the most basic application permission--simple access. Or, it is asserting that a role has some level of permissions for an application, but you have to look elsewhere to determine which ones. |
|
Mar 19 |
comment |
big db for managing user files and settings Three separate databases? No, I wouldn't do that. I would just use the three tables above in a single database. |
