Adding a password to a SQL Server 2005 database
We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

Answer Question   |  January 14, 2009  4:32 PM
Access Database, Microsoft Access, Password management, SQL Server 2005, SQL Server databases

Differences between SQL Server 2005 and SQL Server Express
How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?

Answer Question   |  January 13, 2009  4:28 PM
SQL Server 2005, SQL Server Express Edition

Creating a username and password on a SQL Server database
How we can create a username and password on my SQL Server database?

Answer Question   |  January 12, 2009  4:26 PM
Password management, SQL Server databases, SQL Server security

stored procedure component
what is the difference between the way of using storedprocedure component in delphi5 and delphi7?

Answer Question   |  January 12, 2009  1:36 PM
Delphi, Delphi 5.0, Delphi 7.0, Stored Procedures

sql server 2005 mirroring
i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

Answer Question   |  January 9, 2009  5:37 PM
Server mirroring, SQL Server 2005, SQL Server backup and restore, SQL Server Mirroring

DB2 SQL Confusion
I am failing to understand why the following won’t work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don’t understand why I get higher values on SUM(d2.amt) than [...]

Answer Question   |  January 9, 2009  4:46 PM
DB2, DB2 SQL, SQL

Tricky Grouping problem!
I am trying to migrate some Employee absence data, from one table to another. The data currently looks like: Employee, Date, Reason ———————— dave,01/01/08,sick1 dave,02/01/08,sick1 dave,03/01/08,sick2 dave,04/01/08,sick1 dave,05/01/08,sick1 bob,01/01/08,sick1 bob,02/01/08,sick1 bob,03/01/08,sick3 bob,04/01/08,sick3 bob,05/01/08,sick3 The data needs to group by Employee, Consecutive dates, and reason. Output would look like: Employee,From,To,Reason ———————— dave 01/01/08 02/01/08 sick1 dave [...]

Answer Question   |  January 9, 2009  1:53 PM
SQL, SQL Database, SQL Database Grouping

How to check the existence of a Column in SQL Server 2000?
- using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

Answer Question   |  January 12, 2009  9:30 AM
SQL queries, SQL Server 2000, SQL Server 2000 queries

Microsoft ISA Server 2000 – Firewall service deliberately stopped – Want to allow ping.
Hi. This may seem really stupid, and well it is. I have a customer who is running ISA 2000 primarily as a web cache. It is not used for security in any way, in fact, users can just turn off their proxy settings and access the internet, so security is not really an issue here. [...]

Answer Question   |  December 14, 2011  12:10 AM
Firewalls, ICMP, Internet Control Message Protocol, ISA Server, ISA Server 2000, Ping, Web security, Windows Server 2003

Find Next SQL AutoNumber
Hi, I was wondering if there is a way to find the next autonumber in a SQL table before inserting the record? I tried just looking at the previous number and adding one but if I delete the last record then this wouldn’t work or if I delete all the records then the number won’t [...]

Answer Question   |  January 11, 2009  6:14 PM
SQL, SQL AutoNumber, SQL tables

Changing Compatability Level from 65 to 80
SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?

Answer Question   |  January 11, 2009  6:06 PM
SQL Server 2000, SQL Server 2000 SP4, SQL Server Compatibility Level, SQL Server database

Upgrading to SQL Server 2005
I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

Answer Question   |  January 11, 2009  3:31 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

Creating tables on a SQL Server
I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want [...]

Answer Question   |  January 15, 2009  3:29 PM
SQL Server, SQL Server Scripts, SQL Server stored procedures, SQL Server tables

Finding the public key in an asymmetric encryption on SQL Server
How do I know what the public key is for a given private key in an asymmetric encryption on a SQL Server?

Answer Question   |  January 8, 2009  3:28 PM
Public Key Encryption, SQL Server

How to backup a SQL Server database
Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible… What is our best option?

Answer Question   |  January 9, 2009  10:40 AM
SQL Server 2005, SQL Server 2005 backup, Veritas Backup Exec 9.1

Is there a query to retrieve datatypes from SQL stored procedures?
I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = ‘<tablename>’ and column_name = ‘<columnname>’ Along these lines, is there a way to retrieve datatypes from SQL Server stored procedures?

Answer Question   |  January 7, 2009  4:41 PM
SQL Server 2000, SQL Server stored procedures, SQL Server tables

Running scripts in SQL Server 2005
How can I run scripts in SQL Server 2005?

Answer Question   |  February 3, 2011  4:39 PM
SQL Server 2005, SQL Server Scripts

What should our next contest be on ITKnowledgeExchange.com?
We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. [...]

Answer Question   |  January 11, 2009  4:02 PM
AS/400, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP

SQL Cursor to use or not to use
Hi, I’ve been told to never use cursor in SQL, because of possibility of memory leak, etc. But I have no idea of how to implement my script without them. My script doesn’t execute anything on the database, it simply use cursor to create another TSQL script that does the execution. EG. open cursor to [...]

Answer Question   |  January 7, 2009  1:39 PM
SQL, SQL Cursors, SQL scripts, T-SQL

Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008
I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest me ASAP. [...]

Answer Question   |  January 7, 2009  9:23 AM
SQL Server 2000, SQL Server 2000 encryption, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 encryption, SQL Server migration