Viewing 15 posts - 1,636 through 1,650 (of 6,676 total)
You are still using a DOS batch file - you should switch to a Powershell script (.ps1).
For example - to loop over a directory contents: Get-ChildItem -Path E:\Test
To loop over...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 27, 2020 at 6:25 pm
Where are you seeing this - a little more context would be helpful.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2020 at 8:22 pm
Just curious - but why are you using a domain service account to run a system level task? You can set that task to run as SYSTEM since it does...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2020 at 8:20 pm
I think you are confusing what an 'instance' is...I believe you meant to say you have 4 servers.
If your goal is to have an FCI instance across 2 nodes -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2020 at 8:13 pm
If that is the case, I agree and I have severely misunderstood. You would need 2 connection managers to handle different file definitions.
Or a script component to parse each...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2020 at 3:34 pm
We have to transfer the data to other system in real time.
The other table resides in oracle database.
So first I am testing with sql table if it works then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 25, 2020 at 8:52 pm
This is actually really easy in SSIS. Select the connection manager in the connection managers pane and hit F4 to open the properties pane. Find Expressions, and open that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 25, 2020 at 8:03 pm
You could also change from a CROSS APPLY to an OUTER APPLY. If nothing is returned from the function then use ISNULL/COALESCE to set the value as needed.
Ideally - you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2020 at 7:30 pm
Thanks Grant.
And where are these transactions held? Within the transaction log presumably? If so, do the transaction log backups that have been done not have an effect ?
Assuming the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2020 at 4:10 pm
In Object Explorer - open the Schema section under Security for that database. In that section you will see a list of schemas - now in Object Explorer Details look...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2020 at 3:31 pm
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2020 at 3:22 pm
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS forum. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 20, 2020 at 10:27 pm
What is the reason for using SSMS to connect to SSRS? There really isn't a reason to do so - and you can only connect using the same version of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 20, 2020 at 9:33 pm
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Although you can figure out how to use the same type...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 20, 2020 at 9:28 pm
I am not sure what your problem is based on the pictures...a page footer will take up as much space as you define for it in the design window and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 16, 2020 at 3:31 pm
Viewing 15 posts - 1,636 through 1,650 (of 6,676 total)