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

1
0
Sign in
to vote
From Connection: SQL Server
Scripting an object fails with "Syntax error in TextHeader of StoredProcedure". Cause is /* */ comments preceding the 'Alter procedure' statement. SQLSyntax is Ok, but SMO cannot script it. Tes…
Created on 10/3/2014 (updated 3 weeks ago) | 1 validation | 1 workaround | 0 comments | feedback id: 990342  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Altough I get to see equal values from both sources for the columns query_plan_hash and query_hash , the query does not evaluate them as being equal ! Microsoft SQL Server 2014 - 12.0.2402.0 (X64) …
Created on 9/9/2014 (updated 6 weeks ago) | 0 validations | 1 workaround | 1 comment | feedback id: 967422  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Select * from sys.dm_os_performance_counters only shows rows for XTP objects ! e.g.: object_name counter_name instance_name cntr_value cntr_type XTP Transaction Log Log records written/sec GNKD002 …
Created on 8/19/2014 (updated 9 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 950071  | 
Active
4
0
Sign in
to vote
From Connection: SQL Server
SMO.script does not script a trigger state. Disabled triggers are not put back in a disabled state ! A table trigger that has been disabled, will become enabled and remain enabled when this script is …
Created on 5/5/2014 (updated 2 days ago) | 1 validation | 1 workaround | 0 comments | feedback id: 867404  | 
Closed
as Fixed Help for as Fixed
5
0
Sign in
to vote
From Connection: SQL Server
We collect system health information on a regular basis. I noticed this generates a record in the SQLServer errorlog file every time this query is executed. -- Fetch the Health Session data SELECT …
Created on 6/6/2013 (updated 1 week ago) | 2 validations | 0 workarounds | 4 comments | feedback id: 789617  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
From Connection: SQL Server
OBJECTPROPERTY function doesn't work using 3-part object naming outside of the current db. I've tested it with sysadmin auth, still it doesn't produce the expected results.
Created on 9/21/2012 (updated 90 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 763985  | 
Closed
as By Design Help for as By Design
2
0
Sign in
to vote
From Connection: SQL Server
sys.dm_server_services producing buggy data for cluster_nodename when is_clustered is added to the select list. Select * from sys.dm_server_services shows correct content.
Created on 7/5/2012 (updated 70 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 752408  | 
Closed
as Duplicate Help for as Duplicate
18
0
Sign in
to vote
From Connection: SQL Server
A merge statement that merges rows from two table variables fails. (Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.) The sa…
Created on 7/30/2010 (updated 74 weeks ago) | 7 validations | 1 workaround | 5 comments | feedback id: 581548  | 
Closed
as Fixed Help for as Fixed
0
2
Sign in
to vote
From Connection: SQL Server
1) I create a user without login. (and add it to db_datareader/db_datawriter) 2) I create a sproc using "with execute as sqluser" 3) exec sproc results in "Msg 8152, Level 16, State 2, Procedure usp_I…
Created on 2/1/2010 (updated 241 weeks ago) | 0 validations | 2 workarounds | 2 comments | feedback id: 529771  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
to vote
From Connection: SQL Server
I a windows login is member of a windows group that is member of the public db-role, when that login is logged in using windows authentication, that login can execute USE [master] GO CREATE LOGIN […
Created on 10/5/2007 (updated 363 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 302871  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 16 Previous 12 Next