|
|
|
January 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Upgrading MY preformance Posted by vncntj NO[at]SPAM hotmail.com at 12/31/2003 10:59:50 AM Hello all! I'm a newly appointed database administrator and have been
struggling with my consious about what would make me an excellent
database administrator. I've worked in Access for years and know that
if your comfortable with:
1. writing expressions
2. writing some VBA
3. the basics ...more >>
Derived Table Problem Posted by w.white NO[at]SPAM snet.net at 12/31/2003 10:27:15 AM I've created this:
SELECT
c.ProjectID,
Count(c.ID) as 'Registrants',
Count(dt.Hits) as 'Submissions'
FROM
CME_TBL c
JOIN
(SELECT ProjectID, Count(*) as Hits FROM CME_TBL
WHERE evalDate Is Not NULL OR testDate Is Not NULL
GROUP BY ProjectID
) dt
ON c.ProjectID = ...more >>
DBException (Communication link failure) Posted by second714 NO[at]SPAM hotmail.com at 12/31/2003 10:15:24 AM Hi,
with SQL 2000 and Windows 2000, we're getting lots of this error message
"Communication link failure" from our C++ application.
Any idea why?
Thanks,...more >>
internalization of (generic) application layer software to the database TSQL Posted by mountain man at 12/31/2003 3:49:06 AM Greetings to all database professionals and laymen,
Let us make a bold assumption that we have developed a software
tool for the SQL Server environment which simply acts as an interface
between an end-user in an organization and the database, through
the exclusive use of stored procedures whic...more >>
Cannot create ADO connection to DB anymore... Posted by (Pete Cresswell) at 12/31/2003 2:42:27 AM I rebuilt my machine a few weeks back - re-installed the developer version...
The app in question can see all it's tables in the SQL back end via ODBC and
everything looks normal via Enterprise Manager, but I can no longer create
an ADO Connection.
Source code is unchanged, what's changed i...more >>
Accessing Active Directory using SQL Server 2000 Posted by btugg NO[at]SPAM yahoo.com at 12/30/2003 2:44:00 PM Hello All,
I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in ...more >>
Simple but complex report Posted by AstrA at 12/30/2003 12:48:23 PM Hi All
Wondered if you could help.
Basically I have 2 tables that contain all the data I want for my report,
but I need to put it in a particular way and I need to display it in an ASP
page so my queries got to be manual rather than an MS Excel/Query 'munge'.
To be honest, the report itse...more >>
Set Difference (I think) Join Posted by JayCallas NO[at]SPAM hotmail.com at 12/30/2003 11:12:06 AM I needed to get a list of rows from a table that is not present in
another table.
My problem lies in the fact that I only want SOME of the rows in table
2 used in determining existance. This happens because table 2 contains
historical data (based on report date). Table 1 contains my production...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL newbie Posted by Markus Ratzesberger at 12/30/2003 7:28:22 AM Hallo!
Ich habe bisher nur mit "alten" relationalen Datenbanken wie dBase
gearbeitet. Ich würde zukünftig gerne MSDE bzw. den SQL Server oder auch
mySQL einsetzen. Was empehlt Ihr zum Einstieg, welche Literatur, gibt es
Online Tutorial, ... ? Speziell alles rund um SQL. Vielmehr wie
Select ...more >>
SQL Update query to copy data Posted by rdraider NO[at]SPAM sbcglobal.net at 12/29/2003 8:51:49 PM I'm a bit of a newby to creating update queries so I was hoping those more
experienced could help with what should be a simple query. I do know to
create backups and test on a test database first.
I need to copy an items' cost from location 'CA' to the cost in location
'OH' when the cost in '...more >>
Inter-database stored procedures and permissions Posted by junk NO[at]SPAM olaes.net at 12/29/2003 3:25:20 PM Hello all, this is my second post to this newsgroup. It's a question
about stored procedures and permissions and how these behave between
databases.
Here's the scenario. I have a database that stores information for a
system "A", and I have a different database on the same SQL server
that sto...more >>
Find blocking process Posted by second714 NO[at]SPAM hotmail.com at 12/29/2003 1:03:09 PM Hi,
we're having a problem with SQL 2000 and Opta 2000 JDBC driver
where there is large update running and at the same time,
read is blocked for a while.
We're looking for a way to catch this blocking process
and if it last more than 10 minutes, then email or send out a message.
I know sp_lock...more >>
Linked Server to Oracle Posted by Sudhesh NO[at]SPAM mail.com at 12/29/2003 9:44:22 AM Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. H...more >>
xp_sendmail with long text messages Posted by y.ziesche NO[at]SPAM vhb.de at 12/29/2003 2:00:40 AM Hi everybody,
i try to send messages longer than 7990 characters from a text field
in SSQL2000. Unfortunatly the messages get cut off after 7990
character.
I did everything which is described in BOL (see below). It does not
solve the problem. Upgraded to newest Outlook Client and tried to s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |