the table is obviously not updated as it should, altough sometime some
records are appended...
but this is what i see with SQL Trace from time to time:
-- 11.1.1998 16:51:57,100 RPC (ID=46, SPID=13, User=sa(GNS\pietro),
App='', Host=''(147) )
sp_columns "Calls", NULL, NULL, NULL, "Calls", NULL, NULL, NULL
go
i run this query (sp_collumns....) but it will eventually end with:
Msg 257, Level 16, State 1
Implicit conversion from datatype 'varchar' to 'int' is not allowed.
Use the CONVERT function to run this query.
i created Calls as follows:
CREATE TABLE Calls
(
NASIdentifier varchar (16) NOT NULL ,
NASPort int NOT NULL ,
AcctSessionID varchar (16) NOT NULL ,
AcctStatusType tinyint NOT NULL CONSTRAINT pk_Calls PRIMARY KEY
(NASIdentifier, NASPort, AcctSessionID, AcctStatusType),
CallDate datetime NOT NULL ,
UserName varchar (32) NOT NULL ,
UserService tinyint NULL ,
AcctDelayTime int NULL ,
AcctSessionTime int NULL ,
FramedProtocol int NULL ,
FramedAddress varchar (16) NULL ,
AcctInputOctets int NULL ,
AcctOutputOctets int NULL ,
AcctTerminateCause tinyint NULL ,
NASPortType tinyint NULL ,
NASPortDNIS varchar (10) NULL
)
GO
pietro