Thanks a lot.

How about if I get one more server and install all the views which is pointing to our main database and the client will access those views on...

Good questions:

This is what is happening right now.

1. There is a Data Extractor tool written by third party which Extract data from flat files and stored into sql tables. this...

Thanks for your reply.

Right now , both we and our client extract the data separately from flat files with a same process. We get all the data including client data...

We have approx 2 Tera byte of data storage in one databse.

Here is the server configuration.

Itanium 2

1.60 GHz, 32 GB of Ram

We have created lots of partition tables in...

The reason I am asking because last time one of our Databse was in Recovery mode starting from Saturday and finished recovery on Monday evening at 11 PM. Data should...

Thanks Marios.

It's working when I use SP_send_dbmail instead of xp_sendmail don't know why it's like that but it's working.

Thanks guys.

Job are calling the Stored procedure and inside the stored procedure I am using following command.

DECLARE @EMAIL VARCHAR(600)

SET @EMAIL = 'EXEC master.dbo.xp_sendmail

@recipients = ''' + @RCPT + ''',

@message...

Thanks again.

You guys rock.

Everything working fine.

Thanks again.

But where is the command to move tables to new filegroups

Perry.. That works great.

Thanks a lot.

One more question.

As we know it's good to have a Primary filegroup for system tables but right now all the data is storing in primary...

Thanks a lot ken.

Yes the logins were not sync. I ran the script and it worked very well.

Thanks again for your help.

I transfer logins from sql 2000 to sql 2005 using Transfer Login Task in SSIS package.

Database are already exists on the destination server.

Kyle.. You are right. I restore the database with a different name and the files are associated with the new database name. When I run following command, the database name...

Nope, It was not detached. I restore from SQL 2000 database and somehow got disappear.

When I try to attached it , getting same error like it is being used by...