I'd check to make sure that there aren't any collation-related differences (the "Use Remote Collation" setting of the linked server object on both servers, especially), as that can prevent the...

Didn't think about using OPENQUERY. That does help a lot. Wish I don't have to do that though. I'm would like to figure why the query...

Added query plans and query text.

Did you check the details of the completed job in the job history?

Example from my log....

The job succeeded. The Job was invoked by User <RunAsUser>. The last step...

kevinsql7 (7/17/2014)

---

To your statement "Additionally make sure you log onto the server as the account that will be executing the ftp processes and connect to the FTP server at least...

kevinsql7 (7/15/2014)

---

We have SQL Server 2012 running on Windows 2008 Server. We would like to use a SSIS Package to generate a text file and then secure copy it to...

Connect to the server using SSMS.

Right click on the server registration and select properties.

Click on Database...

Looks like your service account does not have write access...

Oracle_91 (6/24/2014)

---

Hi Steve,

PS C:\> Send-MailMessage -To "abc@gmail.com" -From "abc@gmail.com" -SmtpServer "smtp.gmail.com" -UseSSL 587 -Subject "sql server stopped " -body "sql server stopped"

Error message:

Send-MailMessage : A positional parameter cannot...

The error tells you to investigate the login RptAcct. Did somebody changed the...

This is quick if you just needed something. Run this as a script with scheduled tasks.

$ServerList = Get-Service...

gautham.gn (6/20/2014)

---

Hi.,

I need a help. I have certain number of scripts placed in one folder. Everyday those scripts will be changed. So., I have to test those scripts by...

Hi,

Have you guys experience where when you failover the AG, the clients do not pickup the new IP address and so cannot connect.

See related link:

http://social.msdn.microsoft.com/Forums/en-US/sqlhadr/thread/34e100db-a340-429d-b42a-41cdd8d4e09b

This...