you need dbo privilege

Do you allow telecommute?

Would you explain more about this one? How can I contact you?

I am a certified SQL DBA and authorized to work in US. You can contact me at premaanand@hotmail.com . I am not able to relocate. But I am ready...

Hi

do you allow to telecommute? I am US permanent resident.

issue this command in Query Analyzer.

back up <logfile_name> with truncate_only

dbcc shrinkfile <logfile_name>.

This will reduce the logfile.

Then set up the maintenance plan to take full backups every night and transaction log backups...

Try this:

Select convert (numeric(18,7),unitsellprice) as newunit.

Since you specify the precision value to 3 digits, it rounded the value upto 3 digits.If you want to display the precision value more than...

i am ready to telecommute. I am certified on sql server 2000 and 6 years experience as DBA. Let me know whether it is fine for you. I am in...

take the transaction log back ups for every one hour

Hi.

Well. Generate the Sql script of your database including tables,views,indexes, PK, FK, stored procedures, and what are the things you need. Run it in SQL Server  2005 Management Studio. Then...

Hi

Adding or Removing a Cluster Node from the Virtual Server Definition

Another new feature of SQL Server 2000 failover clustering is the ability to add or remove a cluster node from...

make sure you are the local administrator and has all privileges. Or try to run under sa account

Prema

You can use database maintenance plan. If you are using single maintenance plan, make sure you are using the same recovery model for all the databases. However it is better...

check this article

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269

go and verify the shared drive, whether that file has been locked. If so, clear the lock and try to run