Viewing 15 posts - 2,791 through 2,805 (of 3,232 total)
This has been posted twice and answered here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=291273
June 29, 2006 at 10:39 am
You will still be able to restore from a complete backup, but if you are planning on rolling forward by applying tlog backups, you must have all of the tlog...
June 29, 2006 at 10:33 am
I think this is an Excel issue and not a BCP issue. Once you open the Excel file, right-click on the datetime column and select format cells. There select the...
June 28, 2006 at 1:00 pm
1. If you restore the master, it should keep the collation that it had previously.
2. In order to change the instance collation, you must rebuild the master database (as...
June 28, 2006 at 12:53 pm
SELECT O.mbrnbr,
O.accttype,
O.name,
N.mbrnbr AS Expr1,
N.accttype AS Expr2
FROM Oct O
LEFT JOIN Nov N
ON O.MbrNbr = N.MbrNbr and O.AcctType = N.AcctType
WHERE N.MbrNbr IS...
June 28, 2006 at 12:12 pm
You can use the NOLOCK hint in your select to prevent it from being blocked by another transaction that is locking the row; however, this means that you may have...
June 28, 2006 at 10:24 am
Convenience is for users and testers. Developers who do not know how the data is structured write poor code. By definition, a convenience is something that saves time and effort. ...
June 28, 2006 at 9:46 am
I guess I'm still not quite clear on the need to query the text file (especially using cursors). So you generate a text file on client machines using BCP, then...
June 27, 2006 at 2:41 pm
You may be correct, but I would still recommend watching your system log for other hardware related messages as your original message references a bad page file (which is in...
June 27, 2006 at 2:20 pm
The only way that I am aware of is if you would read that file back into a table and query that table, but that just puts you back at...
June 27, 2006 at 1:56 pm
"No, you do *not* need to run CHECKIDENT after deletions in your table."
Correct, you do not have to run CHECKIDENT (or any other method of removing gaps and islands from...
June 27, 2006 at 1:35 pm
Does your new server have the same CPU, RAM, and disk subsystem as the offending server? You may want to monitor these three areas and duplicate the problem on your...
June 27, 2006 at 12:58 pm
The vast majority of the time, a timeout expired message means that an operation is taking longer than the timeout threashhold. This is usually due to resource contention of some...
June 27, 2006 at 12:43 pm
A cube is more of a three dimensional object. It sounds to me like you have 2 dimensions here, right? Anyway, if you are looking for a method of storing...
June 27, 2006 at 11:51 am
Viewing 15 posts - 2,791 through 2,805 (of 3,232 total)