How to create a user-defined filegroup

HI, guys
I just wonder how to create a user-defined filegroup .
Thank you!Hi Guy
It's part of the ALTER DATABASE command. Please read about filegroups and
ALTER DATABASE in the Books Online, and then feel free to come back and ask
additional questions!
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
<vollenluo@.hotmail.com> wrote in message
news:c007823b.0409030915.37edd328@.posting.google.com...
> HI, guys
> I just wonder how to create a user-defined filegroup .
> Thank you!|||Use ALTER DATABASE ADD FILEGROUP ... Look up full syntax in BOL.
<vollenluo@.hotmail.com> wrote in message
news:c007823b.0409030915.37edd328@.posting.google.com...
> HI, guys
> I just wonder how to create a user-defined filegroup .
> Thank you!

How to create a connection to Access Database

Hi guys,

I want to create a report from Access Database. Can anybody tell me how to connect and create a data source from Access data source. A step by step guide is preferable. I am more concerned on the connection string.

Thanks.

There are two standard data providers that may be used to connect to Access databases:The JET 4.0 .NET OLE DB provider and Access ODBC driver. The former is newer and generally more efficient than the latter.

In the "Connection Properties" dialog,

1) pick "OLE DB" under "Data Source"

2) pick "Microsoft JET 4.0 OLE DB Provider"

3) enter the full path of Access file under "Server or File Name"

4) the connection string would be like

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb"

5) in the "Credentials", use "Admin" as user name and leave password blank

One thing to be aware of is that RS must have the necessary security access to open the Access DB file. Make sure that the account running RS has the privileges to open the Access database file and its containing folder.

HTH,

|||

Thanks buddy, I really appreciate your help.

How to creat a sp for insert datas...

hi.. guys...

i want to thank the people who answered my previous thread..

ii want to know how to creat a stored procedure with insert commands that need to be call from a servlet using callableStatement..

i want to know how to create the stored procedure in sql..

i have two tables login_details(username,password), personal_details(Name,Age,dob)..

With advanced thanks..

Ur's

Rams

Quote:

Originally Posted by subramanian_pks

hi.. guys...

i want to thank the people who answered my previous thread..

ii want to know how to creat a stored procedure with insert commands that need to be call from a servlet using callableStatement..

i want to know how to create the stored procedure in sql..

i have two tables login_details(username,password), personal_details(Name,Age,dob)..

With advanced thanks..

Ur's

Rams

---------------
create procedure sp_insert_login
@.username as char(100),
@.password as char(100)
as
insert into login_details(username,password)
values(@.username,@.password)

How to copy local sql express DB to remote full sql server 2005

Hi guys,

I am using Visual wev developper 2005 with sql server express 2005 and i have also sql server management studio express. it's all free now .

my web site is ready

I didn't have problem to upload my site to my hoster.

Now I want to upload all my tables and my stored procedure create locally with VWD express

How can i do it ?

thank's for your help

Hi all,

I have my all table on the remote server but it was very hard to.

let me resume SSMSE steps:

1. Connect to local server

2. Connect to remote server

3. Create Sql file by using "Script out Create " command on the local table

4. Change connection from local to remote

5. execute your sq file to create table on the remote DB

6. Open table on remote DB

7. Open table on local DB

8. use copy/paste to copy rows from local to remote

you must do it for all table including aspnet tables when you use features like menbership, roles profiles and personalization

How to copy database to another SQL server

Hello guys,

I need to copy a database in SQL 2000 to another SQL2000 server. I tried backing up the database to a folder then restore it but it's not happening. Please help to know how to copy database to another SQL server, or a disk and restore it to another SQL server.I don't know whether this was discussed before If it was, please forgive me.

Thanks in advance.What error you got when you tried to restore from backup?

Other way is to script entire database schema and run it on another server to create empty database structure and then using either BCP/DTS to populate data.|||Hello,

Stop the sql services of a source server, copy .mdf & .ldf file to target server & then attach the db in target server as follows
1. In Enterprise manager, right click on databases & go in all tasks & then attach db
2. select .mdf file from the copied location & attach it

u will see db is copied.

Shubhangi