I have a number of questions regarding SQL Server and Visual Studio. I'm
running Vista Ultimate SP1 and have Microsoft Office 2007 Ultimate installed.
I also already have all versions of .Net Framework from 1.0 thru 3.5
installed.

I registered ASP.NET on my Vista Enterprise x64 machine using the command:
"C:\Windows\Microsoft.NET\Framework64\v2.0.50727>aspnet_regiis.exe -i"
It was indicated as successful.
When proceeding with the installation of "Microsoft SQL Server 2005 Express

I have a SQL 2000 database with a fulltext catalog and, of course,
indexes.  I need to migrate this database including its fulltext
catalog/indexes to another SQL 2000 server.  Both SQL installations
reside in MS Windows 2003 servers, for what it's worth.  I could not

We are now just embarking on our 2k5 upgrade. I have many instances to
upgrade, and all at varying levels. I’m reviewing an upgrade matrix in SQL
Server 2005 unleashed, and I would like confirmation on what I am reading.
Can I upgrade:

I should know this - but do you need to have Sysadmin rights in order to
apply a SQL Server 2005 Service Pack? Thanks.

I  have a db with multiple files in a filegroup, one file on a disk of it's
own. (one disk is larger than the other). Currently sqlserver is distributing
data on each disk equally so that one disk is actually becoming more full
than the other (because the disk is smaller)

I have XP Pro/SP2, 20gb HD, 512mb RAM, Celeron 1ghz laptop for home use. I
installed SQL Server 2005 Enterprise Evaluation edition for trial. When I
clicked on the Management Studio, the dialog box asks for server name. My
computer name is shinaspc. It is a standalone machine. I ...

Hey all, first posting here. Did some checking around on Google for
this issue before asking here but so far am coming up with no clear
idea.
Have W2K3 Server SP2 (4GB RAM) with SQL Server 2000 SP4 and am

Hello Gurus
I was wondering other than bouncing the server is there a way to limit
or flush a log when it becomes to large say like 11 gigs
We had a log several months ago that was over 25 gigs this caused the

I could not attach the log file (to large even when Rarred).
Was able to run the program, but have still some problems, don't know if
related to the stacked Setup.
It is was stacked on "Deleteing BU files".

If this is the relation with its constraints:
CREATE TABLE Orders
(o_num INTEGER NOT NULL PRIMARY KEY,
c_num INTEGER NOT NULL,

SQL Server used to have a Data Transformation Services that made it easy to
convert other databases to SQL Server. I cannot seem to find this feature or
a substitute in SQL Server 2005 and I need to convert an old Borland/Corel
Paradox database to SQL Server. Can you please she ...

Is there a tool (in SQL Server or a 3rd party) that will allow the craving up
of hardware resources (CPUs, Memory, etc.) on a instance by instance basis?

I have a 900gb drive that is being dedicated to my new database. Please, I
need help in determining the correct sizing starting of so I don't end up
with disk fragmentation issues later.
Thanks,

What is the minimal right so user can execute stored procedure.
db_write, db_read can't make user execute stored procedure
TIA,
Gun