We recently migrated to Active Directory domains and we did not have to do anything with SQL 2000 sp3a to get it to work. As for the new tab on the properties display, I looked at it, but didn’t add SQL to Active Directory.
View Answer | September 20, 2004 7:28 AM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
this syntax gives me no errors in query analyzer: ALTER TABLE school ADD U int ALTER TABLE school ADD M int
View Answer | September 14, 2004 12:04 PM
Database Management Systems, SQL Server
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer | September 2, 2004 11:49 AM
Oracle, SQL Server
I would recommend that you use RMAN to create your backups. You can create a script that the operator can run that will generate hot full, hot incremental or cold backup. This is preferable to stopping the service especially if you are stopping the service through the windows interface. If you stop the service through [...]
View Answer | August 2, 2004 6:14 PM
Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, Policies, Security, Servers, Software distribution, Standard Edition, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
You could set up a scheduled task to do the backups and use net stop to stop the service and net start to start the service. Set this up in a batch file and schedule it with the credentials of an admin or at least someone who belongs to the ora_dba group
View Answer | August 2, 2004 3:04 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
What is the error text? Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?
View Answer | July 16, 2004 3:40 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
Universal Installer is the best approach.
View Answer | June 15, 2004 12:08 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
Hello, hello … Some of Microsoft’s changes to enterprise level licensing include shipping said editions without product keys. This is, the SQL Server 2000 Enterprise Edition does not require a CD-Key. Persumably that is the edition you installed … ??? Eric
View Answer | June 4, 2004 11:21 AM
SQL Server, Standard Edition 2000
You or your network admin should do the following: 1) Create a “common” SQL Service domain account (e.g., Domain1SQLService). 2) Make the account a member of the local Admin group on each server. 3) Load any SQL Server AND SQL Agent services through that account. Such accounts can/should be allowed to log on locally. However, [...]
View Answer | June 3, 2004 7:15 PM
Yes, it does. If your connection settings in TCP/IP are set to always use the firewall, FTP will use it. If not, it doesn’t know the firewall.
View Answer | June 3, 2004 4:32 PM
My preference would be to go for individual files, whose names include the date and time of the backup. Advantages being: 1. If you look at the backup directory, you can see at a glance which backups you have without having to go to msdb or the Enterprise Manager GUI 2. If you’re short of [...]
View Answer | May 19, 2004 5:59 PM
Hi. Books Online. Just as the Oracle manuals are required reading, so is SQL’s Books Online. That said, I recently picked up Ken England’s “Performance Oprimization and Tuning” and found it a VERY useful addition to the Books Online. Ken Henderson has a couple of good T-SQL books (learn T-SQL… not hard, although a bit [...]
View Answer | May 19, 2004 5:04 PM
SQL Server, Standard Edition 2000
One cheap way: in Query Analyzer, right click the database name -> Script to New Window -> Create. Wow, that’s really cheesy, but it does work. I’m sure there’s a sys table with this info though.
View Answer | May 19, 2004 4:40 PM
Yes. Used a VPN tunnel between the two firewall devices to ship the logs.
View Answer | May 17, 2004 11:00 AM
Yes, in a ASP.Net application we encrypted CC info as the SQL server was located at a site we did not control. It was very straightforward to code (VB.net). We did not performance track it as we were only reading/writing one record at a time but I would think it would be minimal.
View Answer | May 12, 2004 2:31 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
As per my experience, indexing can cause issues with the SAP database performance, Hence, indexing reorganization may be required in SAP. We did it in previous implementation. We faced with indexing problem with one of the big SAP table. The indexing created by us was causing conflicts with the indexing provided by SAP. The search [...]
View Answer | May 12, 2004 1:17 PM
SAP, SQL Server
Its really just important to understand the security SMS requires between its services and the SQL database. Microsoft suggests keeping the SQL database on the SMS server simply for performance reasons (i.e., SMS is in constant contact with the SQL database for updates, changes, monitoring, etc.). A lot of companies choose to move the database [...]
View Answer | May 12, 2004 11:23 AM