Comments
Sort by recent activity
Thanks Eddie. I'll download the V6.5.2.18 very soon and start testing it against my current SQL (2000, 2005, 2008R2) in my DEV and my new SQL (2012) in sandbox. / comments
Thanks Eddie. I'll download the V6.5.2.18 very soon and start testing it against my current SQL (2000, 2005, 2008R2) in my DEV and my new SQL (2012) in sandbox.
Brian
As I have @ 104 SQL instances, is there a command line and/or batch method to register servers on that one centralized console? Modify backend data files, etc. to get all 104 SQL instances registered. Also, to add schedule backups, etc.? / comments
Brian
As I have @ 104 SQL instances, is there a command line and/or batch method to register servers on that one centralized console? Modify backend data files, etc. to get all 104 SQL instances r...
Maybe I can write remote command line calls from a server in each data center if no UI is available. / comments
Maybe I can write remote command line calls from a server in each data center if no UI is available.
Can I see all databases for servers placed into LOCATION(s) and/or GROUP(s)? And scheduled jobs too? / comments
Can I see all databases for servers placed into LOCATION(s) and/or GROUP(s)? And scheduled jobs too?
Thanks for suggestion. / comments
Thanks for suggestion.
David,
I was under impression Source Control scripts were OK for execution, and I have tested it as link to get scripts for all of my schema and objects into TFS source control, and as interface between TFS and SSMS.
Our standard is to use DROP & CREATE statement combinations, as opposed to ALTER. This factors into 'creation date' and system auditing. On the DBA team, when development (who owns the user databases) sends us a case to promote, we use the scripts that hopefully they are managing in TFS..
Will the Source Control tool be a stand along product, or a bolt-on for SQL Compare Pro?
- Regards,
Martin Graves
Database Technical Lead
Georgia-Pacific Building Products LLC / comments
David,
I was under impression Source Control scripts were OK for execution, and I have tested it as link to get scripts for all of my schema and objects into TFS source control, and as interface be...
"creation date and system auditing"
In the past, queries on the "sysobjects" table for the "creation" date have been utilized by auditors to track when objects changed in user database, then in turn look for change documentation for that object and date. No other date column in table works correctly (per MS). The ALTER by-passes this date field, therefore creating an untrackable event.
I haven't checked this fact using the newer 'system views' (sys.objects), but willing to be it is same. / comments
"creation date and system auditing"
In the past, queries on the "sysobjects" table for the "creation" date have been utilized by auditors to track when objects changed in user database, then in tur...
Thanks Colin and Chris. I will complete the installation manually, and test my SQL code that calls the backup. / comments
Thanks Colin and Chris. I will complete the installation manually, and test my SQL code that calls the backup.
http://apps.red-gate.com/messageboard/v ... php?t=9243
My instance is SQL 2000, so I couldn't load the SQL Server Compact Edition file into SSMS, so I renamed the troubled file. / comments
http://apps.red-gate.com/messageboard/v ... php?t=9243
My instance is SQL 2000, so I couldn't load the SQL Server Compact Edition file into SSMS, so I renamed the troubled file.
I tried the file rename. All is fine. Thank you for the response. / comments
I tried the file rename. All is fine. Thank you for the response.