Viewing 15 posts - 13,036 through 13,050 (of 14,953 total)
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...
July 2, 2008 at 8:04 am
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...
July 2, 2008 at 8:02 am
Different paths shouldn't be a problem. What kind of errors are you getting?
July 2, 2008 at 7:50 am
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...
July 2, 2008 at 7:48 am
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...
July 2, 2008 at 7:42 am
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...
July 2, 2008 at 7:38 am
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....
July 2, 2008 at 7:28 am
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,...
July 2, 2008 at 7:17 am
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...
July 2, 2008 at 7:12 am
Run a trace on the server is one way. Check the transaction log is the other.
July 2, 2008 at 7:05 am
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...
July 2, 2008 at 7:04 am
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...
July 2, 2008 at 6:53 am
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...
July 1, 2008 at 3:39 pm
You're welcome, and thank you for the kind words.
July 1, 2008 at 3:28 pm
Viewing 15 posts - 13,036 through 13,050 (of 14,953 total)