how could I start  learning SQL SERVER
Im just student

Because I am not sure what forums to post my question, so I put it here as I
am a new sql user as well.
I inherited some legacy ASP codes in my office. The original code's backend
is using the SQL Server 2000 and I am testing to use it on the Express

Hi I wanted to know the steps to install the report designer...
I have the foll. installed on my machine
ASP.NET 1.1
Version > SQL Server 2000 SP3a

Scenario:
We have 35 Citrix client machines needing to connect to SQL Server 2005 Std.
Question: Do I need to purchase 35 User CALS. I think I know what the answer
is but I would like confirmation please. As everybody knows the licensing

I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?

I would like to allow a particular user to truncate a log file in a
stored procedure that the user runs every day. At this moment the only
personnel that can truncate the log file are personnel with sysadmin
rights. Is there any way to do this in sql server 2005 without

How can I create a field in a view that takes a date field and
converts it to a month?
For instance, if I have a field called "CreatedOn" with a date of
'2/22/2007', how can I create another field called "Month" that will

i have this query, and i need to specify an order for each SELECT... is
there a way to do it?
Note:
On MySQL, all i need to do is to use parentheses to enclose each select...

I create a database on my development PC. I copy the 2 files on the computer
production, I'm trying to attach the database but I receive an error
....."can't be attach because the database is read-only"
DB created with SQLServer Express and the production is SQLServer Express

If I purchase sql 2005 server standard edition with 10 user/device cals does
this allow up to 10 users or devices to be able to access the SQL server at
once ? IF an 11th user/device tries to connect do they get refused. ?
If i have 20 devices/users that may want to use the SQL ...

I have two tables called Managers and Employees.
The Managers table is (partially) structured as follows:
   LineManager VarChar(10) Not Null
   SummaryDate DateTime Null

Is there a way with SQLServer Express to return only 10 rows, the 10 first
when I make a select, this select is orderd on the id.
Thanks,
Regards,

Hello, I have a resultset as follows:
fields: Name, RankID
values:
Prorduct A, 4

I want to use sql mail, but I don't have a profile.
I have Outlook 2003 installed on the computer with an email account using
exchange server.
In the Control Panel I see a profile named Outlook, but when I attempt to

I have need to create a table with 12 varchar(2000) fields.  SQL does not
prevent me from doing this but I'm wondering about the row size.  The help
documentation indicates that the max size is 8060 bytes.
What will happen if I try updating this table and all 12 fields have data