At work we have various servers, therefore we have various DTS Interfaces
which transfer data between them.
However when trying to save a new View to one server which gets its data
from another server nothing happens, I get an hourglass and nothing else.

the following problem:
I use Delphi 6 to access a MS Access Database.
In short, the Delphi Code looks like this:
              ADOConnection1.Open;

I'm trying to run a select where a
uniqueidentifier/GUID equals a hex, but I don't seem to be getting
matches.
For example, this query returns the expected record:

I have a table with composite key: ID1 and ID2 and it also has a
priority field.
I want to get all the information for all records with the minimum
priority group by ID2.  How can I achieve that?

I want to copy the sql server database from the C drive (IDE) to a raid
drive E.  So I first created a directory and copyed the pair of mdf and ldf
file to the E drive and then ranamed them.
This didnt work because when I attached the files sql somehow knew they came

I have a column in a table full of phone numbers, except the user entered
them just as "a number" so (206) 555-1212 looks like 2065551212
Is there a way in which I can run something that will format all of these
with the appropriate parantheses, etc...?  (ie. make them look like ...

I've a project to work on that needs to be done in Visual Studio 2003 .net
and MySql 2000. But the machine I'm on currently has the VS 2005 beta and SQL
Server 2005. I've already figured out that VS 2003 and 2005 can be installed
side by side, but I can't seem to determine if SQL ...

Is there anything like cross tab of access in sql server?
Thanks.

Are there any limitations to the Access Upsizing Wizard??  I cannot seem to
upsize a database containing a table of 1.5 million entries to an MSDE2000
database.  When I reduce the table size to 800K entries, it works.  And the
size is no where near the 2 Gig limit.  Thanks in ...

I am selling "Microsoft Office Standard Student and Teacher Edition
2003" the price is only 70.00$ including shipping ANYWHERE!!! The price
is real,quantity available-10,you can either buy retail or only one
copy,for more information please visit the auction on epier:

I am new to SQL, as old as it is. I am not new to programming I
normally just use Access.
I have two tables for a little project manager I made. After updates I
sent an email to the user. I need to populate the user based on the

Is it possible to replicate in MSSQL SERVER standard edition and be
supported??? Or do I need to buy enterprise edition.
Regards
Jaideep

How could I check how many chars are in record, defined as varchar(8000).
It's obvious that in such defined record could be 1 char to 8000 char. But
what query to SQL database should I post to give information about realy
lenght of this records ?

I can't get a script to run that's supposed to generate a Query
Parameters dialogue to take inputs and then run the query - for
example, the following
. . .

I want to distinguish between static SQL, dynamic SQL, and embedded
SQL, but couldn't find too much useful resources in the web.
For example, if we put SQL statements (SELECT, INSERT, UPDATE, etc...)
inside an application (e.g. Java application, VB application, etc...),