I installed Winscp and I am using a batch file using WINSCP commandlets as shown below

example:

"C:\Program Files (x86)\WinSCP\winscp.com" /command "open sftp://testsftp:testsftp@localhost" "lcd C:\Destination" "get *.* "

Is there any other way...

Grant Fritchey (1/18/2015)

---

For managing dates like that, I'd suggest using the UTC date functions; SYSUTCDATETIME or GETUTCDATE. You can then use the timezone offsets to show the dates as local...

Thanks Shadow and Perry.

What i was trying to do is a table part of replication reaching from Server A to...

jesijesijesi (12/15/2014)

---

Hello,

If i understand correctly, you are planning on a mirrored subscriber. if that is the case, and there is a failover of the subscription database, then you would...

Grant Fritchey (11/25/2014)

---

You have to have the sqlps module if you're running this from standard PowerShell. Here's the topic on MSDN. I know you're calling it from SQL Server, but...

The index rebuilds causing the server to choke. Is there any way we can avoid this ?

I am not fully finished with the code and the schema i provided is not the same in our database, i have posted simplifying it. So can you please provide...

sorry again.

Here is the requirement:

I am getting some input file with all the logons who have subscribed for the different newsletters in an excel file which i am importing into...

Sean Lange (11/21/2014)

---

Your question is not very clear. You did a great job posting ddl and sample data for the sample data table. However, your query has the table main_table...

When we rebuild indexes on one of the server, it's blocking other processes. We tried to...

Not really. But there's a high chance of commenting out some scripts in job on one replica and forgetting it to edit on the other one. I guess it's better...

I don't think it's possible. Though AG is at database level, the listener always connects to primary replica.

"When a SqlConnection is successfully opened, the failover partner name is returned by the server and supersedes any values supplied in the connection string” indicates the failover partner name is...

Hi,

Create a SP using the below link

http://www.sqlservercentral.com/articles/SQL+Server+Agent/67726/

then use the sp_send_dbmail to send the job history when the job fails.

as below:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'DBMail_BAP',-- provide your profile name

@execute_query_database =...