I agree with what you say. I have met many people that are trying but do not understand. Is it because they don't understand logic? Select x from y where a=2 To me, that makes perfect sense but others cannot understand. I would love to view it in thier eyes. Just to see. I would […]
2003-06-11
Hello Crispin, quote: Is it someone that understands logic or is it purly intelligence? the above plus self organisation curiosity love and understanding great portion of humor sarcasm all of the above none of the above don't know Now serious, I prognosticate this could be a huge thread, for it is kinda philosophical question. Let's […]
2003-06-11
Found it! EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'AD Provider' grant select on corpsysad_allusers to public select * from corpsysad_allusers create view corpsysad_allusers as SELECT name FROM OPENQUERY( ADSI, ' SELECT name FROM ''LDAP://163.232.12.200/CN=Application Users,DC=ppl2kdv''') where ppl2kdv is the root node of my AD (others may include the complete .com.au or whatever, if […]
2003-06-10
You can use user defined role and add members to the role. Whatever permission the role is given will be inherited by members. But every time new objects are added, you need to adjust permission on the Role. In other word permission has to be set explicitly on newly created objects @ role level. MW
2003-06-10
2003-06-10
Yes, you can delete NT Authentication logins that have been deleted from the domain, because even if they were recreated in the domain, they would have different spid and so would not be recognized by SQL server anyway.
2003-06-05
It sure sounds like Slammer, but you have SP3 already applied. Have you looked at the traffic with an analyzer to see where the data is going? That much traffic is extreme for SQL to be putting out.
2003-06-05
I just shot myself in the foot. I gave bogus info there! Dho! Maybe I change it. Wonder if they will send it international? Cheers, Crispin
2003-06-04
1 reads
I have the same probelm on 3 SQL 2000 servers each running 3 instances of SQL. I have a call with Micrososft for this one. 3 weeks on we still havnt resolved the problem. Last call was to rebuild all servers.....
2003-06-02
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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