I enjoy being a DBA/SQL Programmer. For the most part I don't find my job tedious (otherwise I'd have found another one by now). I mostly create and...

I have only known SQL for about two years. About a year ago I thought I had learned all there was to learn about SQL. How wrong I...

Some thing else I do to eliminate getting an error response from a job running a DTS package is to have a second step in my jobs. This step...

I have only used this with SQL Server 7.0 running on Windows NT 4.0. We are preparing to switch to Windows 2000 but haven't got that far yet.

About 2 years ago I made the transition from networking to DBA/SQL programmer. I learned a lot by viewing stored procedures, SQL, and triggers developed by others and then...

In addition to using an e-mail to tell me everything in a DTS package succeeded, I also use extra tasks and/or SQL to insert lines into a logging table to...

Here is the code I use to get files from an FTP server:

SET GLOBALERRORLEVEL=0

net use \\0.0.0.0\ipc$ /delete

IF NOT %ERRORLEVEL%==0 SET ERRORLEVEL=0

net use \\0.0.0.0\ipc$ password /user:computername\username

COPY "\\0.0.0.0\SourceFolderName\filename.txt" "\\username\DestinationFolderName"

IF NOT %ERRORLEVEL%==0...

It sounds like everyone works at large companies, so perhaps what I say won't mean much.

At my previous job I was one of two DBA's. The only machine we...