fixed it 100% logging in thanks for your support most the problem was the linked servers werrnt getting connection to the dbQuote:
USE [character]
GO
/****** Object: UserDefinedFunction [dbo].[FN_BinDateToDateTime] Script Date: 06/25/2010 10:43:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/************************************************** ****************************
이 름 : dbo.FN_BinDateToDateTime
설 명 : Binary Date를 DateTime 형식으로 반환한다.
반환값 :
수정내역:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_BinDateToDateTime] (
@i_bin_time binary(4)
) RETURNS datetime
AS
BEGIN
DECLARE @v_datetime datetime
--DECLARE @v_strtime varchar(20)
--SELECT @v_strtime = '200' + CAST(CAST(@i_bin_time as int) as varchar(20))
--SELECT @v_strtime = SUBSTRING(@v_strtime,1,4)
-- +'-'+SUBSTRING(@v_strtime,5,2)
-- +'-'+SUBSTRING(@v_strtime,7,2)
-- +' '+SUBSTRING(@v_strtime,9,2)
-- +':'+SUBSTRING(@v_strtime,11,2)
--SELECT @v_datetime = CAST(@v_strtime as datetime)
SELECT @v_datetime = '2010-05-25 00:00'
RETURN @v_datetime
END
Quote:
i did this for temp
Quote:
u forgot 1 important step. SN text. must select character to excute. and pls u might be a nub, but u shld know simple rule like double post is nt allow.Quote:
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] File: .\Message\FormatHandler\Provider.cpp, Line: 81
[6220] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[4368] ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
[7104] Provider::Execute( CCHAR * szName )
[7104] szName: SP_LOGIN_FLAG_SET
[7104] Microsoft OLE DB Provider for SQL Server: The OLE DB provider "MSDASQL" for linked server "LSV_DKRACNT" reported an error. The provider did not give any information about the error.
p.s im using mssql 2005 and ive excuted sn.txt