Search results for query: *

Hello! The jobs which has domainaccounts specified as the job owner fails with the following error message: "The job failed. Unable to determine if the owner (domain\account) of job TestDB backup has server access (reason: Could not obtain information about Windows NT group/user...

Hi all I'm trying to get the "lastlogon" value from the "user" objectclass within our active directory using this query: SELECT lastLogon FROM OpenQuery(ADSI, 'SELECT lastLogon FROM ''LDAP://DC=mydomain,DC=com'' where objectClass = ''user''') but i get the following error message: Server...

Hi My goal is to setup a linked server towards our domain controller (w2k) in order to retrieve information from user accounts. I've executed the following code to setup the linked server. sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource' This...

I'm trying to query our directory server for all the e-mail adresses within our domain. I know that i need to add the DC as a linked server and then use the OPENQUERY for the select statement. 1. I'm a little uncertain about the process of adding the linked server and what effects (if any?) it...

Hi I disabled a user account 13 months ago and when i enabled it again, the user can´t access it's mailbox. Error message saying something like "You're not authorized to logon". Thankful for all replyes.

I´ve created a query that consumes 100% of the CPU time when it executes and therefore i´ve scheduled it to run during off houres. Sometimes however, i need to run this query during daytime which brings the server to it´s knees and that is catastrophic since there are a lot of applications...

Is there a way to see what kind of recovery model all my db´s have using T-SQL. At my company we´re using a third party backupsystem for our sql servers. The log backups fail on some db´s due to recovery model is being set to SIMPLE. There are many DB´s in my system and i don´t have the time...

How do i write the results of a query to a text file? The query uses the "PRINT" command to display the reults from the query in the display pane in queryanalyzer, but what i want is to write the result into a text file which can be attached to a mail later on. I´ve scheduled the...