The minimum possible value is 4 MB, the maximum possible value you can set is 2 GB, the config value is set to 2 GB and the run value is...

Try this:

sp_configure 'max server memory (MB)'

That will give you the min, max, current and run values. Current and run values might differ if you've just changed the value but...

Ah, I see. Yes, this is expected behaviour for log shipped secondary databases.

There's no need to backup this database though since it is itself a backup of...

If the database is in readonly mode then the state of the database isn't changing so there's no point in backing it up.

Bring it out of readonly mode and back...

Good article.

By the way, it sounds like you've got a couple of unused licenses.

You do not need to buy a sql server or...

Tryst,

You can do this using recursive calls to a stored procedure but be aware that a procedure has a limit of 32 nested calls to itself.

A much better way of...

select suser_sname(suser_sid())

Think that should work in express.

Leonardo,

In that case I honestly don't know. All I know is the script works and runs for me so I suggest you contact the author of that script and...

Rama,

unless you record this date (either in a column in the table, or in another table) you won't be able to know when a row was updated.

This is unless you...

Dean,

tough to say what the problem is here.

Try setting the value of a second date parameter to dateadd(Hour, 2....) beforehand. As in the following example. See if that makes...

Pavas,

I see. So you don't want to create an additional file, you actually want to move this file to another location? I thought you wanted to end up...

Leonardo,

I just tried setting this myself and it worked fine. Note that I'm using the second method (on page 2). My ServiceList.txt file looks like this:

KARLG,MSSQLServer

KARLG,SQLSERVERAGENT

Where KARLG is...

Pavas,

you can use the alter database statement as follows:

ALTER DATABASE my_database

ADD LOG FILE

(

NAME = logical_file_name,

FILENAME = 'physical path and file name',

...

Leonardo,

Check out the following link, http://www.databasejournal.com/features/mssql/article.php/3347241.

You can create this heartbeat checker and run it from your box (or another monitoring box). All you have to do is,...

The solution I provided you with will update every row that is affected by your update statement and removes the need to use a cursor.

A trigger will only run for...