all groups > sql server misc > august 2005
SQLDMO Problem - please help
Posted by Dino Buljubasic at 8/31/2005 7:08:08 PM
Hi,
I am using SQLDMO in my application to create data tables, full-text
catalogs and jobs to populate the catalogs. My datatables are created
successfully but I get error on line where it says :
Dim oSQLServer as SQLDMO.SQLServer
oSQLServer = new SQLDMO.SQLServer
I have added reference... more >>
Stored procedures, logging and transactions...
Posted by Alex at 8/25/2005 12:00:00 AM
Hi all...
I have a set of relatively large (500 lines+) stored procedures that I need
to go through and add logging code for troubleshooting purposes. I was
thinking of writing an "AddLogMessage" stored procedure which I can call
from my main stored procs. "AddLogMessage" would then add the me... more >>
SQL / SQLCE Synchronisation Issue??Help Needed Please!!!
Posted by steroche at 8/19/2005 2:57:51 PM
Hi guys,
I have a problemo - basically i have one large SQL2000 DB. This is
edited / updated etc by users of the website i am developing. However i
also wasnt a SQLCE component as i want certain users to recieve
user-specific information from the database to their PPC's (I don't
have access to ... more >>
Compatibility SQL 2005!
Posted by John at 8/15/2005 12:22:22 PM
Is MS SQL 2005 Express (or server) compatible with Visual Basic 6.0 ?
Can I use new SQL 2005 Express with Visual Basic 6.0 ?
Your answer is greatly appreciated!!
... more >>
Query Access & MS SQL
Posted by John at 8/13/2005 1:31:11 PM
Are syntax of queries same in MS Access and MS SQL 2005?
I am asking because I have lot of queries in Access database. Do I have to
change every query when I move to MS SQL 2005?
Thanks!!!
... more >>
Newbia Question about SQL 2000 > MSDE Replication.
Posted by GrownUp at 8/9/2005 1:10:38 PM
All,
to someone who knows what they are talking about this will seem an extremly
stupid question, but here goes.
Apologies if I have posted this on the wrong NG.
I wrote a PDA based application which used SQL CE. The App, written in
VB.NET using the CF, allowed a user to enter data local... more >>
Assistance with a query
Posted by s commar at 8/7/2005 6:45:19 AM
I have 2 tables POheader and POline. I am running the following SQL
statement but am getting 2 records where as I should only be getting one.
Could someone please assist.
s_commar@hotmail.com
select POheader.ponbr from POheader inner join POline on POheader.Ponbr =
POline.Ponbr and POl... more >>
Dear group,
Posted by Marcel van den Hof at 8/6/2005 12:00:00 AM
Dear group,
I would like to ask a brief question about NULL values and the IN operator.
The following SQL evaluates to (with ANSI_NULLS ON):
1 IN (1, 2, 3, NULL) --> Evaluates to true (makes perfect sense).
NULL IN (1, 2, 3) --> Evaluates to unknown (makes perfect sense).
4 IN (1, 2, ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|