Comments
Sort by recent activity
@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...
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...