I am unable to set the value for the field named "description" in the insert statement, but I can use the update statement to set it's value in QA....
- happiness begins where selfishness ends - don't let making a living prevent you from making a life - the best thing a father can do for his...
I have a database in SQL2k that I need to run a summary query against for my users to access from an intranet ASP page. It is a very simple query,...
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT...
I am hoping there is a simple answer to this and that I am just not seeing it right now. <br /><br />I want to write a select statement that gives me...
There are 2 instances of SQL 2000 on a server. The main instance is fine, the other has occasional problems. Generally what I do is check the...
I have 4 scheduled DTS jobs that have been running without error for 3 years. They truncate SQL tables and import a text file into the tables. These...
I expect this to a simple answer that I am just not seeing! lol I have tried this many different ways, and every time that I attempt a tsql 'select...
I am throwing this out here in case someone has seen something similar. We have a third-party app that is SQL based. The app connects to SQL with an...
Is there anywhere that more detail is listed on this error? I cannot find a similar error to the one that I am receiving, nor have I been able to...
I have SQL 2000 client tools on my PC (XP), which I use to administrator 5 SQL servers. Two days ago Enterprise Manager started taking forever to...
I've been seeing instances where a trigger on a table either does not fire, or it does not do the necessary update. I had a quick look around in...
Over the weekend, I upgraded a SQL 2k (Win 2k) server to sp3a and I also changed the account that the SQL services start under. This server also has...
A few years ago, the MIS department that I worked for was inspired to do some writing.... We wrote "The Perverted Geek's Box of Valentine's Candies"....
I was a programmer and a consultant most of my career, specializing in databases. After a layoff 2 years ago, I found a job that utilized my...
I determined from my research that these are files that our Veritas Backup Exec program may have created. My question is what should I do with them?...
Separate names with a comma.
