NTBackup comes with a help.  If you do not use it already, I suggest you just use xcopy.  You can just easily add a step toa a SQLServer agent job...

Sorry, can't help you there.  I got mine a long time ago from a MSDN download.  But as it is a free add on, I guess you can find it...

You have probably figured it out by now, but just in case.

First unzip it. In windows xp or 3 a right-mouse click and option unzip will do.  Otherwise you need...

There are also editions of Reporting Services.  You have to install Reporting Services development edition on SQLServer development edition.

Joachim.

You can just use the import/export wizard.

Just right click on the database and select all tasks, export data.

Select a text file as destination.

The rest is simple.

Joachim.

Would it not be easier to just remove the login and join the user to a new login.

Otherwise you will have to delete or move all objects.

The following statement shows...

I have seen this when you run this job as a global user (myself) and active directory was running in native mode.  For some reason sqlserver agent can not access...

No a model is not a datasource, despite the fact that the Report builder is complaining it does not see databases. It is a model of the database with some...

It is a nice control.

Too bad that I must use Reporting Services for this project.

A simple way is to open de rdl file in notepad and remove the tag with everything in it.   I am sure there is another way, but hey, this works.

Joachim.

I have been looking into that myself this week and there is not much.

There is the MSDN that comes with sqlserver 2005, but most of the new stuff has empy...

Reading the BOL has its advantages. Apparently this needs a "Report Model", looks something like a BO universe.   I got it working for adventure...

It is installed by the reporting services setup.  I think it is only installed if you install the Visual Studio part.

If you had used the create table statement  the names would be rejected.  The enterprise manager "helps" you to do it anyway. userfriendly, indeed!

If you use these columns you will have to enclose them either between [] or " ".

See the rules for identifiers in BOL. The first character must be a letter...