Home Dashboard Directory Help
Search
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 Wayne Sheffield for this product (signing in could show even more results)
Showing 1 - 10 of 12 Previous 12 Next

2
1
Sign in
to vote
From Connection: SQL Server
If you create a job with a step that has an on-success action of going to a non-existent step, when you view the job in SSMS it incorrectly shows the step's on-success action to "Go to the next step".…
Created on 11/7/2013 (updated 19 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 807996  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The sys.dm_exec_sessions DMV does not have documentation for the database_id and open_transaction_count columns returned by the DMV in BOL (http://msdn.microsoft.com/en-us/library/ms176013.aspx)
Created on 12/31/2012 (updated 80 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 775508  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
In the BOL for sp_help_job (http://msdn.microsoft.com/en-us/library/ms186722.aspx) it states that you must provide either @job_id or @job_name, but not both. Actually, you can supply no parameters to …
Created on 11/28/2012 (updated 85 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 772627  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
sys.server_principals BOL for SQL 2012 (http://msdn.microsoft.com/en-us/library/ms188786.aspx) does not include newly added columns owning_principal_id and is_fixed_role.
Created on 10/17/2012 (updated 91 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 767805  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
Go to Next Bookmark skips bookmarks after Clear Bookmark clears the current bookmark.
Created on 6/8/2012 (updated 74 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 747722  | 
Closed
1
0
Sign in
to vote
From Connection: SQL Server
On the BOL page for Aggregate Functions (http://msdn.microsoft.com/en-us/library/ms173454.aspx), there is a table of aggregate functions. On this same page is a tree view navigation pane on the left s…
Created on 4/1/2012 (updated 113 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 734976  | 
Closed
as Fixed Help for as Fixed
14
0
Sign in
to vote
From Connection: SQL Server
When using the AdventureWords2008R2 database from codeplex, a query that uses the LAST_VALUE() function returns a different result depending on whether it is used from within a cte or not. (FIRST_VALU…
Created on 12/9/2011 (updated 133 weeks ago) | 4 validations | 0 workarounds | 2 comments | feedback id: 712918  | 
Closed
as Duplicate Help for as Duplicate
1
0
Sign in
to vote
From Connection: SQL Server
When running an update statement on 1 million rows of the form set @variable = column = expression, the writes are not being calculated in profiler. Additionally, some of the ROWS|RANGE options of t…
Created on 8/23/2011 (updated 64 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 685241  | 
Closed
as Won't Fix Help for as Won't Fix
3
1
Sign in
to vote
From Connection: SQL Server
When you set the default location for a new database data/log file, this information is not used until the server is restarted, even though SSMS reports that this is the running value. Note: read dis…
Created on 12/22/2010 (updated 183 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 633050  | 
Closed
as Won't Fix Help for as Won't Fix
4
1
Sign in
to vote
From Connection: SQL Server
The cast/convert function inconsistently truncates strings when converting to different data types. DECLARE @ID NVARCHAR(MAX) = N'0E984725-C51C-4BF4-9960-E1C80E27ABA0wrong'; select @ID, CONVERT(uniq…
Created on 10/12/2010 (updated 173 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 612923  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 12 Previous 12 Next