Viewing 15 posts - 1 through 15 (of 28 total)
Alex Friedman (6/30/2015)
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...
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...
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....
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...
December 17, 2003 at 2:04 am
This is the article Frank mentions...
. . Greg
Greg M Lucas MCDBA, MCSE
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...
November 14, 2003 at 10:11 am
I once spent an amusing lunch time in pub working this one out:
... which was sign over the bar.
(If I tell you what this means you are honor-bound to put...
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...
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...
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...
November 12, 2003 at 6:28 am
I may be missing something here but what about:
CREATE PROCEDURE myprocedure
@strOut1 varchar(5) = NULL OUT
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...
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...
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:
AS these roles are standard and...
May 19, 2003 at 2:12 am