Hi Experts,

Any resolution on this error.

The version SQL server 200 R2

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (.Net SqlClient Data Provider)

Yah its having SYSadmin role on sqlserver

hmm quite 🙂

oh your right working on simultaneoulsy on SQL 2008 and 2000 so got messup in posting .

🙂

yah but using sql server 2000 version

Any how thanks 🙂

good , so there is no alternative to used the direct statment

Hi,

I want to run as job on other server so executing delete statment is expensive in this case.

So is any alternate or the way to used the Truncate syntax

Thanks to all 🙂

Can i have the steps and query to accomplish the above mention tasks

Thanks

no is of seperate file group

From enterprise manager if you go for restore process and when you will click the tab "option"

you can find the list of files and location of getting restore so...

Regarding the restoration with no logfile i have try and my database is restored and is working fine.

and its creating from itself the log file even though i removed...

thanks 🙂