Viewing 15 posts - 1 through 15 (of 29 total)
Alex Friedman (6/30/2015)
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
June 30, 2015 at 2:14 am
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 have a...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
September 13, 2012 at 4:52 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
March 12, 2004 at 12:34 am
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....
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
December 17, 2003 at 2:30 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
December 17, 2003 at 2:04 am
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
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
December 11, 2003 at 1:55 am
quote:
Greg : We use the same method as you. But, we don't have an app that can combine all the scripts together...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
November 14, 2003 at 10:11 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
November 14, 2003 at 4:37 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
November 14, 2003 at 3:15 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
November 14, 2003 at 3:08 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
November 12, 2003 at 6:28 am
I may be missing something here but what about:
CREATE PROCEDURE myprocedure
@strOut1 varchar(5) = NULL OUT
,...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
June 5, 2003 at 12:22 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
June 5, 2003 at 12:12 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
June 2, 2003 at 4:22 am
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...
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa
May 19, 2003 at 2:12 am
Viewing 15 posts - 1 through 15 (of 29 total)