Backup of large amount of data
I need some suggestions on a backup procedure. Here’s what I am backing up to a 3.5 TB fileserver (RAID 5). 200 GB of application and document files from an application server. About 200 GB each on four medical imaging workstations. 100 GB of SQL database files from a SQL Server 100 GB of backed [...]

Answer Question   |  August 25, 2009  6:49 PM
Backup & recovery, Data backup, File servers, NAS, RAID, RAID 5, SQL Database

Connecting to a SQL Server 2005 database through LAN
I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESSSERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

Answer Question   |  March 5, 2011  9:06 AM
SQL Database, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Management Studio 2005

Transact SQL stored executed from AS/400 CL program.
How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

Answer Question   |  June 10, 2009  2:39 PM
554 transaction failure, AS/400, CL Program, SQL Database, SQL Server 2000, T-SQL Stored Procedures

SQL 2005 Password
If you move a sql 2000 database to sql 2005 which admin password does it have now.

Answer Question   |  June 6, 2009  3:12 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords

Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS
How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

Answer Question   |  May 30, 2009  5:01 PM
SQL Database, SSIS, SSIS 2008, SSIS Package 2008

Database and Log file location
How do I change the default location for database and log files during a SQL 2005 installation?

Answer Question   |  May 30, 2009  7:06 PM
SQL 2005, SQL Database, SQL Installation, SQL Log Files

Retrieving Records based on Record Selection from another table
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables, equipment, etc that are in one table. For [...]

Answer Question   |  May 22, 2009  8:46 PM
Access Database, Microsoft Access, SQL Database

Removing data in a column after a hyphen
We imported a text file and one of the columns has first and last names in it. However, there is sometimes a hyphen with a title after the name. We need to create a SQL statement that will look for the hyphen and remove it and anything following it. Example: Column 1 Column 2 02/18/09 [...]

Answer Question   |  May 20, 2009  4:39 PM
SQL Database, SQL Database Formatting, SQL statement

Unable to backup sql database.
the full error that I am receiving is Backup- \usfshk3ap09.edcllc.netD: DataAn unknown or unexpected database error occurred while attempting a DBCC. The file name “C:Program FilesMicrosoft SQL ServerMSSQL$SHAREPOINTDataSTS_Config.mdf ” is too long to create an alternate stream name.

Answer Question   |  May 14, 2009  12:04 PM
SharePoint, SharePoint backup, SQL Database

Video hosting
I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.

Answer Question   |  March 30, 2009  7:46 PM
PHP, SQL, SQL Database, Video hosting, Web development, Website design

Connectionstring for paradox db password protected
Hello everybody, Searching for answers I’ve found this insteresting page!! I’ve created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended Properties=’DSN=Paradox;DBQ=C:myDb;DefaultDir=C:myDb;DriverId=538;FIL=Paradox 7.X;MaxBufferSize=2048;PageTimeout=600;’;Initial Catalog=C:myDb; I can’t find how to connect to a protected one. I’ve checked some links that you posted as http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForParadox but there [...]

Answer Question   |  March 26, 2009  4:34 PM
ASP, SQL Database, SQL Database Security, SQL Query

table row values for column headers
Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint – year of value) Quarter (smallint – year quarter 1-4) Area (smallint – FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price information over time for [...]

Answer Question   |  March 19, 2009  7:25 PM
SQL, SQL Database, SQL tables

Reporting and Mirrored SQL2005 DB
Can i access the sql2005 mirrored db via crystal reports for reporting

Answer Question   |  March 10, 2009  8:04 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring

VB.NET code to search if a record already exists or not
Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I’m sending you the code. Please [...]

Answer Question   |  April 19, 2013  9:49 AM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005

Crystal Reports last twelve months
I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process [...]

Answer Question   |  March 13, 2009  10:00 PM
Crystal Reports, SQL Database, SQL queries

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 configure the database instance to respond slowly for any request?
With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can be connect to [...]

Answer Question   |  December 24, 2008  7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server

Finding which columns contain data in a table
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table [...]

Answer Question   |  December 10, 2008  3:42 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database

Transfering SQL files from location to colo
What is the fastest way to get the SQL database files transfered over? i.e. zip the files

Answer Question   |  December 7, 2008  12:26 AM
SQL Database, SQL Database Transfer

Users in a data base
How many users concurrents does the database SQL support???

Answer Question   |  December 4, 2008  9:36 PM
SQL Database, SQL Database Concurrent Users