Read and write data, but not being able to alter any objects? In that case do

ALTER ROLE db_datareader ADD MEMBER [domain\user]

ALTER ROLE db_datawriter ADD MEMBER [domain\user]

or, if you are on...

With high safety, the statement does not complete until the update has been hardend in the log on the mirror. If you have a slow network connection, or the mirror...

OK. But what permission? Should...

That's indeed...

dan-572483 (9/19/2013)

---

One items you often see in "best practices" articles about SQL is the need to configure Maximum Memory at the server level. It is said that SQL...

I would suspect that when you create a database manually, you are logged with sysadmin permissions, which you hopefully you are not when you are logged in from the application....

With the tabale you posted there is a cardinality problem.

The syntax UPDATE FROM is scorned by some people, because it has a possible ambiguity. I don't share that opinion, because...

10 and 41 are good to include as well.

Since you are tracing a single statement (plus triggers), sp_sqltrace can be useful. It's available on my web site:

http://www.sommarskog.se/sqlutil/sqltrace.html

Did you set mirroring to be synchronous or asynchrounous?

Could you post the code for the UPDATE statement?

How many rows does it affect, appoxamitely?

Your question is not clear. You say that you want to give permission to new user in the prodcution database. But in that case, why do you mention the fact...

Just to add what Andreas says. There are various ways you can set up the server so that they cannot connect directly to SQL Server from Excel. However, it is...

To be technical, it is not a DMV you are looking for but a catalog view. (The difference is that a catalog shows information persisted in the system catalog, while...

I woudl guess this is possible with the appropriate .Net routine. I guess that there might be assemblies out there to manipulate PDF documents. You may be able to add...

First, you should use sys.columns, not syscolumns. Next you should name your constraints:

if not exists (select * from sys.columns where object_id=object_id('ConfigTB') and name='DBVersion')

alter table ConfigTB add DBVersion...

I would do it with a UNION ALL query. One for the interval, and two SELECT TOP(1) queries to get the values just outside the interval. An index on DateTimeStamp...