Your answer is yes and no. Yes at got thru NT Authority\System you cannot remove at from that I do believe unless at is now tied to Task Scheduler service (which I believe is now is). You thus could go into services and set Task Scheduler to be another account. But the point is to block […]
2004-10-13
I'm having some issues with remote procedure calls.ServerA and ServerB are both setup as linked servers. ServerA is SQL 2000/Windows 2000 and ServerB is SQL 2000/Windows 2003I can successfully run:exec ('[ServerA].master.dbo.xp_loginconfig') and alsoinsert into tblConfig exec ('[ServerA].master.dbo.xp_loginconfig')I can also run exec ('[ServerB].master.dbo.xp_loginconfig')The problem is when I run:insert into tblConfig exec ('[ServerB].master.dbo.xp_loginconfig')The process just hangs. What […]
2004-09-02
10 reads
If I write an insert directly to a linked server then it works. If I do exactly the same via a distributed transaction it hangs. The syntax is 100% correct including the xact_abort on I'm using sql2000 sp2 with a domain service account. I can't believe the answer is upgrade to sp3a. Any suggestions gratefully received.
2004-07-29
2 reads
HI robbac, yes, Users are under NT group.AppDev How use ddl_admin to create/alter/execute procedure/functions and not to create /alter table/constraints/indexes.Thanks,Sheilesh
2004-07-26
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers