I run MSDE on a Windows XP Server and i found that my database was marked as "suspect" by Enterprise Manager and its icon become gray.
I detach that database and try to re-attach it but there...
This morning system performance was degrading as the number of the system processes was exploding. Normally I have about 20 processes running on a database (master..sysprocesses), but in one h...
I am running Windows SBS 2003 with SQL Server 2005 (installed with Backup Exec 11d) and I am getting the following error in my event logs:
SQLBrowser event ID 3
The configuration of the Ad...
hi experts, I created a script on sql server 2005 to make my database to sql server 2000, so i got the script and i run it, anyway, now i have the database to sql 2000, than i try to attach on...
Select OrderID,
'Sell--' + Convert(varchar(24), sum(CAST(Price AS DECIMAL(13,2))) )
From OrderDetail
GroupBy OrderID
I want to display price as varchar but somehow above code send an f...
Hi experts, does anyone know what the root cause of the issue below is? The issue occurs when my website connect to a MS SQL database on another server. It seems to only occur when retrievi...
I have a database called "technical support"
This has a log file called "TechnicalSupport2K_log"
The database is around 250MB but the log file is 6.5GB
Each night I run a backup command to ...
Hi,
I ran the job and to execute a SSIS dts package in sql 2005 server, I got the following error message:
Thanks for your help!
Date 1/25/2008 4:52:00 PM
Log Job History (Survey R...
dear experts,
i created a job schedule using Database Maintenance Plan. now i want to change the schedule but encountered this error message:
Microsoft SQL-DMO (ODBC SQL State : 42000)
...
I am using Microsoft SQL Server 2000, now the log file size (.ldf) increase quickly up 50GB and the hard disk size can not handle anymore. I tried to backup the log file into a partition size ...
I feel really silly asking this question.
What is the formula for percentage? If I have a total of 1251 and sold 47 what is the percentage of tickets sold.
Thank you for not laughing to...
I realise this question has no doubt been asked and answered many times, however I'm asking it anyway.
I need to convert a varbinary data type to Varchar so the results are viewable to cert...
We are getting this error in event viewer on one of our SQL 2000 servers:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
...
For the life of me I can't figure out why this is not working.
My SQL Server is set to using US dates. I have a list of dd/mm/yyyy formatted strings that I would like to update the smalldat...
Will running a defragging tool on a SQL Server adversly affect the data on it?/What is the proper way of defragging a sql Server?
Just a quick question. I need a way to strip part of a field out, the amount I need to strip out is variable but it always the last part of the string/field. I need to do this purely within SQ...
Hello, I am migrating some data, and I need to get rid of white space while doing so...
Here is the method that I am using to move the data, fairly straightforward...
However, when I move ...
Hello,
I have a query and I want to retrieve the last 10 rows instead of the first 10 rows.
I know that the typical way is to just switch the order that you sort on.
But, I need the b...
We have SQL Server 2000 installed on a Windows 2000 Proffesional machine. As this is not a suggested solution the installation has to be moved to a Windows 2000 Server machine.
I need to kn...
I have a SQL server Database that shows "<Database name>(Loading)...but I cannot be able to stop it. I tried to detach it but I got a message cannot be able to detach a Database that is in a r...
Hi,
I am using a SQL Server 2000 DB, interrogated by Enterprise manager.
I can SELECT as:
SELECT c_AnswerMutli.*
FROM c_Applicant
INNER JOIN c_AnswerMulti ON c_Applicant.id = c_An...
Looking for the most efficient SQL query to return rows that contain any non-numeric value in a specific field. The field is of datatype varchar, but I must identify any entries that contain ...
Hi guys 'n gals,
What is the easiest way to copy a Table from one database to another, which are located on the same server?
I'm using SQL Server 2000, if that makes a difference?
...
Hi,
Please kindly assist how can we convert on runtime from EST to CST?
select convert(EST,CST,DTStart) from MyTable
Thanks.
Hi,
Ive got a stored procedure that is called from my ASP page. One of the parameters that is passed in like so:
.Parameters.Append .CreateParameter("@strAction", adVarChar, adParamInput...
