not to public.

if they need to run sp_Oa*, then only grant it to one specificl role or user/login that will actually need and use it.

depending on what they are actually...

your local server has a number of aliases, and you might need to specifically look in Administrative tools>>Services to see if you have named instances.

assuming a default isntance, you could...

no solution, just consumable data:

i ran out of interest int he issue after converting to usable data:

;WITH MyCTE([EmpNo],[BudgetYearStart],[BudgetYearEnd])

AS

(

SELECT convert(int,'2698'),convert(date,' 2013-02-01'),convert(date,'2014-01-31') UNION ALL

SELECT '67682',' 2013-01-01','2013-12-31' UNION ALL

SELECT '43320',' 2013-02-01','2014-01-31' UNION ALL

SELECT...

Beatrix Kiddo (11/20/2013)

---

finally, you add the linked server on server A, and make sure you use the mapping idea fromt eh screenshot: login not defined = not be made, and...

ok perfect, if he's using a SQL login, it really goes towards the screenshot i provided.

on the remote server, a database role (in the apropriate database(s)(ie LIMITED_ACCESS), and make sure...

i found this bat file from microsoft which is pretty much bullet proof:

it adds the current user as an administrator to the sql server that is prompted in the command...

bulk insert into a single table is incredibly fast. switching away from INSERT statements being generated to sticking the data into a local DataTable, and either syncronizing the changes or...

Beatrix Kiddo (11/20/2013)

---

We have a user who has access to just one view on one database, and he needs to create a linked server from his database to that view....

you have to switch to dynamic SQL for the whole thing, when you try to parameterize BULK INSERT; it only accepts static strings, and not variables.

DECLARE @sql varchar(8000)

--bulk insert won't...

easy fix for you guys.

I assume you went to this page and downloaded the procedures from Micorsoft:

http://support.microsoft.com/kb/918992

from there, all you really need to do is modify the code, so that...

my personal rule of thumb, based on my own experiences, is that if a table has more than 50K rows, i'd rather use SSIS (or The Import/Export Wizard, technically still...

the openquery for a simple select is what you are after, it's just what you do witht eh results(sticking them into your local table instead of displaying)

INSERT INTO...

rebuilding the indexes updates the statsitics for the columns of the indexes, but not all the statistics for the given table.

statistics on non indexed columns let the query engine...

Ed Wagner (11/19/2013)

---

I may be remembering incorrectly, but if you use dynamic SQL in your procedures, the dependency might not show up in the list. If you find that's...

don't limit yourself to think it must be a single char.

i export stuff like html in and out all the time; as a result, i use multi character delimiters that...