it depends on what you mean by "sync" and also the allowed latency of the data.

if you mean combine changes from each server into one master database, that's a lot...

sp_sendmail doesn't auto-magically break and double send, so there's got to be something unexpected in the workflow instead.

Are you looping thru a table or results, and calling sp_sendmail on each...

\you are correct: you only need to grant EXECUTE on the stored procedure; your user does not need any access to the objects the procedure might use or manipulate.

There...

I'm assuming we are talking about SQL server login passwords, and not an encrypted value in a table that is used by the app.

Ed you can compare if the hash...

sql doesn't really need the data in a specific order; you should typically just use an order by when you need the data in a specific order.

it uses indexes to...

sounds like you need a GO statement between the function and the GRANT SELECT myFunction statement.

the function is trying to compile with the GRANT statement as part of it's body,and...

can you confirm this actually returns something from your side: syntactically, it seems to work on my side:

--INSERT INTO SpatialDemo (SpatialData)

--test the select first:, then uncomment the INSERT INTO

SELECT geography::Point(Latitude,...

looks like this page has some examples of the conversion; i haven't tried this yet:

http://www.sql-server-helper.com/sql-server-2008/convert-latitude-longitude-to-geography-point.aspx

I'm going to have to throw some time into studying this a bit;

create table x(

myLat ...

is there a question in there somewhere? all you did was paste Narayana Vyas Kondreddi's well known search function.

there's a difference between 'null'( a string literal) and the keyword NULL;

since you are not replacing more than one result, you don't need the CASE statement in this instance.

UPDATE dbo.LOCATION

SET...

you need to wrap and alias the XML like this:

Create Table #Results(

id int identity(1,1) not null primary key,

ResultsXML XML )

INSERT INTO #Results(ResultsXML)

SELECT (

...

are you taking the network data transfer into consideration?

on your local machine, the million rows go directly into memory; on the remote server, they have to travel over the network,...

a simple example:

SELECT

t1.*,

t2.*

FROM Databasename.dbo.Table t1

INNER JOIN MyLinkedServer.DbName.dbo.OtherTable t2

ON t1.ID = t2.ID

mvklingeren (4/8/2011)

---

That is correct, so the conclusion is that i should create a two column width temp table

First column IDENTITY,

Second column, containing the XML string

Would that be the right...

but the results is always a single column FOR XML isn't it? it doesn't matter if the XML contains multiple nodes or not.