a foreign key constraint between the tables could block other spids from updating or inserting data due to locks,

hmm; and the database? [AdventureWorks2012] definitely exists on your local machine, right? if you obfuscated it,...

sa02000 (10/15/2015)

---

I would like to connect to real estate transaction data service (RETS), download data and do some calculations, set up alerts etc.

Is there a free version of SQL server...

i would think it has something to do with the object Microsoft.SqlServer.Management.SMO.Server that got created; is this a new local machine? maybe you didn't install SMO when you installed ...

well obviously, the backup has to be available between both machines.

you can simply start a backup job and script it.

you get results something like this:

BACKUP DATABASE [ProductionDb]

TO...

i have this saved in my snippets; does ~7 miles sound correct for what you posted?

DECLARE

@Latitude NUMERIC(9, 6),

@Longitude NUMERIC(9, 6),

@MyLatitude NUMERIC(9, 6),

@MyLongitude NUMERIC(9, 6)

Set @Latitude =...

i think you also need to set connectiontimeout as well.

Each object can have it's own time timeout: SQLBulkCopy , SQLCommand, and SQLConnection all have seperate timeouts, for example.

so if you...

in my case, we have a "reporting" database the end users have access to; but sometimes they want the freshest data.

they don't have access to production, so my simple solution...

you can create a stored procedure that does EXECUTE AS OWNER, which will backup, restore etc.

in my case, I have end users that can do excel or a web...

i've done exactly that with plain old FOR XML and sp_send_dbmail; why do you need to complicate it with powershell?

here's an old snippet:

Declare @HTMLBody varchar(max),

...

My advice would be to take the better paying job right now. no doubt.

once you are at a higher rate, it is very , very doubtful that you would find...

you need a geolocation lookup table with geo coordinates for every address; do you have that?

are you going to call a google web service for it instead?

if you have linked servers set up, then yes, it's pretty easy:

SELECT * FROM

[Development].master.sys.server_principals T1

INNER JOIN [UAT].master.sys.server_principals T2

ON T1.name = T2.name

WHERE T1.sid <> T2.sid

if you don.t then you need to...

so the column containing the HTML is nvarchar(max), i assume, and you are going to spin off the contents to files?

with the schema of the table, we could give you...

just for fun, i grabbed the Ashley Madison database bittorrent, which is in the form of MySQL dumps, brought it into MYSQL, and then tried to import it into SQL...