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 30 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 768888
|
|
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 45 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 729275
|
|
|
Closed
as Fixed
|
|
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 231 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 350780
|
|
|
Closed
as Fixed
|
|
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 258 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 350772
|
|
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 273 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 329115
|
|
|
Closed
as Fixed
|
|
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 254 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 327960
|
|
|
Closed
as By Design
|
|
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 194 weeks ago) | 4 validations | 0 workarounds | 4 comments | feedback id: 257897
|
|
|
Closed
as Fixed
|
|
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 46 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 132269
|
|
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 46 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 124491
|
|
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 46 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 127102
|
|