Thanks for your reply! I've now managed to deploy the dtspackage on to the MSDB database which is on the Integration Services but I'm now trying to find out...

The database is in 'Full Recovery' model and there is a regular log backup occurring; which is why I ask the question then reason why the Log wait desc =...

Thank you for your reply!

I have an index job which does a 'Rebuild' but it has been failing with the error message from the error logs as :

"The transaction log...

Thank you for your reply! To give you as example of the results, the fragmentation percentage for one of the indexes is 85%, the index type is nonclustered, the page...

I have 2 tables which has the following columns

Table1

ID,

CustomerName,

CustomerID

...,

...,

DateofUpdatedData

Table2

ID,

CustomerName,

CustomerID

...,

...,

DateofUpdatedData

DataupdateType

I want to insert into the "DataupdateType" column of table2 any data which has been either 'Updated', 'Deleted' or 'Inserted'

I hope that...

SeniorITGuy (8/9/2016)

---

tt-615680,

In SSISDB, internal.object_permissions is a view that unions four tables.

Those tables are:

internal.operation_permissions

internal.folder_permissions

internal.project_permissions

internal.environment_permissions

Check each of those tables for entries for the user you want to drop and remove them from...

tt-615680 (8/9/2016)

---

When trying to drop the required user using the...

When trying to drop the required user using the above...

John Mitchell-245523 (8/9/2016)

---

You have replaced "USERNAME" in that query with the name of the login you can't drop, haven't you? And you are running the query in the correct...

Thank for you reply!

When I run the following query with the username I get 0 results which is why I'm confused to why it cannot be removed.

select *

from sys.database_permissions...

I can confirm that I have done the following:

- Can log on using the credentials which is used for the proxy, I tested this by logging on to SSMS.

- Restarted...

Here is the script for the user databases:

1. stop SQL Server Service

2. Check the location of the tempdb files

Use master

GO

SELECT name AS [LogicalName],physical_name AS [Location],state_desc AS [Status]

...

The way they are named is as follows:

221519344_1_1_11_0_20160505181235543_1616

221519344_1_1_11_0_20160505181235543_1617

221519344_1_1_11_0_20160505181235543_1615

But they seem to have a timeline of 1 - 4 minutes apart as the new files are created.