Forum Replies Created

Viewing 15 posts - 226 through 240 (of 420 total)

  • RE: stuck with restore

    In your case you'll want to use the STOPAT flag with the full restore, not the log restore.

  • RE: stuck with restore

    Take a look at what I said above. Here, I'll paste it in here so you know what I'm talking about.

    The short answer to that specific scenario is I...

  • RE: Parsing excel with SSIS

    I don't really have any insight into the office team. I'm on office'07 though and it appears to be buggy there too. However, I'm not sure if it's...

  • RE: How to import hundreds mdb files to onr table?

    I've got a video I did last week on working with for each loops. Give me till tomorrow and I'll post it for you.

  • RE: stuck with restore

    OK, now maybe I'm not explaining myself clearly either. Try what I told you to and get back to us.

  • RE: Parsing excel with SSIS

    Well there's evidently something really screwy in the driver because I not only recreated your problem, I was able to introduce new problems.

    However, I was able to do...

  • RE: stuck with restore

    The short answer to that specific scenario is I don't know. I could honestly see it going either way. However, you're talking about recovering a specific transaction, so...

  • RE: stuck with restore

    Well, it really depends on the mode that the DB was in when you ran the delete.

    You may have screwed yourself with the log backup though. If...

  • RE: ROWIDTOCHAR

    We don't really have an equivalent to that function. If the values already exist in the data you're importing then assign varchar on the target. If not, then...

  • RE: Check if table exists on IBM As400 database using Vb.net sql statement

    Sorry dude, this is not an IBM forum. I would suggest trying one of those. You may have better luck.

  • RE: 64bit server not accepting logins

    There's no difference between the 2 platforms so you shouldn't be having this issue as a result of being on 64bit.

    And if you're positive that you've got it setup for...

  • RE: passing values from child to parent package

    I'm not sure, but my initial thought is no.

    However, the easiest way to get it done is to have the child save the new value to a table and just...

  • RE: server roles

    Somewhat, but their exact permissions aren't self-explanatory.

    For instance, it's not a given what the difference between serveradmin and sysadmin is. That's not in the names of either...

  • RE: capturing errors from xp_cmdshell

    I can't imagine why you'd be doing it like this anyway. The ways you were forced to do things in DTS aren't the ways you'd choose to do them...

  • RE: server roles

    Yeah, the documentation inside sql itslef is lacking to the level of disappointment.

Viewing 15 posts - 226 through 240 (of 420 total)