When you restore a transaction log to another instance of a database (another server, another name, another instance of SQL Server), it doesn't actually restore any completed transactions, just restores...

http://www.salary.com has data on pay and benefits for various careers/jobs on a per-location basis. Plug in your data, get a comparison. If it's just about the money, that's...

Different paths shouldn't be a problem. What kind of errors are you getting?

And and Not can quite often be dealt with by a good index. Or is the problem, most often. One of the more efficient ways to deal with...

So, when this returns multiple groups, what is it actually giving you?

I'm envisioning a proc that has a part number as an input parameter, and which gives you all the...

Rounding will cause errors. That's a mathematical fact.

You're dealing with 2 significant digits (after the decimal place), and then rounding them, which means you're only dealing with accuracy of...

In Management Studio, open up SQL Server Agent (should be at the bottom of list), and right-click on Jobs, select Create New Job, and follow the directions on the screen....

Did you actually try the isdate() function, as per the code I wrote? What that does is return a 0 for strings that can't be converted directly to dates,...

Books Online has details on how to check which columns were updated using Columns_Updated. The key is understanding the bitwise operator, which is also linked to in Books Online...

Run a trace on the server is one way. Check the transaction log is the other.

Alternately, download the free trial of ApexSQL's log parser, and use that. It can work on active log files as well as reading from backups, etc. I think...

Congrats to both of you!

I missed it because of the typo in sp_attachdb. Thought it might be intentional, but was wrong.

As an aside, Microsoft recommends against that specific method. They say to...

The one problem I've had with something like that was when a lower-license version of SQL Server was installed on a machine with higher-license instances.

Specifically, it had an instance of...

You're welcome, and thank you for the kind words.