Been a while since I have use a CAL scenario but I believe it does throw a message about license limit being reached but that would mean 200 connections at...

Do not destroy and recreate the DMO SQLServer object for every iteration. -- Actually doesn't really matter I just hate wasting the resources used to create an destroy an...

SASI.ASTU5031 -- Previous School Attended?

SASI.ACHS5031 -- Current School

-- Looks like a list of the schools based on a portion of a filed but not sure which table came from.

   BEGIN

  ...

Your vendor who sold you DB2 or IBM should b able to help get the correct client driver. Otherwise you could get a DB2 DBA to build a view of...

REPLACE cannot be used on an NTEXT field. You will have to cast to another datatype like NVARCHAR which can be used with.

You to my knowledge have to have Excel installed and fully for proper support. Make sure your SQL agent service account has rights to use Excel, do not use Local System....

If you are using DTS then you use a data driven query task. The object looks like a Database with a magnifying glass over it in the Task tool bar. 

Ex. (Oracle...

Have you installed the latest DB2 client on the machine running the SQL Server? Or what version are you using of the DB2 client, mine is version 8.

There have been several threads along these lines in the past.

However you might try working out a couple of table designs and a list of the data you would...

First off you have many syntax errors including a ) missing for a declare statement. But as for you IF statement you are using the wrong logic method this is...

Try it this way

set objSQLServer = CreateObject("SQLDMO.SQLServer")

while not rstSQLinstances.eof                   

 on error resume next

 objSQLServer.Connect rstSQLinstances("ServerName") , "sa", rstSQLInstances("saPassword")             

 if err.number <> 0 then

  Call writeerrortolog("Cannot connect to " &  rstSQLInstances("ServerName") , Err.Number)

  err.clear

 Else

  objSQLServer.Disconnect  ...

Consists of a single contiguous region of addresses within the SQL Server process space that is set aside at startup. This area is static (the size cannot change) and is...

You really should suggest doing something like this.

Schools  (Details about the school)

School

Address

...

Surveys (The base details of the survey)

Survey_ID

Date_Performed

Performed_By

Survey_Answers (The Answers)

Survey_ID (Foreign Key to Survey_ID in Surveys)

Question_ID (Foreign Key to Question_ID...

You might also consider creating a job to copy the log lines from msdb..sysjobhistory to another table for the items you have to maintain.

generally all activity related to MSDB is due to SQL Server Agent tasks. It is not uncommon to see large amounts of CPU and DISK IO utilization as these are cumulative...