oof, check windows failover cluster manager service, do you see the nodes in there? If they are try to bring them online.

check the permissions on the view, you basically denied all for select permissions for that view. To test that out run grant select for the one user with DBO perms,...

Can you post the query from dataset1? It is saying there is an error in the query for dataset1 in the SSRS report.

I know this post is very old and I went round and round for days trying to figure out why my report was cutting off the last day of the...

• This reply was modified 12 months ago by  lkennedy76.
• This reply was modified 12 months ago by  lkennedy76.
• This reply was modified 12 months ago by  lkennedy76.

I stopped using % to grow files years ago. Microsoft even has an article saying what releases to use % and which to use actual amounts. I am actively looking...

you could also set up a linked server see mssqltips.com articles on this,

https://www.mssqltips.com/sqlservertip/4414/transferring-data-between-sql-server-2014-and-oracle-11g-databases/

https://www.mssqltips.com/sqlservertip/4430/faster-way-to-transfer-data-from-sql-server-2014-to-oracle-11g/

If this is a real time transfer I think replication might be an option...

• This reply was modified 4 years, 4 months ago by  lkennedy76.

When the tlog file grows it is because it is not getting backed up. Below is an article on index and log files .

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/transaction-log-disk-space-for-index-operations?view=sql-server-ver15

SSIS, SQL Server Integrated Services.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e9b0a27b-6819-4c04-8e18-f8aaf01f4678/etl-from-sql-server-using-ssis-to-oracle-db-11g

# is a local temp table, ## is a global temp table, and left function pulls characters from a string, the person who wrote this is pulling 13.

https://www.mssqltips.com/sqlservertip/6035/local-vs-global-sql-server-temporary-tables/

• This reply was modified 4 years, 4 months ago by  lkennedy76.

Got it! Thank you.

I know this post is a few years old but I wanted to share;
its just ="["+User!UserID+"]" you don't have to add the = "[Employee].[Employee_login_id].&[" + User!UserID + "]"...

and I had some heap fragmentation, I had to add a clustered index drop it and run this query;

Alter