Thanks. It works.

>sqlcmd -S myservername -E

>go

Maybe I didn't explain my problem clearly------

I was given a windows user name and password. The only permission this user has is to create a database. With this user name,...

Thanks. One more question, if the license is only for 1 CPU, but 2 cpus on the machine, do I need to take 1 cpu out, or sql is smart...

Hi I did call them. Seems Server Plus w/25 CALs is the choice. But there are so many retailer and some offers are too good to be true. Is anyone...

hi guys,

It works in the domain and I also tested at home (workgroup). On the workgroup, I can manually do DTS but cannot schedule it. Then I changed SQL Server...

Hi,

This is a compelte message '[SQL-DMO] The Bulk Copy Execution failed'.

Then AJ Ahrens, how to avoid to copy the users/permissions etc. Where can I more detailed information.

Thanks, thanks again

Hi, Thanks for your reply. I backup the database weekly. What I want is a updatable standby server. My version is standard and replication cannot meet the requirement perfectly (for...