service accounts don't expire, right? i know "regular user accounts", can have a domain expire date and a separate password expire date.

with Powershell, i've queries active directory to...

the [IN]/[NOT IN] (SELECT SOMECOLUMN FROM SECRETTABLE) has to explicitly exclude nulls.

NOT IN(SELECT SOMECOLUMN FROM SECRETTABLE WHERE SOMECOLUMN IS NOT NULL)

you have to create synonyms for anything that points to objects outside of the database.

the synonym will have deferred resolution,and your project will compile correctly, as you replace each three...

Not with a loopback.

using a linked server/loopback is going to require four part naming conventions. leaving out the database name would default to the default database of the user...

the biggest difference for me is that Developer comes with the SQL Agent, and thus the ability to create jobs. jobs are an important part of the DBA's toolkit.

Its important...

download SQL Express With Advanced Services. it's free.

http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

that is the most complete version, and includes SQL Server Management Studio and more;

the "normal" express download does not include any tools, so...

since you only want tasks that are not on hold, i'd look to get the data via the EXCEPT operator,a dn join it with the other items on hold.

nice job...

Scots solution requires a mapping, mine is just assigning new values.

here's my version, the core is this part at the end:

;With

TheData

AS

(

SELECT

[dbo].[DelAlphaChar](vm.AccountNum) As CleanedNumber,

row_number() OVER...

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