I am looking to make a program using express edition Visual C#.  I want my
application to interact with Microsoft SQL server, create tables, inserts,
lookups, the normal.
First I would like to read the documentation,and now to the point of my

I am replicating an 80GB database between NY can CT and would like to
know why table sizes are different between the two.
Here is an example of sp_spaceused::
NY     IOI_2007_04_23  rows(279,664)  reserved(464,832)

Hi experts!
When using SQL Server Management Studio to connecto SQL Server 2005, we are
given options to connect using Windows authentication or SQL authentication.
My question is, when using Windows authentication, how do we choose to use

I need to create a User DSN based on SQL Server driver under Data Sources
(ODBC). As I need to do it on multiple PCs, is there a script or another
automated way to do this quickly?
Thanks

The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;

I have SQL Server Manager 8.00.2039 installed because I have one program
(app) installed that requires it be installed.  For the first little
while when I had SQL server installed it would only show up in the
taskmanager tray, now MOST of the time, it shows up as a popup on my

I want to know the datafile and log file for the given input parameter. I am
basically creating function and the input parameter would be database name
and that will return me DataFile and the LogFile.
Can anybody tell me which query I have to used in the function. I have to

I have a Client table, with a field StartDate
I also have a Sales table. There is a field called SaleDate.
I'd like to run a query, and flag any Sales within one year of the Clients
start date as New Business.

Hope someone here can help me out.
I've worked with SqlServer for the past 10 years, unfortunately in my new
job they have a mixture of databases. One of the legacy systems I need to
support uses sybase.

I have a funny situation.
Within: MSSQL 2000 SP3, everything below described is running on same
PC.
there is a program running, which sends information to two other

How can I change a character in a string of text.  I have a bunch number
that have a lower case l in them and I need to make them an uppercase L.
Example; 99l5555 needs to be 99L5555.

I have SQL Server 2005 Standard Edition Service Pack 2, I want to create
Database Mirroring, how can I setup? any idea?
Thanks

I am looking to populate a Schedule table with information from two
other tables. I am able to populate it row by row, but I have created
tables that should provide all necessary information for me to be
able

I face currently a problem where I could need some input for searching
the source of the Problem
System: SQL Server 9.0
I fill from Database A with triggers Database B, everything works

Hi;
My company just installed MS SQLServer 2005 ( see below the dotted
line ).
When a user logs into management studio all of the databases on the