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

if they need access up to the last second, i'd do this, but it takes twice as much disk space:

restore the production copy to the ReportServer as a different name....

rajemessage 14195 (10/10/2015)

---

hi,

some times i need to take db in single user mode , which can be done

using following

use master

go

alter database db_name set single_user with...

SQLPain (10/7/2015)

---

John,

I have added linked Server S with report server. Can you please give an example of what would be considered as a fully qualified code.

Also when I write the...

since it sounds like you don't wantto remove permissions, but to prevent it from running with all default parameters?

can you modify the stored proc itself?

that's the low hanging fruit,...

is the destination a network...

then you are out of disk space on the drive? you might need to...

you'll want to uninstall, and then reinstall, two separate steps, sorry.

there's no way to convert a named instance to a default, nor is there a way to rename it(ie from...