Viewing 15 posts - 2,461 through 2,475 (of 2,756 total)
Lynn Pettis - Monday, April 24, 2017 4:12 PMSorry I brought it up.
I'm glad you did. It was a fun contribution to...
April 24, 2017 at 4:15 pm
tcronin 95651 - Monday, April 24, 2017 2:34 PMmy bad the trigger will not work for multiple record deletes
You could make it...
April 24, 2017 at 2:39 pm
This may be a silly question but did you install the ACE drivers on the SQL Server instance machine or your local machine?
EDIT - never mind... saw your...
April 24, 2017 at 2:34 pm
That trigger looks right to me.
When you say that it fires for the first insert but not others, how many rows are being inserted at once? What does...
April 24, 2017 at 2:31 pm
April 24, 2017 at 2:04 pm
For the licensing, a good read is:
http://download.microsoft.com/download/C/3/7/C37F243B-0246-493E-ABFC-41A7FFD6DE38/SQL_Server_2012_Virtualization_Licensing_Guide.pdf
I misunderstood the licensing model. What I was stating was licensing for maximum virtualization. The advantage of using this is...
April 24, 2017 at 9:53 am
If you were willing to spend some money, I'd do it with 4 separate VM's and then load up a tool like DxEnterprise (similar to Polyserve back in the day)....
April 24, 2017 at 8:43 am
April 20, 2017 at 2:46 pm
April 20, 2017 at 12:09 pm
Just because the "Events" table has information you don't care about, there was also 8 consistency errors in database 'ACSA'.
Running that could drop things you DO care about. It...
April 20, 2017 at 11:21 am
Pretty sure that means your DB is corrupt. I'd run DBCC CHECKDB
and see if it is bad. If so, I'd run it on your live one...
April 20, 2017 at 8:37 am
April 19, 2017 at 4:24 pm
If you are not using Enterprise Edition, you should check the ReportServer.dbo.Keys table. Actually, even if you are using enterprise edition, might not hurt to check that. Standard will fail...
April 19, 2017 at 4:20 pm
Here ya go:USE [ReportServer];
GO;
--View all of the SSRS jobs
USE [ReportServer]
SELECT
[Schedule].[ScheduleID] AS [SQLAgent_Job_Name] ,
.[Description] AS [Description] ,
[Catalog].[Name] AS [Report Name]...
April 19, 2017 at 4:13 pm
Viewing 15 posts - 2,461 through 2,475 (of 2,756 total)