I do have access to our LDAP server, because I am able to pull out
user info from the active directory in my asp.net web application.
But it is sorta slow to list all users in our active directory.
Then I recall that I read somewhere that we can retrieve active

Dear group members,
I have been importing flat files with delimiter pipe '|', and of which
first row is variable names. I usually have to import about 10 files
in a month. This time I am in big trouble as I have to import about

Is there a programatic way of detecting whether an instance of SQL has been
started in Single User Mode (-m)?   Thanks.

Using Enterprise Manager (Management Studio) , if you try to do a
backup, the dialog box shows the directory structure on the SQL Server
computer, even if you are running it from a client workstation.
I want to implement this functionality in my VB.NET application.

I have a SQL Server 2000,32 bit version in which the DB's are in standard
collation which is SQL_Latin1_General_CP1_CI_AS. I have an excel spreadsheet
which has a data stored in Japanese characters. So i would like to know
whether we can import the Japanese character data into ...

(Best viewed in Courier New, or other mono-spaced font)
I have a query that returns the following:
LabelID Company    Product Name                         Package
======================================================================

Hi, I have my entire system setup on JET/Access database. This was an
example table I had:
User Table
User Name field

In an adjacency list model structure which depends on ID and PARENTID
columns, how can i find the depth count of each row ?
Thanks.
Adam

I have a query that in SQL Server 2000 returned the row in primary key
order. In SQL Server 2005 it appears that this is not the case. Does
anyone know if, absent a order by clause, a query should return rows
in primary key order. Could this be just a fluke in SQL Server 2000?

I have two separate applications that share the same sql server
(different database).
One of them has been there for > 2 yrs and the other one > 1 year.
Both apps are written in vb.net / sql server 2005. Until recently I

Grateful for any help with this query, my ISP has just upgraded from MS SQL
2000 to MS SQL 2008, which is great because I have a table that requires Full
Text Indexing (on a particular field) as I'm running recordset queries
against it (LIKE %) and it is an NvarChar(MAX) and the ...

There is a trigger that executes a single stored procedure in the other
database by passing some values about inserted row.
Bu it's not important that this stored procedure will fail or not.
the trigger is:

I have a table with time clock punches.  Each record represents an employee's
punch (either in or out) and looks like this:
EmployeeID, PunchTime,                  PunchType
1234                 1/1/2009 8:00                 IN

I've been using Business Intelligence Development Studio successfully
until this week, which I opened Visual Studio 2005, tried to create an
Integration Services package, and got the following message in the
Package Designer window:

This is hypothetical at this stage, but how does SQL server handle large
amounts of hits? For example say we had one table behind a website called
'Transactions' and every user performed 100 transaction per day. These could
be reads and some edits to particular rows. How would ...