The problem with a DTS to copy all of the data is that we are in a time crunch and there are hundreds of tables that we would have to...

Sorry I am kind of new to recreating indexes. What is the fastest way to do that for an entire database with several tables (We are in a kind...

That's what I was wanting to do originally, but on a job that comes from a multi server job, you can not get it to go to an output file.....the...

thanks for the suggestion, but this is all that I see "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed." for the reason.......the job backs up the database fine, but...

All that tells me is the last step to run, it doesn't give me any details of why it is failing......I need to be able to right the errors to...

Well the destination server has nothing of importance on it, so would backing up and restoring the msdb be ok to do?

Ackward thing is that I started working on another report that was pretty simple and the report (not the drop downs) is showing blank values.  I haven't touched the visibilty...

I don't know what version of SQL Server you have, but if you are using 2000, you should be able to use ADO to execute a SQL Command.  Like so.....

Dim...

I have already tried that, it was what was different between my first syntax example and my second syntax example.   I also have tried putting the isdate() function in the...

Actually, I found the solution to the problem.  SQL/Excel doesn't insert single quotes before the values, unless there is a blank value.  For example, below is a list of what...

Sorry about the slow reply, that did work, but it was not fast enough for the application I am creating (the app has a large amount of data in it).  I...

Yeah......Let's say they enter five records

1 - Ted, 2 - Ted,3 - Larry,4 - Ted,5 - Bob

I want to return "Ted" because "Ted" occurred the most often.  I would need...

Just ignore this post, I put the vbscript to translate the file in a DTS package and saved it as file instead of saving it in SQL Server.  I forgot...

I believe that I found the issue.  There is another DTS on another server that utilizes the same file at the same time.  I now have a job that runs...

OK, it has gotten even weirder.  I checked the DTS is running under an admin account, and so is the job.  I even tried deleting the job, then using a windows...