Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by John Paul Cook for this product (signing in could show even more results)
Showing 1 - 10 of 24 Previous 123 Next

1
0
Sign in
to vote
From Connection: SQL Server
The June 2013 build of SSDT will not show trigger differences when trigger is the only object type selected for a schema comparison.
Created on 7/3/2013 (updated 52 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 792484  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
SET FIPS_FLAGGER is not flagging certain non-ANSI statements. Additionally, SET FIPS_FLAGGER 'FULL' is flagging less than SET FIPS_FLAGGER 'INTERMEDIATE'.
Created on 5/28/2013 (updated 56 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 788759  | 
Resolved
as Won't Fix Help for as Won't Fix
3
0
Sign in
to vote
From Connection: SQL Server
If you use DEFAULT CURRENT_TIMESTAMP when creating a table, when you use SSMS to script the table, the script contains the non-ANSI getdate() instead of the ANSI CURRENT_TIMESTAMP. If I go to the tro…
Created on 3/13/2013 (updated 12 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 781321  | 
Active
2
1
Sign in
to vote
From Connection: SQL Server
Books Online incorrectly states that CURRENT_TIMESTAMP "Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offse…
Created on 2/12/2013 (updated 76 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 779097  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
http://msdn.microsoft.com/en-us/library/ms188917.aspx says "To reduce the extent fragmentation of a heap, create a clustered index on the table and then drop the index." Paul Randal says "Myth #29:…
Created on 8/18/2010 (updated 179 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 587255  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
Using SSMS 2008 R2 pointing to a SQL Server 2008 database, the DDL event RENAME has red squigglies with a mouseover message of 'RENAME' is an invalid event type.
Created on 7/22/2010 (updated 159 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 577391  | 
Closed
as Fixed Help for as Fixed
4
7
Sign in
to vote
From Connection: SQL Server
It is by design (we all understand this) that the following three properties are not restored after a database restore: is_broker_enabled is_honor_broker_priority_on is_trustworthy_on Again,…
Created on 4/15/2010 (updated 78 weeks ago) | 0 validations | 0 workarounds | 5 comments | feedback id: 551695  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
sys.sysobjects BOL is incomplete - by John Paul Cook
From Connection: SQL Server
BOL for sys.sysobjects is incomplete. The following types are not documented: IT SN SQ
Created on 8/12/2009 (updated 259 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 482604  | 
Closed
as Fixed Help for as Fixed
0
0
Sign in
to vote
From Connection: SQL Server
There is a trivial inconsistency between the comment line and the ENABLERANU setting. Here is the relevant snippet: ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="True"
Created on 8/15/2008 (updated 254 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 362006  | 
Closed
as Won't Fix Help for as Won't Fix
0
0
Sign in
to vote
From Connection: SQL Server
The System Configuration Check Report has a mixture of links as text and as actual clickable links. I know this is a trivial point.
Created on 6/9/2008 (updated 184 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 350089  | 
Active
Showing 1 - 10 of 24 Previous 123 Next