Search
SQL Server Home
DownloadsFeedbackSurveys
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 22 Previous 123 Next

1
0
Sign in
 to vote
Scripting a table with an ANSI default constraint of CURRENT_TIMESTAMP gives non-ANSI getdate() in the script - by John Paul Cook
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 9 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 781321  | 
Active
2
1
Sign in
 to vote
BOL states incorrect return datatype for CURRENT_TIMESTAMP, GETDATE, GETUTCDATE - by John Paul Cook
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 11 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 779097  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
 to vote
BOL providing bad advice about managing heap fragmentation - by John Paul Cook
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 114 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 587255  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
 to vote
SSMS Intellisense incorrectly reports that RENAME is not a valid event in a SQL Server 2008 database trigger - by John Paul Cook
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 93 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 577391  | 
Closed
as Fixed Help for as Fixed
4
7
Sign in
 to vote
a database restore does not restore all database settings such as TRUSTWORTHY - by John Paul Cook
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 12 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 193 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 482604  | 
Closed
as Fixed Help for as Fixed
0
0
Sign in
 to vote
trivial inconsistency about RANU in ConfigurationFile.ini - by John Paul Cook
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 189 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
not all links in the System Configuration Check Report are clickable, live links - by John Paul Cook
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 119 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 350089  | 
Active
0
0
Sign in
 to vote
Redistributable Features does not have anything under it - by John Paul Cook
From Connection: SQL Server
There isn't anything to select under Redistributable Features. Either provide something to select, have something checked and not enabled, remove it, or provide a few words explaining why something on…
Created on 6/9/2008 (updated 257 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 350082  | 
Closed
as By Design Help for as By Design
3
0
Sign in
 to vote
link in installation dialog warning box does not provide the promised information - by John Paul Cook
From Connection: SQL Server
A warning dialog box says to take a link to get information about opening ports in Windows Firewall. The link works, but the linked page does not provide any information about Windows Firewall ports. …
Created on 6/9/2008 (updated 145 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 350081  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 22 Previous 123 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement