i believe the toAddress requires a semicolon delimited list of recipients, not a comma delimited one., so you'd need this for the variablbe, right?

[string] $toAddress="user1@abc.com;user2@abc.com"

and yet another option:

SELECT

DATABASEPROPERTYEX(db_name(),'Collation') AS Collation,

DATABASEPROPERTYEX(db_name(),'ComparisonStyle') ...

boy that MS document is really scarce on details and guidelines... "calculate it yourself based on details" is my take on it.

I can't say whether this is right or not,...

first: ALWAYS treat datetime as datetime . converting them to int, varchar or anything else just makes you have to re-convert them back again later, so your DateId should be...

can you pre-process the file by replacing Null with String.Empty? then you could continue using bulk insert

i think the issue is BULK INSERT cannot differentiate between a string between two commas and the keyword NULL;

I'm not sure how to tackle that, other than putting it...

ichiyo85 (4/11/2011)

---

Hi Lowell,

It is possible to have ID1=ID2. Would I be sure to know I am joining by ID1 fist, and if not ID2 with your code?

Thank you so much...

is it possible that Table1.ID1= Table2.ID2?, or that Table1.ID2= Table2.ID1?

wouldn't it be more correct to join with an OR?

select * from table1

left join table2

on (table1.ID1 = table2.ID1)

OR (table1.ID2...

I'm not sure what terms you might have searched for, so try a google search for

sql server script database relations

or

sql server script foreign keys

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...