in visual basic. Currently we are using a customized erp (SYTELINE 7). I have to create my own SP in mssql 2000 for our needs. In their erp system...
gud day, i have a problem regarding how to configure or setup the activex data objects 2.8 as my permanent library. When I close my visual basic...
good day to all of you guys, i want to use my stored procedure in mssql 2000 which i recently created. my problem was how do i use my SP to visual...
gud day to you. i tried to issue a insert t-sql command to a certain table since the one of the column (objectnotetoken is an identity). i got a "An...
hi guys, im new to replication i start to configure the publication,distribution under replication. there was an error "sql server agent uses system...
k. is there a way that the query result would be converted to a text file
i created a store procedure, m using query analyzer in sql 2000. it is possible to issue a command within my procedure? i tried to execute in isql...
hi guys, can you pls help me on how to eliminate the column lines or column names, i already issue a set nocount on. i would like to erase the...
HI, GUYS i have a sql query command in crystal report. when i try to run my program under my laptop which act as stand-alone, the result set of my...
cannot drop distribution publisher 'JOUIE'. The remote publisher is using '(null)' as distributor. this is the error when i execute it. can u help...
i try to login as "sa" then still my replication monitor didnt show up. is there anyway i can enable it or setup it again? one thing thre is a...
hi, when i open my setup this morning, my replication monitor disappear. when i choose create and manage publication there is an error prompting me...
hi guys, i encountered an error after i create a linked server the error was: "OLEDB error trace[OLE/DB PROVIDER 'SQLOLEDB'IDINITIALIZE::initialize...
i have created linked server and i enable data access but there are still a little error. "sql server does not exist or access denied.
where can i create linked server? can you guide me. thanks
EXEC SQL CONNECT TO KID.Beta_App;<br /><br />ERROR MESSAGE:Incorrect syntax near the keyword 'TO'.<br /><br />one thing my purpose for this is i...
hi guys, can you pls help me to connect from one server to the other using transact sql. is it possible? i have tried "execute sql connect to...
helo, gud day to all of you. Since im a newbie in replication. can i setup a replication from my computer locally (between 2 computer only[lapton...
im really sorry sir. my apology
hi, im new in replication method and issues. i have tried to replicate a item table using push publications with transactional replication. here...
Separate names with a comma.
