Forum Replies Created

Viewing 15 posts - 16,456 through 16,470 (of 39,970 total)

  • RE: What's Today?

    You don't get anything. The question was written in fun a few months back and most people in the US see Apr 15 as tax day. It was extended this...

  • RE: implementing counter

    A few things. First, you cannot use SET inside a SELECT. If this code is going to handle one insert at a time, you would move to an IF statement.

    DECLARE...

  • RE: DDL TRIGGER SQL SERVER 2000

    That data sent by the client can be spoofed. You cannot count on those values in sysprocesses as they are provided by the client. There is no authentication here.

    If you...

  • RE: implementing counter

    You're not making sense here. How does the counter for c increase by 1 when the counter for c increases by 100? Doesn't flow.

    Is everything based on column a?

    If there's...

  • RE: Convert Military date to standard

    I tried a dozen or so of the formats, and none of them will convert 13:10 (in a datetime) to 1:10.

    The only solutions I've seen were to convert to char,...

  • RE: memory alert

    Check the alert, and see what it is configured for. This ought to be under SQL Agent in Enterprise Manager.

    As far as limiting memory, Jack is correct. You need to...

  • RE: DDL TRIGGER SQL SERVER 2000

    What do you mean with client_host? do you mean the host name sent through the connection? That's completely arbitrary. It defaults to the windows host, but someone can fake that....

  • RE: SQL 2008 INSTALL ERROR

    I'd also reboot and try it again. If you downloaded the media or burned it, double check this isn't a corrupt file by installing on another machine

  • RE: Memory configuration

    Look at Target Server Memory for each instance. This is what each SQL instance would like to have. Chances are it will be high, but you might get a proportional...

  • RE: SSIS diff tool

    I haven't heard of any good ones. It's a hard problem to solve visually and most vendors have avoided it.

  • RE: Convert Military date to standard

    the storage format isn't really important. The display is what is important. Display formatting is separate from how the data is stored.

    AFAIK, you will have to convert this hours to...

  • RE: Acces Database from offshore

    First, always back up locally. this ought to be scheduled and not a big deal.

    If you are looking to transfer them to a central location, that's a copy function. Across...

  • RE: shrink mdf file problem

    What I'd recommend is that you shrink it a little, perhaps 25GB, then the do an index rebuild. So schedule those operations together, in that order.

    Once that's done, check free...

  • RE: Software to monitor databases by using query on multiple servers

    The problem with multi-connect scripts is that they sometimes fail and blow up. What I might look to do is have each server execute the query and store the results...

  • RE: SQL Query Help

    It will work, but this isn't a great way to store and query this data. You ought to look at refactoring this over time and storing those "slots" in another...

Viewing 15 posts - 16,456 through 16,470 (of 39,970 total)