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

1
0
Sign in
to vote
From Connection: SQL Server
DBCC OPENTRAN( 0 ) is often used to determine if there are any open transactions and who has the oldest one. BOL shows it is not deprecated. Doesn't work unless there has been a none-XTP transaction
Created on 12/16/2013 (updated 35 weeks ago) | 0 validations | 1 workaround | 2 comments | feedback id: 811662  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
The repro attached simulates a situation where there are many updates to the same non-durable table (SCHEMA_ONLY). The key is the output of sys.dm_db_xtp_table_memory_stats which is either misleading…
Created on 12/9/2013 (updated 36 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 811103  | 
Active
17
0
Sign in
to vote
From Connection: SQL Server
SQL Agent Jobs and Maint plans are not editable when using SP2 tools against servers with a server name > 30 characters. After creating a job, trying to double click or script the job SSMS gives a …
Created on 4/25/2007 (updated 284 weeks ago) | 5 validations | 0 workarounds | 2 comments | feedback id: 273298  | 
Closed
as Fixed Help for as Fixed
11
0
Sign in
to vote
From Connection: SQL Server
CHECKDB does not interact with BEGIN TRY, by that I mean that if the database has a corruption and checkdb is run outside the begin try block then you get @@ERROR set to 8939. Eg. this is fine... …
Created on 3/7/2007 (updated 233 weeks ago) | 5 validations | 1 workaround | 7 comments | feedback id: 262129  | 
Closed
as Won't Fix Help for as Won't Fix
30
1
Sign in
to vote
From Connection: SQL Server
If you create a maintenance plan and use the 'Check Database Integrity' task and selecting multiple / all databases. If you then run the saved plan the plan only ever checks the master database - you …
Created on 3/7/2007 (updated 384 weeks ago) | 6 validations | 1 workaround | 2 comments | feedback id: 262122  | 
Closed
as Fixed Help for as Fixed
110
0
Sign in
to vote
From Connection: SQL Server
According to BOL sysprocesses system view is on its way out of the product. The column (there may be others) dbid in sysprocesses can not be determined through the execution DMV's. sys.dm_exec_r…
Created on 2/11/2007 (updated 15 weeks ago) | 16 validations | 1 workaround | 17 comments | feedback id: 257502  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
Running sp_help on the following table returns a length of -1 for the description column which is definied as varchar(max); this is not documented in books online; if this is by design then a referenc…
Created on 2/8/2007 (updated 348 weeks ago) | 2 validations | 0 workarounds | 2 comments | feedback id: 257017  | 
Closed
as Fixed Help for as Fixed
84
0
Sign in
to vote
From Connection: SQL Server
Change of behaviour is causing a problem - SP2 introduces a (Select All) option for multi-value parameters which cannot be switched off; this is useless without an option to turn it off. Essentiall…
Created on 1/2/2007 (updated 14 weeks ago) | 29 validations | 5 workarounds | 18 comments | feedback id: 249227  | 
Resolved
as Postponed Help for as Postponed
0
0
Sign in
to vote
From Connection: SQL Server
The setup gets to the authentication point to test connectivity, on clicking TEST or NEXT I continue to get "Your account information could not be verified" for both Windows authentication and standar…
Created on 12/29/2006 (updated 399 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 248738  | 
Closed
as Not Reproducible Help for as Not Reproducible
1
0
Sign in
to vote
From Connection: SQL Server
The log usage statistics (% used) is grossly inaccurate, the repro script given shows the problem, after the steps are run the log before truncation is 35% used, after truncation its still 35% used. …
Created on 6/25/2006 (updated 421 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 146381  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 11 Previous 12 Next