SQL Server Upgrade and Server Move
I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this [...]

Answer Question   |  September 11, 2008  3:23 PM
SQL Database, SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows 2000 Server, Windows Server 2003

SQL 2000 and 2005 Offline Table Reindex Determination
Hello, I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want [...]

Answer Question   |  September 10, 2008  2:59 PM
SQL 2000, SQL 2005, SQL Database

I need to move a sql 7.0 database to a different server running sql 2005.
What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

Answer Question   |  August 13, 2008  2:21 PM
SQL 2005, SQL Database

List the names and addresses of all employees who are Mangers
Employee (emplD, fName, lName, address, DOB, sex, position, deptNo*) Department (deptNo, deptName, mgrEmplD*) Project (projNo, projName, deptNo*) WorksOn (emplD* projNo*, hoursWorked) where Employee contains employee details and emplD is the key. Department contains department details and deptNo is the key. mgrEmplD identifies the employee who is the manger of the department. There is only one [...]

Answer Question   |  August 13, 2008  12:23 PM
SQL Database

write multiple images from SQL database using response.binarywrite
It seems I am able to write a single image with the following code: ID1 = replace(request("ID1"), "'", "''") Dim connStr connStr = Application("DSNFPT") Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by id desc", connStr, 2, 4 If Not rs.EOF Then Response.ContentType [...]

Answer Question   |  August 11, 2008  10:48 PM
Response.BinaryWrite, SQL, SQL Database, VBScript

Limitations on databases per instance in SQL Server 2000 and SQL Server 2005
Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?

Answer Question   |  August 4, 2008  2:26 PM
SQL Database, SQL Server 2000, SQL Server 2005

Setting the ODBC in SQL Server 2005
I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

Answer Question   |  August 4, 2008  2:23 PM
ODBC, SQL Database, SQL Server 2005

Efficient storage of survey answers
We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given question [...]

Answer Question   |  August 1, 2008  8:57 PM
Database design, SQL Database

SQL Connection
Using VB6 How can I build a connection code to connect to SQL DB

Answer Question   |  July 30, 2008  5:33 AM
Database connectivity, SQL Database, VB, Visual Basic 6

Copying databases in SQL Server 2005 and SQL Server 2008
In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

Answer Question   |  July 28, 2008  3:39 PM
SQL Database, SQL Server 2005, SQL Server 2008

Automation of SQL Report
Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

Answer Question   |  July 28, 2008  12:11 PM
Microsoft Excel, SQL automation, SQL Database

Creating a database on two nodes in a SQL Cluster
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?

Answer Question   |  July 18, 2008  6:54 PM
Clusters, SQL Database

Creating SQL databases for customer data
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place all [...]

Answer Question   |  July 17, 2008  4:52 PM
SQL Database

VB.NET code ideas on a SQL Server
What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?

Answer Question   |  July 17, 2008  4:50 PM
Code, ComboBox, SQL Database, VB.NET

SQL Server 2005 within MS Access VBA
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code [...]

Answer Question   |  July 3, 2008  3:44 PM
Microsoft Access, SQL Database, SQL Server 2005

Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights [...]

Answer Question   |  July 3, 2008  5:21 PM
Database backup and recovery, Database security, Security, SQL Database, SQL Server

Code differentiating between SQL Server 2000 and SQL Server 2005
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?

Answer Question   |  July 2, 2008  7:28 PM
SQL Database, SQL Server 2000, SQL Server 2005

msforeachdb
Could not locate entry in sysdatabases for database, when using msforeachdb

Answer Question   |  June 11, 2008  4:22 PM
SQL, SQL Database

Why might a maintenance plan fail to generate a SQL Server job?
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one instance, only the [...]

Answer Question   |  May 23, 2008  3:34 PM
SQL Database, SQL Server performance tuning

Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we’re having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don’t know how to move the SQL database along with [...]

Answer Question   |  May 8, 2008  2:54 AM
ASP, Database migration, SQL, SQL Database, VBScript, Web development