You can, but the recommendation is that you don't.

See 'Backing Up to a File on a Network Share' within http://msdn.microsoft.com/en-us/library/ms179313.aspx#NetworkShare.

You would be better off backing up to a local drive...

http://sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.aspx

WayneS (8/3/2012)

---

First, I agree with A-D of...

The detailed disclaimer made me laugh - trying to pre-empt any complaints?

When you place comments in your code you need to mark them as such:

http://msdn.microsoft.com/en-us/library/ms181627.aspx

I agree, it would have been...

Excellent question Ron. I had to run the code through to understand what it was doing and learned something new.

You're welcome. Thank you for including data and code to work...

select ID,

case val

when null then '0'

when '' then '0'

else val

end as val,

ISNULL(ser,0) AS ser,ISNULL(sa,0) AS sa from @test1

Use CASE to specifiy various conditions.

Note that it has to use '0'...

There is an excellent 'Stairways' series here, which explains the Log File in detail:

http://www.sqlservercentral.com/articles/Stairway+Series/73775/

Because there isn't one. Without ORDER BY there's no guarantee of the sequence of the data. It...

SqlSpider... (7/27/2012)

---

Hi all,

I can Use Replace function, but in that string may have multiples of <IMG> tags, or nothing..

Sample String:-

'<p class="MsoNormal" style="text-align: center;"><span style="FONT-SIZE:...

I wondered if SQLSpider meant any '&' that was within a <img> tag.

I think the question could do with a little work to clarify it.

That would be how I would do it to, given the choices - with the witness on a separate server.

However, if you lose both the witness and mirror you also...

Something like SQL Pretty Printer may be of help.

There is a desktop version which can convert all files within a folder. A demo is available at http://www.dpriver.com/index.php.