-
Creating a login in SQL Server 2000 Enterprise Manager
Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."31 Dec 2007
-
Creating a SQL Server user authentication schema
Learn how to create a SQL Server user authentication schema having password and tracked data changes requirements and how it involves Windows authentication.31 Dec 2007
-
SQL Server connection lost when SA password is changed
Learn why SQL Server 2000 connection is lost on the client side when database administrator changes 'SA' password on the SQL Server domain.31 Dec 2007
-
Code to connect SQL Server 7.0 to Visual Basic 6.0
Get the code to connect SQL Server version 7.0 to Visual Basic 6.0.31 Dec 2007
-
Could a join of encrypted SQL Server data have a problem?
When encrypting SQL tables that have joins in SQL Server 2000, learn about possible problems that may arise with different data values in those tables.31 Dec 2007
-
How to set SQL Server password for SA login
Learn how to set a SQL Server password to an SA login and why you can not set this account for access to separate SQL Server databases.31 Dec 2007
-
Basic SQL Server security principles you can't afford to miss
Protecting your SQL Server databases is as simple as practicing basic security principles. Here, IT security specialist Kevin Beaver points out often-overlooked security weaknesses, such as DBAs us...20 Dec 2007
-
Custom VB.Net scripting in SQL Server Integration Services
Get the power of Visual Basic.Net within your SQL Server Integration Services (SSIS) package by adding the Script component. In this tip, you'll get the step-by-step method on how to add a Script c...18 Dec 2007
-
Adding non-clustered indexes to SQL Server columns
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server databases.14 Dec 2007
-
View query execution plan in SQL Server with this method
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree cost.14 Dec 2007
-
Change collation to SQL Server 2005 after upgrading databases
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and SSIS.13 Dec 2007
-
SQL Server encryption vs. hashing for data security
Choose carefully between encryption and hashing algorithms in SQL Server 2005 because not all methods fit all data security purposes.11 Dec 2007
-
How to increase server memory used in SQL Server 2000
Change SQL Server memory settings by starting with sp_configugure to view configurations. Next follow these steps to take with the operating system (OS).10 Dec 2007
-
Upgrade databases to SQL Server 2005 after server upgrade
One upgrade method is to uninstall SQL Server 2000 and then install SQL Server 2005 and attach databases. Learn how to upgrade those databases.10 Dec 2007
-
Upgrade to SQL Server 2005 or SQL Server 2008?
Upgrading to SQL Server 2005 may seem like a waste of time, considering SQL Server 2008 is scheduled for release in Q2 of 2008. Get an expert's opinion.10 Dec 2007
-
Merge replication to keep SQL Server databases in sync
Keep SQL Server databases in sync with merge replication and limit connectivity issues. Use this resource for help setting up merge replication.10 Dec 2007
-
Can SQL Server 2005 EE be set up on Windows XP Pro?
Get that answer and more information on SQL Server and Windows platforms.10 Dec 2007
-
Retrieve deleted tables in SQL Server
Have SQL Server tables been deleted from an application? Find how to retrieve the tables via Lumigent's Log Explorer.07 Dec 2007
-
Can SQL Server 2000 work on Windows 2003 platform?
Learn what's needed for SQL Server 2000 to be installed on Windows 2003 platform.07 Dec 2007
-
Should developers have permissions to SQL Server production queue?
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH EXECUTEAS.06 Dec 2007