exec sp_changeobjectowner 'myuser.payroll', 'dbo'

Questions -

• When you say 'written in C' do you mean C++ or C compiled with Visual C++?  The reason I ask is that C-based DLLs don't have...

I must agree with Frank, you might want to consider another tool.  When I used to work in junk mail, er...Direct Marketing...we'd get millions of names a week to process...

I will agree that OPENQUERY is quicker on the first read only.  If you are performing multiple OPENs, you will see much worse performance, imho. 

They are good for reading...

I recommend against using SQLMail altogether for this reason, the requirement of an active mailbox.  Try POSTIE.EXE ( http://www.infradig.com/index.html&nbsp

A detailed usage example -->...

I've been looking for this too...but I remember seeing a SELECT...INTO that allowed output to a text file.  Hallucination?

6.5

'nuf said.  Thx

Worked...

OK, so I added the other alerts and observed the following:

EM -> delete domain login = 15485

EM -> add domain login = 15481

QA -> drop domain login (domain\loginID) with sp_droplogin...

As to "what does the account need to run this" The following appears to be a problem in both SQL7 and SQL2000

"PRB: Need to Map to Default Admin Account...

OPENROWSET is slooooooow. Comapred to a linked server at least. The connection has to be established each time you run the query, kind of an ad-hoc linked server....

http://www.xceedsoft.com/products/ZipNet/

http://www.chilkatsoft.com/dotNetZip.asp

http://www.example-code.com/vb/default.asp

FREE!

http://www.organicbit.com/zip/

http://www.gzip.org/zlib/

http://www.winimage.com/zLibDll/

-------

at us, very deafly, a most stares

collosal hoax of clocks and calendars

eecummings

That's normally Visual Basic error indicating an unitialized object variable, not a permission issue.

 

   dim o as object

   set o...

quote:

---

This error happens when more than one record is in the Inserted table. This can easily happen on an Update trigger.