Alex Friedman (6/30/2015)

---

...It would be great if there was some control process that checked who missed check-ins -- but that process would need to know who made the changes and...

Thanks everyone for taking the time to read this article and responding. I'm glad I have inspired so many of you.

@MysteryJimbo - it's nice to know others...

If you're talking about scheduling the job...

If you use SQL Agent Job Scheduler, when you add a step to the job, on the advanced tab there is an option to...

Morning Colin - I always have problems getting SQL to use more than 2MB too 🙂

I'm a great believer in certification - as a means of structuring my continuing education....

I'm the only DBA in a financial systems software house that faces similar problems. I have six SQL Servers in live which support about thirty or so databases ranging from...

This is the article Frank mentions...

http://www.sqlservercentral.com/Forum/topic.asp?TOPIC_ID=11095&FORUM_ID=8&CAT_ID=1

. . Greg

Greg M Lucas MCDBA, MCSE

quote:

---

Greg : We use the same method as you. But, we don't have an app that can combine all the scripts together...

I once spent an amusing lunch time in pub working this one out:

IITYWTMYAHBTPTPITBB

... which was sign over the bar.

(If I tell you what this means you are honor-bound to put...

Like Ray, we use SourceSafe. I even use it for any personal projects because it makes it so easy to roll back changes.

In our environment, the database schema is handled...

I do this a couple of ways.

1. Open the DTS package, right click for properties and on the looging tab under error handling specify an output file. This logs everything...

Not sure if this is what you're after but I have word template that we use to dcument all database objects. For sprocs this includes all parameters and column name/datatype...

I may be missing something here but what about:

CREATE PROCEDURE myprocedure

@strOut1 varchar(5) = NULL OUT

,...

You can also get DTS to log all output to a log file - you choose the path. While the package is open, right click and go properties - it's...

Actually you can change from UDP 1434 - although you can't define what alternative port to use.

If you click the "Hide Server" box in Server Network Utility (SQL2K) the listener...

We use a dozen or so standard database roles - often added to the model database to save recreating in each new database, examples are:

LOG_WRITER

USER_READ

USER_WRITE

ADMIN_READ

ADMIN_WRITE

USER_EXECUTE

ADMIN_EXECUTE

NO_ACCESS

AS these roles are standard and...