I would say that the restriction of "@" as the starting in an email probably needs to be longer and random - think of it as having close to the value...

It is perhaps also worth putting double quotes round the long filename.

This has solved problems on the earlier versions of windows for me before!

Dave.

Mark:

Try this:

/* Print current owner of all databases on instance*/

create table ##dbos (Server varchar(255),DB varchar(255),Owner varchar(255))

go

sp_MSforeachdb @command1='insert ##dbos select @@servername,''?'' as Db, name as Owner from master..syslogins where sid =...

We had the same problem - I used a perl script to remove them. As pereke said, you must be careful of quotes within the quoted text - which...

Why not use a trace, started as a stored proc on system startup?

Dave.

quote:

---

Only question I had was do you need global temp table rather than plain?

Andy

---

I have...