Try the SP_ADDROLEMEMBER TSQL

EXEC SP_ADDROLEMEMBER N'db_owner', N'user_login'

Could give you a small check list and you go through the KB link given to setup log shipping.

1) Finalize on the Primary & Stand BY server

2) Create a...

You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with...

When you enable lock pages in memory SQL Server will not release in memory to OS, and while starting it will allocate almost all the physical memory, to avoide we...

You need to create the encrytion key from the backup of the encrytion key from the source DB server.

Please check the following article:

http://www.sqlservercentral.com/articles/Transparent+Data+Encryption/66334/

If, Total Server Memory (KB) counter is less than the Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently.

On the other...

Yes , if you are capping it yes, SQL Serevr will not release the memory...

What is SQL Server edition? Is this a STANDARD edition, because LOCK PAGES IN MEMORY is not supported in this edition hence you are not able to LOCK the...

I dont think the above restore command will run dbcc checkdb. Also , RESTORE will not run DBCC CHECKDB unless you are using a user built in script / trigger...

Gangadhara MS (7/6/2010)

---

Executed as user: AP\sys_power. The transaction log for database 'Power' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column...

Shcherbunov Neil (7/6/2010)

---

The problem solved! As it turn out the events happen in this sequence:

1. I create XXXuser on COMP

2. I create COMP\XXXuser login on MSSQLSERVER2

3. I remove XXXuser from...

TRy using sa and specify the port number to which named instance is listening.

Check if you have problems resolving the name of a computer that is involved in adding the login or group, if yes then you might receive error 15401.

Verify this using...

Do you have transaction log backup ? if not then schedule it depending on your environment.

Try to put the DB into single user mode , Truncate the log and the...

Same issue I faced and I have redo the installation with default path. It seems there are two work around

Method 1: Use the default path

Ø ...