Best Of
PE006 (TABLE HINT is used)
Would like this to be more granular.
When doing reporting I use the WITH (NOLOCK) to avoid locks on tables.
I would like to be able to disable specific warnings about specific hints.
When doing reporting I use the WITH (NOLOCK) to avoid locks on tables.
I would like to be able to disable specific warnings about specific hints.
BrienKing
2 ·
Re: Which Windows Server versions and MSSQL versions does SQL Backup ver 9.2.1.128 support?
Hi @sbs
Thanks for your post.
You can find all of the information on the release notes and documentation for SQL Backup in my linkn below.
https://documentation.red-gate.com/sbu9/release-notes-and-other-versions
Kind regards
Thanks for your post.
You can find all of the information on the release notes and documentation for SQL Backup in my linkn below.
https://documentation.red-gate.com/sbu9/release-notes-and-other-versions
Kind regards
RichardL
1 ·
Re: Managed Develop & Stage environments with a shared database model
One thing you could do is select the dedicated option even though you are using shared. For various complicated technical reasons it will probably work fine. In order to explain that it might be worth actually scheduling a skype call to talk through it.
However, it's ugly and smelly and you should just move to the dedicated model.
However, it's ugly and smelly and you should just move to the dedicated model.
AlexYates
1 ·
Re: Not getting update scripts from DLM release
Maybe this is a silly question, but have you made any changes or are the source package and target database already in an identical state?
AlexYates
1 ·
Re: BUG! 7.1.18 - "OLDER" DOES NOT WORK ANY MORE!
Older_1.png shows GROUPED alerts - 3 in the first, 1 in the second.
When I select the LAST ONE, Older_2.png shows "Newer" is greyed-out.
According to your post, it ought not be...
Older_3.png is the first in a list of 24 total alerts in 23 groups. It is a singleton. It is incapable of being navigated away from using the "Older" link - greyed-out. The next in the list is also a singleton. There is but ONE Alert that is a set of two grouped items.
IMO, page size when viewing a detail record is utterly irrelevant, particularly when that record is a singleton...
Please fix this for everyone else - I have turned off the unwanted, unwarned, undesirable, group "feature", so I don't need a fix.
When I select the LAST ONE, Older_2.png shows "Newer" is greyed-out.
According to your post, it ought not be...
Older_3.png is the first in a list of 24 total alerts in 23 groups. It is a singleton. It is incapable of being navigated away from using the "Older" link - greyed-out. The next in the list is also a singleton. There is but ONE Alert that is a set of two grouped items.
IMO, page size when viewing a detail record is utterly irrelevant, particularly when that record is a singleton...
Please fix this for everyone else - I have turned off the unwanted, unwarned, undesirable, group "feature", so I don't need a fix.
PDinCA
1 ·
Re: T-SQL: Creating a (not quite) duplicate row
Hi Sean,
Probably the best place to ask would be the SQL Server Central forums - this is the forum for our SQL Clone product.
Owen
Probably the best place to ask would be the SQL Server Central forums - this is the forum for our SQL Clone product.
Owen
owen.hall
1 ·
Re: SQL query profiling disabled in trial version
I realize that the application I am running uses a proprietary database access layer which might not be written in .NET, which could be the problem.
csharper
1 ·
Error: Invalid numeric precision/scale on data compare
I'm using the following command to sync a database to a scripts folder :
- sqldatacompare.exe /s1:Computer /db1:DB /makescripts:"c:\Scripts" /verbose /sync
This works fine.But when I try a compare of the DB database to the scripts generated previously I get the following error : invalid numeric precision/scale
This is the compare command:
- sqldatacompare.exe /s1:Computer /db1:DB /scripts2:"c:\Scripts" /verbose
I've also tried from the GUI to create a project but the same error appears.Please note that this is run on a controlled environment and no changes are made to the DB database.Also when comparing the scripts with the database (switch the source and destination) I get no errors and it works as expected(no differences). Also please note that most of the tables that give the error (I didn't check them all) have columns that are defined as custom types.
- sqldatacompare.exe /s1:Computer /db1:DB /makescripts:"c:\Scripts" /verbose /sync
This works fine.But when I try a compare of the DB database to the scripts generated previously I get the following error : invalid numeric precision/scale
This is the compare command:
- sqldatacompare.exe /s1:Computer /db1:DB /scripts2:"c:\Scripts" /verbose
I've also tried from the GUI to create a project but the same error appears.Please note that this is run on a controlled environment and no changes are made to the DB database.Also when comparing the scripts with the database (switch the source and destination) I get no errors and it works as expected(no differences). Also please note that most of the tables that give the error (I didn't check them all) have columns that are defined as custom types.
stefan.r
1 ·
