Activity overview
Latest activity by randyv
getting an error about a constraint that doesn't exist?
I've been using SQL Compare to update tables on an ODS (copy of production database).
Got this error on a table update:
[2714] There is already an object named 'DF_jc-time-sh_emp-id_200808181254453...
SQLVDI errorcode=(8); system halted
Came in this morning and was greeted with unhappy users proclaiming our mission critical application unavailable. A quick check of SQL Monitor (shameless cross-post plug) revealed the server was u...
apologies if this is a repost; couldn't find my earlier post
Two questions:
Is there a way to script-edit existing jobs and set the checksum and verify flags? Hand editing a huge number of existing jobs is tedious.
Is there a way to script-edit existing jobs...
unable to login on iPad
I cannot log in on my iPad since updating to release 3.
Using same URL, Administrator and same password that works on browser, but it won't login on iPad.
Once I got an error about a null line, the...
Just wanted to copy tables
I am trying to use SQL Compare for the first time seriously.
All I wanted to do was copy the tables from a production database to another database on another server.
I cannot get the script to run;...
use problem... need help
I was asked to overwrite our production database to a training database so some testing could be done. I ran a full backup of live, restored over training. When asked if I wanted to back up the t...
what does this lock detail information mean?
I'm trying to figure out something about a deadlock in the monitor.
143 Victim process dbid: 5, object id: 72057594746634240, index id: (c4006323692b) EXECUTE Line #: 0
180 dbid: 5, object id: 72...
cannot login due to unhandled excpetion occurring on server.
Occasionally I find I cannot login, and always I find the following waiting for me on the server hosting the monitor:
From Visual Studio Just-In-Time debugger
An unhandled exception ('System.Net.So...
SSMS not responding; SQL Prompt is root cause. Why?
Every once in a while, when I am connected to certain SQL Server instances, the SSMS will go into 'Not Responding' mode.
This seems to happen when I am writing T-SQL using temp tables. The more te...
feature enhancement request
Don't know if it is possible, but if it is, it would be great to expose all the perfmon counters in the Analysis section.
Also, while it may be superfluous on some points, (overlapping with perfmon...