Viewing 15 posts - 1,936 through 1,950 (of 1,988 total)
Can you change the sql agent service account to the administrator account instead of NT AUTHORITY\SYSTEM? So far I know local system account has no rights on any networking stuff.
If you...
September 18, 2005 at 4:03 am
Starting the profiler and tracing for any delete / truncate table / drop table statements?
September 17, 2005 at 9:34 am
What sql server version are they running and what is their service pack?
It might be a bug that was resolved in sql server 2000 sp 3
more info:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;328569
September 17, 2005 at 6:11 am
you can use a left join / inner join
if
SELECT picks.name AS Name, Count(picks.name) AS [Days Picked], Avg(picks.gain) AS [Week 1 Avg Gain]
FROM picks
WHERE (((picks.entrydate)>=#1/3/2005#) AND ((picks.entrydate)<=#1/7/2005#))
GROUP BY picks.name
ORDER BY Avg(picks.gain)...
September 17, 2005 at 6:04 am
I have no experience with adp-projects.
But probable you need to restore /attach/recreate the TimeandBill, Robin databases on your sql server.
There is nothing in the book or on the cd that provides...
September 17, 2005 at 6:00 am
Varchar will only store the actual data removing trailing white space, conserving diskspace in the process.
September 16, 2005 at 7:49 am
see
http://support.microsoft.com/lifecycle/search/
for life cycle management of microsoft products.
General support for sql server 7 will end at the first of 2006.
General support site for sql server
September 15, 2005 at 11:16 am
1)What is Windows 2000 Compatible Access Group ?
2)Sql server version:
SELECT @@VERSIONor
xp_msver (see books on line)
September 15, 2005 at 11:04 am
what recovery model are you using (full, simple, bulk)?
Truncate table isn't logged
The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. It is almost...
September 14, 2005 at 3:18 pm
This question has many answers.
The number of users mostly depends on your hardware/ quality of software.
A quick internet searching gives a try to compare sql server 2000 vs oracle 9
September 14, 2005 at 3:11 pm
SELECT
CF.FileId
,CF.Transid
From #UsFavs UF WITH (NOLOCK INDEX=IDX_2)
, Cus_file CF WITH (NOLOCK)
Where
UF.Transid = CF.Transid
ORDER BY P.LastNm,P.FirstNm
I'm not familiar with NOLOCK clauses, but
Why...
September 14, 2005 at 2:53 pm
In case you can store some profiles (either permanent or temporary) to store all the requirements
profile_qualifications:
profileid
qualificationid
required /*required might be weighted like 0 or -1 (@MyconstantforRequired
) for required, >(=)0 for non-required*/
/*Variables :
September 14, 2005 at 12:08 pm
I wouldn't rely much on the order of triggers. Rather have it in one.
You have first, last, and between (with no order)
September 14, 2005 at 11:23 am
not as versatile
select MustHave.candidateid,NiceToHave.Extras
from
(
select candidateid
from dbo.Candidate_Qualifications Candidate_Qualifications
where qualificationid = A
OR qualificationid=B
OR qualificationid=C
group by candidateid
having count(QualificationID)=3 /*COUNT 3 = have A,B,C*/
) AS MustHave
left join /*All of musthave, Nice to have if...
September 13, 2005 at 2:40 pm
I would save your changes in the local dataset, and modify the insert/update/delete commands of the dataset to use your stored procedures to insert/update/delete.
September 13, 2005 at 2:21 pm
Viewing 15 posts - 1,936 through 1,950 (of 1,988 total)