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, 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...
In an sp i'm writing, I need to convert an integer value to a string. I usually do this with the cast() function. But this time, I need to left pad the string with zeros. So how do I do this?
...
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...
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...
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?
Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.
...
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 ...
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 ...
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)
...
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 ...
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...
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...
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...
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...
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...
Hi,
Please kindly assist how can we convert on runtime from EST to CST?
select convert(EST,CST,DTStart) from MyTable
Thanks.
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 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...
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 ...
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).
...
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...
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...
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...
New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s),...
