Thia is sort of related to an earlier post, but has a more general
applicability.
Do people routinely logically separate objects in a database by using
different schemas? I have seen the books use examples like having a schema

I have no experience importing XML files into SQL Server and now I
need to do just that.  We have a sproc that does it for us--imports a
250MB XML file into a relational table [with no XML data types]--but
it took 3 hours and that's just too long.  The boss suggested I try

I have this View I use to get backup reports from about 5 SQL servers.
It uses OpenDataSource to union the information for reporting. works
great.
ALTER View [dbo].[UM_GetAllBackupData]

SQL Server 2000 & 2005
Here is the setup:
SQL 2000 database with a linked server to a SQL 2005 database.  The 2005
database is a vendor application that I can not change the tables in.

When storing address and addressee data in a database with a scenario in
which an addressee can have more than one address and an address can have
more than one addressee, one is faced with the question of whether or not to
allow the storage of duplicate addresses in a table.  ...

Is there a way to directly pull  sql agent jobs into VS? I can see the data
connection to the database, but I thought there was some way to pull in the
sql agent jobs as well. Any idea what I am missing? I am using SQL 2005 SP3

I can get a list of users from AD like this:
SELECT * FROM OPENROWSET( 'AdsDsoObject', 'ADSI Flag=0x11;Page Size=10000',
'SELECT sAMAccountName FROM ''LDAP://<dcThing1>.<dcThing2>.com'' where
objectCategory=''person'' and objectclass=''user'' ')

I am getting many syntax errors while executing it as I am unfamiliar with
the technology I need some help. Thanks in advance.
SELECT  
CASE  

I have a transaction table with 15 million rows with the following
fields: TransactionID, CustomerID, TransactionDate, Amount, Points
I need to monitor the total points of each customer. Should I create a
view with CustomerID, SUM(Points) AS Points or a new table with the

is there any way to create a db form a db diagram directly
Thanks,
 Carlos.

OS: Windows XP Pro, sp3
Sql Server 2005 (I assume it is enterprise, I downloaded it from technet -
this is not Express version)
I'm a webprogammer and when I test my webpages locally on my computer I get

[SQL2000]
Is there any system table that tracks at what time a SQL Agent Job or Job
schedule was disabled/enabled and by whom?
TIA,

I have the need to ensure referential integrity across databases. I
know this is not supported, but I am trying to work out the best
method of faking it.
As I see it there are 2 options Triggers or Check constraints.

Hi, I'm trying to group and count the data from a table.  Basically, I
want to know for each user how many distinct hosts and distinct files
he's using.
The RAW data in the table looks like this:

I .net I can pass a parameter to SQL Server with the following directions.
prm.Direction = ParameterDirection.InputOutput;
or prm.Direction = ParameterDirection.Output;
Does that make a difference for SQL Server?