i would lean towards a web page that accepts the user input, and performs the work behind the scenes.

you are worried about something you don't need to worry about.

simply make sure they are not sysadmins.

if you create a user for your contractor, the ONLY user they can see...

i'd be interested to know why, of course; is it because the username and password are passed around to developers? are you having trouble with people changing procs? are you...

Janda Nel (8/19/2015)

---

good day .

we have a development environment with linked servers,which worked well.We had to rename the server names for reasons.Now in the one server the linked server appear...

you can use Windows Scheduled Tasks to create regular backups for SQL Express.

it's a scripted solution, typically with a bat file that calls sqlcmd.

google points me to a lot of...

i found this user defined function that does the same thing:

http://www.experts-exchange.com/articles/670/DateSerial-Function-for-Microsoft-SQL-Server.html

SELECT dbo.DateSerial(Year(getdate()),6,30)

latingntlman (8/18/2015)

---

I apologize but I forgot to mention in my reply that the Teradata connection does not communicate with SQL tables, so if I join the staging table w/the customer...

i do something like that, where truncate and insert a bunch of ID's from an AS400 connection, which then gets stuffed into a staging table on my Source SQL Server.

then...

also, think about any items you might have installed, whether running in the background or as a service, that are running under your credentials, maybe something like RedGate lighthouse ,...

lyleholc (8/17/2015)

---

Hi,

I tried to download the mthesaurs at the link provided, but got error file not found or unavailable. Is it possible you could provide a link to me?

lyleholc@gmail.com

Thank...

both SSDT and SSDT-BI are both free add ins. they add the templates related to using SQL server database projects (SSDT) and SSIS/SSAS projects (SSDT-BI)

i believe there is a flavor...

no, sorry.

if the database was 150 gig at backup time, you need 150 gig of disk space to restore it, regardless of the size of the *.bak file itself.

the database...

i believe if you set the owner of the job as your AD account, it would work.

taybre (8/17/2015)

---

I've just checked the error log...

you want to leave the column alone, without functions or conversions, so you can use any existing indexes.

instead, generate the dates the date values should be in between:

DECLARE @Date datetime...