Viewing 15 posts - 5,311 through 5,325 (of 6,105 total)
The DELETE works (build the tables). I'm trying to confirm the puzzle is correctly stated in its current form. If it is, he is an evil, evil man (or rather,...
July 12, 2002 at 8:26 am
Wait. Here is the subquery:
Select
DID
from tblHeader A
inner join tblDetail B
on A.ID=B.MID
Where A.ID =...
July 12, 2002 at 8:05 am
SQL Server and SQL Server agent are running under the same account?
K. Brian Kelley
July 12, 2002 at 7:56 am
Try this:
SET @str = 'Select * FROM ' + @ProcessTable + ' WHERE ' + @SelectedColumn + ' > DATEADD (m, ' + @KeepmonthsInDatabase + ', + GETDATE())'
In my original...
July 12, 2002 at 7:03 am
The following lines are going to update every row in the table:
UPDATE tblOrderNumber WITH (XLOCK, TABLOCK)
SET OrderNumber = OrderNumber + 1
You've not included any code which...
July 12, 2002 at 6:55 am
Do you have SQLMail or SQLAgentMail talking to your Lotus Notes Server using SMTP? Microsoft has indicated that they only suggest using Lotus Notes as an SMTP server. I wonder...
July 12, 2002 at 6:48 am
What version of IIS?
K. Brian Kelley
July 11, 2002 at 12:34 pm
I'm checking with a developer friend who has had recent experience doing this. Typically I leave the file on the file system and use a pointer to it which is...
July 11, 2002 at 9:49 am
Can you post the Knowledge Base article and the hotfix link for both what the fix was that went into SP2 and what the hotfix is that broke it?
K. Brian...
July 11, 2002 at 9:47 am
Do you need a total of 64 processors in a system or do you need a system that uses the Itanium 2 64-bit processors?
If it's the latter, one of the...
July 11, 2002 at 9:45 am
The reason profiler prevents the display of such information is for security reasons. It does have counters to track when security audit events happen. (Security Audit Event Classes).
K. Brian Kelley
July 11, 2002 at 8:48 am
Then you're going to have to either grab a third-party tool like Proc Blaster as Antares has suggested or obtain a license for SQL Server 2000.
Unfortunately, I don't believe...
July 11, 2002 at 8:17 am
An evaluation copy of SQL Server can be downloaded from Microsoft at:
http://www.microsoft.com/sql/evaluation/trial/
K. Brian Kelley
July 11, 2002 at 8:14 am
We ran into this problem on our Intranet application. We had to add two lines:
SET NOCOUNT ON
SET ANSI_WARNINGS OFF
This eliminated the -1 return problem.
K. Brian Kelley
July 11, 2002 at 8:09 am
Do you need to have the capability to modify the whole table at one time? Could you instead update a single row or insert a single row instead? That would...
July 11, 2002 at 8:05 am
Viewing 15 posts - 5,311 through 5,325 (of 6,105 total)