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 Louis Davidson for this product (signing in could show even more results)
Showing 1 - 10 of 20 Previous 12 Next

1
0
Sign in
to vote
From Connection: SQL Server
Some of the the code sample include smart quotes, which makes it impossible to run: Select * from SYSTEMRESTRICTSCHEMA ($System.Discover_csdl_metadata, [catalog_name] = ’Adventure Works DW’)
Created on 10/26/2012 (updated 71 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 768888  | 
Closed
1
0
Sign in
to vote
From Connection: SQL Server
In a procedure, using code: return (select next value for FirstSequence); Causes an error that does not reference the RETURN clause of a procedure, but rather lists a lot of other (relevant) places…
Created on 3/6/2012 (updated 127 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 729275  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
When an error message about missing column stats is returned, an order by on the query eliminates the rows being returned in Management Studio.
Created on 6/12/2008 (updated 313 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 350780  | 
Closed
as Fixed Help for as Fixed
1
1
Sign in
to vote
From Connection: SQL Server
When an dependent procedure exists, but has missing referenced columns, 207 messages are interspersed in the returned data. I don't like the 2020 error messaes in there eithe, but this seems to b…
Created on 6/12/2008 (updated 340 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 350772  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
The result set description of sys.fn_get_audit_file for the succeeded column states: Indicates whether the action that triggered the event succeeded. Is not nullable. But it returns 1 for all p…
Created on 2/18/2008 (updated 355 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 329115  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
select object_name(object_id), name from sys.columns Should only return columns that the user has rights to. Currently it returns all columns in tables that the user has rights to
Created on 2/9/2008 (updated 336 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 327960  | 
Closed
as By Design Help for as By Design
3
0
Sign in
to vote
From Connection: SQL Server
When a user has rights to update one column in a table via a column permission, it works with one table, but not when the table is involved in a join. So: update p set age = 40 from trs.dbo.p…
Created on 2/14/2007 (updated 276 weeks ago) | 4 validations | 0 workarounds | 4 comments | feedback id: 257897  | 
Closed
as Fixed Help for as Fixed
1
0
Sign in
to vote
From Connection: SQL Server
I upgraded 2 servers over the past weekend, and when I went to recreate some jobs that I had created on my test server (which was a fresh install of 2005 and immediate add of SP1) it failed with: M…
Created on 6/12/2006 (updated 128 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 132269  | 
Active
5
0
Sign in
to vote
From Connection: SQL Server
When database is in standby mode after a restore, sys.database_files (and sys.sysfiles) does not match sys.master_files. Database files contains the file names from the database being restored. Mast…
Created on 5/23/2006 (updated 128 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 124491  | 
Active
0
1
Sign in
to vote
From Connection: SQL Server
On a slow connection, I right clicked on a server in the registered server pane, chose configuration manager and a message in a typical system messagebox, not one of the VS style messages with extra i…
Created on 1/28/2006 (updated 128 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 127102  | 
Active
Showing 1 - 10 of 20 Previous 12 Next