I am writing a C++ program that will take backup of .mdf files. I will
be provided with .mdf files. And for that mdf file,  I need to know
the database name and file group name associated with this .mdf file.
How can I do it? Please help me to sort this out.

My department is experiencing difficulty with SQL Server 2005's Rebuild Index
functionality.  We are upgrading from 2000 to 2005 in the near future and I
was tasked with creating a maintenance plan consisting of:
Integrity Checks

I am trying to create a Private Profile for Database Mail, however there are no accounts available for me to select.  I can and have successfully sent mail from a public profile containing 2 different accounts, so I know I have it working.
How can I create a private profile?
Also, ...

I am using SQL 2005 and have multiple instances installed on multiple
servers.  None are on the default port.  When I connect to box 01
without specifying the port in the connection string, it connects.
But on box 02, it will only connect to the instance if I specify the

using sp_configure we inadvertanly set the network packet size too big, an
didn't get a warning.  when we restarted the mssql service we found that the
sqlserv instance wouldn't come up.. we were able to go into the tools >>
options >>

How can I detect if my computer have installed SQLServer 2005 or SQLServer
2005 Express with program like c# or VB.NNET?

I want to copy some views (not data) from one server to another.
How can I do that?

I am looking to improve performance of the sql system.  I have the trans log
split onto its own RAID5 drive.  We are thinking about going to RAID0 to try
abd boost throughput.  Any ideas?
Richard

Recently some body played with our SQL Server and removed our Sys admin
group login and we dont have builtin\admin as login and no SA Password
can any body tell the way to come out with this situation to change the SA
Password or create our Group back with Sys admin priviledges.

I have been using SQL Server 2000 for some time and am attempting to upgrade
to SQL Server 2005 (testing the trial version).
I backed up my SQL Server 2000 database(s) and then restored them on SQL
Server 2005 which worked well.

I am working with a SQL Server 2005 client while the server still runs
SQL Server 2000.
SQL Server 2000 had DTS while 2005 has SSIS. Given that the server
still runs 2000, is it possible to write a DTS package in 2005 that

I have a DTS package. I need to debug it, ANy ideas how?
Thanks,

I'm preparing to install SQL Server Hotfix 2187.  I have 4 standalone servers
all running SQL Server 2000 Enterprise Edition SP4.  I've been trying to
figure out how to uninstall the hotfix in case something goes wrong.  I can't
find any information on the Microsoft website, or ...

How to import & export  stored procedure in sql query  like Table data ?
thanks,
harshad prajapati

I have a PC that was in workgroup mode.  It has SQL Express installed on it
supporting one application.
I recently moved the PC into a Windows 2003 domain.
Now SQL Express is not starting and is showing the following message: