SQL Database

MySQL database size

Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server

Pulling data from tables on different servers

I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

SQL Server 2000 hang and shrink won't stop

I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or...

Converting a log file in C#

how to convert a log file in text format into sql database Software/Hardware used: c#.net

Replication and using EMC Autostart

I am using EMC Autostart to monitor and mirror an application that uses a SQL 2000 DB. All worked well until I incorporated replication to keep certain tables synchronized with 2 other servers. The Autostasrt uses virtual names and IP's for clients to connect no matter which server is acting as...

Display Bug with CFTextArea?

Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query...

Refresh/Run SQL

We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

execute as with synonym

This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a "execute as" with a windows sql account "domain\srvc" that has sysadmin...

Error connecting to a SQL database

I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: 'intigreted security'? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the...

search Button In vb.net 2005

The code is for searching entire sql database if i enter RegistrationNo which is primary key plz help.iam getting errors. If IsNull(TextBox1) Then MsgBox "Please Enter the RegistrationNo" End If If IsNull(Me.TextBox1) = False Then Me.Recordset.FindFirst "RegistrationNo= '" & Me.TextBox1.Text &...

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...

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 IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

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.

SQL 2005 Password

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

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

Database and Log file location

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

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,...

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 John...

Unable to backup sql database.

the full error that I am receiving is Backup- \\usfshk3ap09.edcllc.net\D: DataAn unknown or unexpected database error occurred while attempting a DBCC. The file name "C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config.mdf ...

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.