Comments
Sort by recent activity
I'm running Dependency Tracker on my laptop. It gets rebooted daily. I hadn't run Dependency Tracker in weeks. / comments
I'm running Dependency Tracker on my laptop. It gets rebooted daily. I hadn't run Dependency Tracker in weeks.
Finally figured this out. I had previously removed those servers from my alias list in SQL Server Configuration Mgr. Forgot I still had them listed as Registered Servers in SSMS. That is where Dependency Tracker was picking them up. When I deleted them as registered servers, they no longer appeared in Dependency Tracker / comments
Finally figured this out. I had previously removed those servers from my alias list in SQL Server Configuration Mgr. Forgot I still had them listed as Registered Servers in SSMS. That is where D...
Thanks for the explanation. I was hoping they were related to the new network resilience feature. How does one enable/use network resilience from a command line? / comments
Thanks for the explanation. I was hoping they were related to the new network resilience feature. How does one enable/use network resilience from a command line?
As far as I know, I have the most recent version of SQL Prompt, and to the best of my recollection, I have not altered the Triggering list. Try typing this into an new SSMS query window:
SET NOCOUNT ON;
As soon as I type the semicolon, a list of keywords pops up, beginning with "ALTER" / comments
As far as I know, I have the most recent version of SQL Prompt, and to the best of my recollection, I have not altered the Triggering list. Try typing this into an new SSMS query window:
SET NOCOU...
The activity monitor indicates SQL Backup (actually the SQL Backup executable). What other application could possibly be running it? / comments
The activity monitor indicates SQL Backup (actually the SQL Backup executable). What other application could possibly be running it?
Yes, that's what it looks like to me. When I open the Activity Monitor there are the same number of Process IDs as the number of threads I specified for the SQL Backup task. When SQL Backup is not actively executing a backup, the processes have a status of sleeping. / comments
Yes, that's what it looks like to me. When I open the Activity Monitor there are the same number of Process IDs as the number of threads I specified for the SQL Backup task. When SQL Backup is no...
SQL Server 2005 Activity Monitor. / comments
SQL Server 2005 Activity Monitor.
Yes. The restore operation completes whether run in SSMS or in a job, but when run in a job, the job does not stop. / comments
Yes. The restore operation completes whether run in SSMS or in a job, but when run in a job, the job does not stop.
Yes, every invocation causes it to stay in Executing state indefinitely. I am also seeing an issue where backup jobs seem to overwhelm the server. / comments
Yes, every invocation causes it to stay in Executing state indefinitely. I am also seeing an issue where backup jobs seem to overwhelm the server.
Thanks James. That is what I suspected, but wanted to make sure. / comments
Thanks James. That is what I suspected, but wanted to make sure.