What about this:

Shut down sql service,

move the other (small) dbs' mdf and ldf somewhere else (even another computer).

Resart sql service, ignore error about missing db files and suspect dbs.

Set your...

Select *, STATS_DATE(object_id, stats_id) LastUpdate From sys.stats

You can join it with sys.objects to get the table name.

Switching from any isolation level to snapshot isolation level rollback any open transaction, so it's best to set it before opening a transaction.

Now, snapshot isolation can generate a lot...

The initial size is the current size of the database files.

You can try to shrink it to recover any free space (Task -> Shrink -> Files).

Taking a backup does not...

You get the same kind of limitation if you do a select of your varchar(max) in the management studio.

One way to get around it is to use a bcp out...

ALZDBA (9/17/2010)

---

I removed the user ref of this quote, because I just want to make a general comment on windows authentication ...

...It might also be cheaper to convert the application...

Use this:

Select CHARINDEX('*',@InputString,CHARINDEX('*',@InputString, 1) + 1)

Returns 0 if it doesn't find a second '*'.

edit: too late 🙁

Just keep clicking everywhere in the management studio 🙂

The job properties windows are easy to use, just make sure you check every options and see if you need it 🙂

The user running the VB script starting the package is the same as the user having access to the ftp (same domain)?

Do you start it with dtsexec or do you...

When you schedule a job you can setup the output to a file or to a table.

You'll get all the output, including errors and (xx rows(s) affected).

You'll have to setup a table with all the windows users and their SQL login (+ the server name if you have multiple servers).

When the user uses the website suggested...