It doesn't answer all of your questions but if you have a lot of jobs the history setting may be to low.

If you go into Agent -> Properties -> Job...

Very Good Catch Jack!!

Didn't even look at the login being used. In my opinion 'sa' should never be used except when working directly with the SQL server. It certainly should...

That will certainly work for four users but it means code changes for any presentation changes.

I would also limit that technique to an internal only server as there are security...

I think we need more information to help you.

What do you mean by provide? File, View Search, Update, Add or some comgination?

What tools do you have? Visual Studio? SQL Only?

I...

I am trying to understand you question but I think what you are asking is you have a structure like this:

Folder1

File1.txt

File2.txt

Folder2

File1.txt

You want to loop...

According to the SQL server rep here they are supporting 2 versions back.

For example, 2000 will be supported until the RTM of SqlServer version 10 comes out. I can't give...

I'm just a little bit confused why you said it will definitely work with Express Editions where in fact as CozyRoc have mentioned, "you cannot use SSIS with SQL Express....

Unfortunately it seems you need dtexec.exe to run the package. I don't know what the distribution rights are for the executable but that is how all of our 400...

SSIS sounds like the right tool for this task. It will definitely work with Express Editions.

One issue you will have is that express edition does not have Agent and...

Alan (12/8/2008)

---

Use SSIS.

The excel data source allows you to connect to the workbook.

The Excel data source in the data flow task will allow you to specify which worksheet...

Use SSIS.

The excel data source allows you to connect to the workbook.

The Excel data source in the data flow task will allow you to specify which worksheet you...

If you are using SQL agent you can choose first Sunday of every month choosing monthly and first Sunday of the month. If you need other Sunday create a monthly...

Have him look into SQL Server side paging for his data the users cannot possibly look or edit at all of that data at once. Surely 25- 50 rows at...

Sorry didn't see you had solved it I really should hit refresh before posting

Here's a sample where I archive move and I think rename files if it helps.

' The execution engine calls this method when the task executes.

' To access the object model,...