am having sql server 2000 enterprise when i tried to connect to sql server 2005 express its showing access denied..

what u mean by NIC

Hope ur database is in restoring state....Try Restoring the database with recovery option....

Thanks to all

I find the solution in DB level by giving sp_msforeachtable @command1="alter table nocheck constraint all"

Regards

Ratheesh.K.Nair

You are on the right path ...also change the compatibility to 90.

Check the installation once again ...hope u have Installed in C drive only...

Try executing create table statement one by one..

Marcus is right i think ..either the path doesn't exists or u dont have permission in that.

Thanks Tommy that was really nice ............

If u have time change password by using a login having SA privileage.

Hope you have made replication.Certificates are automatically generated when you create replications.

Yes SMTP only and it have that much capacity.

Hi,

We are on the design stage and we are planning to have 7 tables in that database.Approximately 2-3 email per month to 5million clients....

My question is when we execute a select query how server came to know that in which file is that particular data.....

Better try to find out the reason as Maverick said ,If ur sole aim is to shrink the log the best way is

change ur database recovery model to...