Activity overview
Latest activity by ptrongo
@Victoria W It looks like they were converted. Here is one example. Jason files are in there with the original name and a unique identifier. There is nothing in the mentioned Styles folder. Additionally, the Tab History isn't working either. Old File (from a directory I copied off prior to upgrade)
stat.sqlpromptsnippet =======================================================
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets>
<CodeSnippet Format="1.0.0">
<Header>
<Title>stat</Title>
<Shortcut>stat</Shortcut>
<Description>Set Statistics on</Description>
<Author />
<SnippetTypes>
<SnippetType>Expansion</SnippetType>
</SnippetTypes>
</Header>
<Snippet>
<Declarations />
<Code Language="sql"><![CDATA[set statistics io on
go
set statistics time on]]></Code>
</Snippet>
</CodeSnippet>
</CodeSnippets>
New File stat-fa1100dc-3891-447c-9182-1af333162cc9.json ======================================================== { "id": "fa1100dc-3891-447c-9182-1af333162cc9", "prefix": "stat", "description": "Set Statistics on", "body": "set statistics io on \ngo\nset statistics time on" } / comments
@Victoria W It looks like they were converted. Here is one example. Jason files are in there with the original name and a unique identifier. There is nothing in the mentioned Styles folder. Additi...
Snippits not working on a new install
I just installed SQLPROMPT10.6.16.21150 on a new machine. everything seems to be working, except Snippit Manager.Its not recognizing any existing snippits in my team's shared folder. I Can see the...
Hi,
I would agree with you, but this is the only job failing, and it fails repeatedly. It's also the only job I have using SQL Backup so far. I ship logs on 10 database once every five minutes. I've never had an issue. The actual log backups usually take less then a second or two.
Looks like the spid for the backup has locks on EVERYTHING the only other locks in there are a shared lock
The guy thats hung is...
exec msdb..sp_delete_backuphistory '2006-03-02 10:30'
Patrick / comments
Hi,
I would agree with you, but this is the only job failing, and it fails repeatedly. It's also the only job I have using SQL Backup so far. I ship logs on 10 database once every five minutes. I'v...
Deadlock in MSDB
Hey folks,
Help!
New user... everything seems to work fine except that scheduled jobs are erroring out due to a deadlock, problem is, I don't see it.
sample error
BACKUP LOG successfully processed...