Search results for query: *

Im running SQL 2008, and I have just migrated all my datafiles (including all system dbs) to new LUNs. I was able to change all the paths from the original install to point to the new replacement LUN with the exception of one. In SQLServer Configuration Manager, for MSSQLServer Service on the...

Im having a problem in SQL2005 with job failure notifications. They are working at the moment (Im aware that agent sometimes needs to be restarted when its not working) but all the notifications are being sent via netsend instead of smtp. Is there some setting somewhere that forces it to use...

Does anyone know how to flush the buffer pool for this (aside from restarting SQL svc)? Right now the AWE allocated (KB) is showing ~60GB but AWE is not enabled and I am getting errors from MOM since 98% of memory is begin consumed by this.

For SQL 2000 (SP4) on Win2K3 I need to start reporting on failed login attempts for several servers in the organization. I have set the audit level to capture the failed attempts. Since that only appears to write to the Application event log and SQL logs, is there any other place that those...

I have an SQL2000 Ent Ed.(os Win2K3) Active/active cluster that it was suggested that I use transactional replication to alleviate slow responses to reads when updates are occuring. Personally, I would rather just improve the code than resort to maintaining the replication. Is it even possible...

I need to show object level access rights for every object in our BOE XI R1 environment for Sarbanes-Oxley. Does anyone no a systematic way of doing that? Basically, I need to query against the repository to display each users rights to each object. Thanks, Patrick

Has anyone ever had to recover deleted local DTS Packages in SQL2000. I think it could be done by restore a backup of msdb, but I'm not sure where to go from there. Thanks, Patrick

(SQL2000 std SP3a on Win2k3) One of my databases is show negative free space of 9000% in Quest spotlight and 0 MB free in SQLEM when I view the db properties. Does any one know how to correct those stats? I have already done several DBCC CHCKDB and CHECKTABLEs on that database. I suspect it...

I am in the process of setting up my first active/active cluster. I ran the Cluster setup on one server an then added the node from the second. Am I missing something as far as actually getting the active/active part to work? I can see all the resources as groups on Node A on (drives E, G, S $...

I'd like to be able to set one size for the labels on my chart or at least force them to have the label on one line. Right now it seems crystal set the length and decides whether to make a second line. For example, my chart has a data label: 'Count of really important stuff' but no matter what...

I'd like to be able to set one size for the labels on my chart or at least force them to have the label on one line. Right now it seems crystal set the length and decides whether to make a second line. For example, my chart has a data label: 'Count of really important stuff' but no matter what...

I just upgraded to BOE XI from CE10 and migrated all objects from CE10 to XI repository. Now when I go into Authentication in the CMC I get errors in the LDAP, windows AD, and WindowsNT tabs. ERRORS are as follows: LDAP - Unexpected error: Item SI_SSO_VENDOR was not found in the collection...