in our house:

- each team of "infrastructural software suite" people handles backup and recoverability conform the businesses needs and uses the appropriate scheduling system.

- SCOM monitors is all 🙂 and...

Nice article, Dwain !

:smooooth:

Thank you for the confirmation.

my bad. Sorry for that.

Executed as user: mydomain\myserviceaccount. The page (1:402), object ID 75, index ID 1, partition ID 281474981625856, allocation unit ID 281474981625856 (type In-row data) has been modified,...

The message I received was as posted.

Digging deeper, it seems to have been the following:

DoMiniDump () encountered error (0x800703E6) - Invalid access to memory location.

External dump process return code...

Thank you, Gail;

I was suspecting in the same problem area.

first of all check the way the linked server is defined.

then check if you would indeed be authorized to use the linked server in that way

have a look at the article Allen White published a while ago: https://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/

My favorite memory for 2013 was my first ever presentation at SQLSaturday in Lisbon.

Although I only in participated in Lightning talks, the efforts and nerves it took to assemble...

could you please add @@version information of that instance ?

Gail has way more recovery experience than me, so she may come up with less drastic measures than I might suggest.

masoudk1990 (12/24/2013)

---

Much appreciated, Ive read from somewhere if I use QUOTENAME(@FieldName,'''') with 4 single quotations, it makes stored procedure bullet proof from sql injection, but Im still in doubt if...

all NCI access that needs extra data will use the clustered index to fetch that data.

what columns do you expect to get used ?

Provide indexes for those columns and try...

The good thing is: your test also fails here ( sql2012 SP1 CU7 (Build number: 11.0.3393.0))

I've also tested it with a couple of other 850-collations. All fail !

These are...

First question to pose is: Shoud that column have nulls ?

Second question to pose is: wouldn't a default empty varchar do the same trick ? If so modify the data...

avdhut.k (12/3/2013)

---

Hi,

My requirement is,

I want to capture exact date and time,

I am trying using,

Select Convert(varchar(10),GetDate(),112)

output :- 20131203

Above statement gives...