Most likely the account you use to create a login is membe of the Builtin\User group in windows xp and it is not a member of sysadmin or dbcreators fixed...

Thanks all for the respond and thanks to SQLBill for clarification.

Check the MS e-learning site below. 90 days free e-leaning tranining may help you get started.

https://www.microsoftelearning.com/sqlserver2005/

It happened to me just 2 days ago.  I had to restore to point in time using stopat prior to specific transaction.  I restored the db but it stayed in...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_9ttf.asp

The above article shows marked transaction basics and the article below is I think exactly from BOL but I hope it helps...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp

You need to use the name of the mark that was used to mark the transaction. 

(ie.  BEGIN TRANSACTION DailyDeleteOldData WITH MARK

      DELETE FROM OrderHistory

      COMMIT TRANSACTION DailyDeleteOldData)

As you...

Here is the MS press administrator's pocket consultant

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/adminpoc.mspx

After you add the login for the user make that user member of the db_datareader role for the dbs that he/she needs to read.  Like the previous post regardless of the...

Hi,

If you have the money and space to add 30 hard drives you will definitely have the I/O performance edge. I think that would not be realistic. When...

You can install professional edition or developer edition on Windows xp Pro. which edition of sql server are you trying to install?

I have included the link to lumigent site (that's where I downloaded a while ago) for the original poster to download very good pdf document full of disaster recovery, backup...