Getting thousands of these errors when running an application.
==========================================================
Database Error: EHC_SQLDBRecordset::IsEmpty():
_com_error ex...
Title says most of it. I'm trying to get MSDE to install on Windows XP Pro, and every time, it gets near completion, stopping and starting the service, then fails, rolling back the installati...
Installed a named instance of SQL server and ever since been constantly getting errors like:
SQLSTATE = 08S01 Native error = 11
Error Microsoft (odbc sql server driver)
Shared memory genera...
I know all about the benefits of stored procedures, but are there any drawbacks?
Thanks.
Recently (yesterday) started getting errors on a previously good SQL2000 database. Error log gives a udopen error - Operating system error 32(The process cannot access the file because it is b...
Hi
I'm creating a temporary table which may have dynamic columns. (so could have 5 columns or it could have 10)
I'm including a field called StyleID which i need for some calculations in...
Hello,
If i turn on torn page detection i understand it detects
torn pages the question is does it corrects that page or
it shows in the error log or what it does other than detecting.wha...
What happens if I delete LDF File?
How can I often shrink it, since it grows indefinetly?
we have two type of authentication in sql server
1.windows only authentication
2.mixed mode
my sql server in mixed mode.i have the password for user sa.those who does not know this passw...
let say here is my table
tableA
id amount
----- ------
1 20
2 30
3 50
4 20
i want a query output like
id amount cummulative_amount
----...
I have a call to a stored procedure (SQL 7). The stored procedure returns multiple recordsets. The asp page that performs this has been working fine for the last few weeks and all of a sudden ...
I just started using a new hosting company for my sql web site and I'm having problems connecting to my db through my enterprise manager.
I have 2 machines. One with NT and one with XP Pro...
My system is running a Goldmine database on a SQL7 - NT4 SP6 system. The transaction log has been allowed to grow to almost 7 Gb. Database details are as folows;
Database file - one file
...
I'm trying to use ALTER DATABASE to set CONCAT_NULL_YIELDS_NULL to OFF. Like this:
ALTER DATABASE hr SET CONCAT_NULL_YIELDS_NULL OFF
That executes successfully and then when I run:
SEL...
Security question with MSSQL and locking down the Server
I would like to lock-down a SQL server to allow only qualified applications from access the SQL server. The catch, I cant not use g...
My program was written by Visual basic and the database is MS SQL Server.
My Client computer had installed MDAC 2.6 at Win 98. It connect successful and most of the works that connect to da...
I have 2 entries in a table that I can't delete. The error that I am getting is the following:
Key column is insuffient or incorrect. Two many rows were affected by update.
Hi,
I need to find a software to connect to a SQL Server and create Classes based on the tables of my data base.
I browsed slightly the net but didn't find anything.
Anyone of you ...
Hi all,
I have a MSDE server installed and I'm trying to connect to it from a client. I can ping the server-machene but can not connect to it with my vb.Net application. I get the message "...
At one time I posted a question and acperkins responded with the following answer. It works great but I just need a breakdown of the logic behind it. I am new to SQL and am asking for a step b...
I am trying to use the UpdateText and WriteText functions from an ASP page. I've read all I can stand on the functions :)
My questions are:
1. Can I use these functions by executing a s...
I used the immediate if in MySQL like IF(Gender = 'f','female','male') as Gender in sQL query.
Since i am in a condition to switch over my component to MSSQL , I Want to know whether there i...
I am trying to create a backup routine that copies some tables, attaching the date to the end. I have created a local package to do most of it, I just need the current date adding to the newl...
hello experts,
i have a database that stores unicode data... i have no problem updating/inserting data using the regular sql staments like..
"insert into tblSAMPLE (fld1,fld2,fld3) value...
I made an interface between a Progress database and a SQL Server database. In a table of the Progress database a field has defined as a character field, with a format of X(30). However, some o...
