When you restore the full, you have to specify the "with norecovery" or with "standby" options. Then you can load t-logs. Need to be sure you do not complete recoery...

create procedure spTest

@txt text

as

select @txt

go

Try this for the variable of the OpenXML part.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Thanks for the note. I haven't really worked with Site Server.

I'd like to see some of this in the core product, or as an option for SQL Server itself. Images,...

Anytime. Good luck and come back and let us know what you find. Or better yet, write it up and send us a short article

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The...

Either get an account that can authenticate or change to SMTP.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I'm not that great at this, but I think you'd need to query the ADSI provider using LDAP and get a collection of the group's members.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of...

What's the exact error? Is this because of a deadlock?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I haven't tried this, but youmight be able to use the Red Gate tools (see the bottom banner ad) to move the strucutre and then a subset of data over.

Steve...

??

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I use SQL Litespeed at work and love it. Minimal load on the system, good compression. I run it on the level2, there is a level 3 and I believe...

Wow, don't remember, but I'd guess there is. Search for any files that have a last timestamp in the time frame and start looking through them.

steve

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL...

That's cool. Not sure I want to hack and fix this Snitz code. We're looking at upgrading though, so maybe some of your cool ones will be included in the...

I think they can also be server admins to stop. Of course, if your DBAs are admins on the box or domain admins, they can do this as well. The...

It's possible. xp_cmdshell runs under the SQLAgent context. run this as an account and then try it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I might be tempted to build some app or job that will read the msg from a table and then send it to MSMQ. Slightly delayed from immedate send, but...