Evil Kraig F (2/20/2014)

---

This may sound silly but when you login to the target server with the login you're logged into your local as, and look at the database, you...

Evil Kraig F (2/20/2014)

---

To confirm, you're sa/dbo on production with your NT login?

Go to security in the linked server. What is the default setting for a login not defined?...

stormsentinelcammy (2/20/2014)

---

Just wondering but when you created the linked server did you pass the sa/sa password for the username/password for the connection to the production server, small things like that...

Thanks for your reply. I ended up re-creating the job. The box was unchecked, but I kept getting the email message. Re-creating it worked, but it wasn't a good solution....

This was my solution:

Create a new multi-statement table-valued function.

Select the data and use the order by in the loading of the table that is returned.

This works in all the testing...

Thank you, Thank you, Thank you!!!!!

Where can the 'if exists' option be turned off or on?

GilaMonster (12/21/2008)

---

Yes, providing the TOP is row-limiting. Currently, that just means not TOP 100...

The function is called from the application, which provides the input value. So, adding the order by at that point works (in testing) but can't be done in my actual...

I've never really gotten a handle on execution plans and was hoping to use the code in the article to understand them a bit more. However, the code in the...

What version of SQL Server?

I have a pottery studio in my home and I spend as much time there as I can. When I'm not in the studio, I like to look at pictures...

Thank you! I think these ideas will solve the problem! I KNEW it was something right in front of my face!

I found some documentation that said that bulk insert doesn't have the ability to modify the data as it's being 'inserted'. So, I've written a stored procedure to run...