Viewing 15 posts - 646 through 660 (of 662 total)
September 26, 2002 at 3:46 pm
Need another ' at the end try
Select '\\Chicagofs\Ameritech\Sbc\''ECM.DM.LIST.0001000037.TEST'''
and you get ...
September 26, 2002 at 3:38 pm
Try a comma delimited list as one parameter and strip it in the stored procedure
September 25, 2002 at 2:44 pm
Is this what you want, at least no cursor?
Create Table SomeMaster(RecId Int,a TinyInt,b TinyInt,c TinyInt)
Go
-- Populate
Insert SomeMaster values(1,11,12,13)
Insert SomeMaster values(2,21,22,23)
Insert SomeMaster values(3,31,32,33)
Insert SomeMaster values(4,41,42,43)
Go
Declare @intCurrent Int,
...
September 23, 2002 at 6:47 pm
See articles at
http://www.ntfaq.com/Articles/Index.cfm?ArticleID=14402
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q271835&
Can you get the commands been send by these processes?
July 23, 2002 at 4:35 pm
Drop Table TestII
GO
CREATE TABLE [dbo].[TestII] (
[Ext_Price] [Decimal](28, 3) NULL ,
[Measure] [Decimal](28, 3) NULL)
GO
Insert TestII Values(.500,1.000)
Insert TestII Values(.600,1.000)
Insert TestII Values(1.000,1.000)
GO
Select Sum(Case When IsNull(Measure,0)*IsNull(Ext_Price,0)=0 Then 0
...
July 11, 2002 at 3:58 pm
What is the values for disk counters like PhysicalDisk()\Avg Disk Queue Length, PhysicalDisk()\Current Disk Queue Length. Did you run DBCC CHECKDB('DB_Name',REPAIR_REBUILD) WITH ALL_ERRORMSGS recently?
July 7, 2002 at 9:05 pm
The supplied error message, is this the error message in the SQL Agent error log?
March 7, 2002 at 3:26 pm
How about trying to reduce the 5 min?
What about publishing the query and tables / indexes on this thread. How many bytes in the result set. Sounds like an interesting...
February 20, 2002 at 8:06 pm
SELECT ISNULL
((SELECT COUNT(*)
FROM aaTABLE1 AS a2
WHERE a2.a <...
January 17, 2002 at 12:55 pm
UPDATE Item
INNER JOIN CSV
ON Item.ItemNo = CSV.ItemNo
SET Item.Manufac = [csv].[Manufac];
January 16, 2002 at 4:36 pm
I agree with previous comment, start looking at FULL TEXT indexing.
For a start ignore the %SUBJECT% and concentrate on the rest.
Are you running 6.5,7 or 2000?
Record size and no. rows?
...
December 12, 2001 at 7:02 pm
Agree with Andy Warren.
1) Add print statements in you vb code.
Do you do "proper" error handling (displaying) in the VB app.
December 6, 2001 at 5:12 pm
I think the following indexes need to exist. For solution by LENE.
With an index on the Student table on the id column and a index on Grades table on the...
October 18, 2001 at 2:52 pm
Viewing 15 posts - 646 through 660 (of 662 total)