RBarryYoung (5/8/2009)

---

Yes, there are ways to do it, but they are a lot of work and they perform very poorly. In general if you need to dynamically specify the...

What information do you exactly need from ipconfig? Server IP address or what?

Exactly: the transaction log backup is taken from the last backup, either full or tlog.

Personally I don't like the idea of having a reporting database. I try to keep it all together, but I don't give the reporting tool direct access to the tables:...

If you want to restore the database up to the failure time, you will have to restore all the transaction log backups you took since last full backup. You can...

... ooops!

I vote for Lynn's solution! There's also an interesting thread on this topic

http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

I think you should use some kind of slit function.

I use this one, but I'm sure there's a better one out there.

CREATE FUNCTION [dbo].[fSplit]

(

@List VARCHAR(6000),

@SplitOn VARCHAR(5)

)

RETURNS @RtnValue TABLE

(

ID...

Just the db engine is x64, all the rest is x86.

Regards

Gianluca

Probably they do... we have some in Italy as well.

I find this post very useful for the discussion.

Thanks Lynn and Gail, I always get good advice from you.

I will try to find the best solution that fits my needs and I'll be back with some feedback on...

Working with distributed transactions isn't always easy...

I suppose you're logging something to the remote server, so the real question is: do you really need a distributed transaction to put...

Thanks for the prompt reply, Lynn.

I agree with your choice, and I was going with it when I started to think about how developers here work. The information stored in...

The O/R Impedance Mismatch has always been the greatest issue for newbies. If you let the right tool do what it's designed for, nothing will go wrong. Let the database...

This is another way to format with a custom formatting string:

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31111/

Hope this helps

Gianluca

I wouldn't suggest handling this as varchar or similar: if you're dealing with dates, store it as a datetime column and format on the client side according to the user's...