Re-write the query to match with this example...

Example:

DECLARE @bulk_cmd varchar(1000)

SET @bulk_cmd = 'BULK INSERT AdventureWorks2008R2.Sales.SalesOrderDetail

FROM ''<drive>:\<path>\<filename>''

WITH (ROWTERMINATOR = '''+CHAR(10)+''')'

EXEC(@bulk_cmd) -- Focus here

In short, to connect to a SQL Server, you should know either Server Name or IP address & should have sufficient permissions to connect to server.

If it doesn’t satisfy...

My next question is, can this task be automated via a SSIS ?

What I mean is can I have a job that runs everyday at 6 PM and have the...

Not very sure if Maintenance Plans works that way (try it) but you can write your own scripts to achieve the same. At run time you have to add timestamp...

Configuring SQL Server Agent with sufficient rights is very important in Replication. Please visit following articles for more.

Replication Agents Overview

http://msdn.microsoft.com/en-us/library/ms152501.aspx

Configuring SQL Server Agent

http://msdn.microsoft.com/en-us/library/ms178142.aspx

Is the same account been used for configuring SQL Server & SQL Server Agent Services?

Absolutely no offense taken Brandie. You (all) can’t be wrong. I wish I would have seen this alert couple of days back. Thanks anyways. :unsure:

I am seriously evaluating my last...

It doesn’t look like an error. Do you have any procedure to crosscheck the restored data? If yes, please verify the restored data. IMO, it’s a clean point-in-time restore.

BinaryDigit (1/6/2012)

---

...

I tried to execute

GRANT CONNECT ON ENDPOINT::InstInitiatorEndPoint TO [NOLOGO\Gordon];

as it was one of the links I came accross but received the following message

Cannot grant, deny, or revoke permissions to...

nope... I was shocked after reading...

@Remi: It’s pretty much insulting and I am ignoring you for a long time. I don’t think I have said anything insulting to anyone, especially you Remi. If Gail is...

GilaMonster (1/7/2012)

---

Dev (1/7/2012)

---

GilaMonster (1/7/2012)

---

Likewise. Then add in SQLTeam, MSDN (though I don't post there much any more), stack...

Don’t you want to know what the issue was & what fixed it? If you have any ideas on it please share with us. It will close the thread gracefully.

GilaMonster (1/7/2012)

---

Likewise. Then add in SQLTeam, MSDN (though I don't post there much any more), stack overflow and related sites...

GilaMonster (1/7/2012)

---

Dev (1/7/2012)

---

Steve Jones - SSC Editor (1/6/2012)

---

Top 10 from 2011

User posts

SQLRNNR ...