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...

only if the existance of a value in the parent table is mandatory for your data model.

Do they have the same level of detail ?

apparently the regex should be like this:

DECLARE @Table1 TABLE

(

Column1 VARCHAR(32) NOT NULL PRIMARY KEY

);

INSERT @Table1(Column1)

VALUES

('abcdef123'),

('abcdef[123'),

('abcdef]123'),

('abcdef].123'),

...

xp_fixeddrives shows free space on the drives the sqlinstance can see.

As you now experience, being granted windows level authorities is still a privilege.

Even though an experienced sqlserver dba will need...

can you post the errors SQLAgent.OUT has about this job / powershell ?