We've got this whole mess trying to export data from Lotus Notes to
Great Plains. As part of the process, we need to ensure that a Notes
record is exported only once, but have the ability to re-export it if
something breaks. So, for that reason (and some others) I decided to

hi, can anyone help me out with this report.
I need to produce a report for the database level user permission.
like for a database: DB_A, I want to output as such:
      [SELECT] [INSERT] [UPDATE] [DELETE] [CREATE TABLE] .... other

It is possible to drop the table without dropping the view referencing
it. How do I force integrity?
Madhivanan

Being new to the SQL server world I have a beginner question.
How do I grant access to database from a networked computer?
I have tried:
sp_grantlogin '\\computername\username'

Can someone please help me with a query?
The table looks like this:
BookedRooms
===========

I have two Windows 2003 servers that both have SQL 2000 on them with
Service Pack 4 installed. If I run the stored procedure
sp_ActiveDirectory_Start on one, it runs with no problem. However, on
the other, if I run it, I receive the error message xpadsi.exe failed.

I see the following error alot in my SQL Server logs:
Process 136:0 (173c) UMS Context 0x11CFDB78 appears to be non-yielding on
Scheduler 2.
Error: 17883, Severity: 1, State: 0

I am trying to connect the named instance from my client computer... I can
easily connect the default instance of my remote machine but when I tried to
connect through named instance it gave me an error that SQL Server doesn't
exist or access denied....

Using some VB sample code on the Internet I have the following
that works well and exports a set of records to an XML file:
 Dim oCmd, sSQL, oDom
   Set oDom = CreateObject("Msxml2.DOMDocument.4.0")

I've got thousands of XML docs and have to import those to the DB. And
I am having problem with getting some values because of tricky XML
format.
I didn't create this XML format and I don't like this format, OOP snob

I'm trying to create a layout of our website for Marketing to review,
and though I know how I want it presented, I'm not sure how to write
the SQL code to make it work.  Here's a sample of the View I've written
with all our content:

I'm using vb.net to connect to a MSDE 2000 database on a remote server.  
While in VB.NET,  I'm able to view data using Server Explorer.  In addition,
I've configured an ODBCDATAADAPTER that fills the dataset under preview data.
When I tried to retrieve data through ...

Hi all, met with something very scary and want to confirm if anyone
else have met this possible bug with EM?
Got a production DB, say DB_A with quite a few users in it. this day,
when I look into the EM-->management-->Current Activity-->Locks/Object,

I have a SQL database where i need to add new tables, new colums to existing
table, and create new scripts to do this. I want to create a flow chart or
diargram of this. how can i do this using Visio. Ver: Pro 2003

I'm using a client software to connect to a server. Everytime I try to log in
to that software an error: " ERROR 70: Cannot Create Servre Object". I
currently use a Microsoft Advanced server with the clients having a WIndows
XP OS.