Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 6,583 total)

  • RE: problem calling stored procedure

    Lowell (2/21/2009)


    to get a procedure to run under the context of the database it is called from, doesn't it HAVE to be in the MASTER database and also at least...

  • RE: Backup and Restore data only

    Lynn Pettis (2/20/2009)


    Not using BACKUP and RESTORE. You'd have to export the data to files and then import those files.

    Nah - that's too much work. You'd have to...

  • RE: problem calling stored procedure

    Yes - there are probably several scripts already available on this site that do what you want.

  • RE: problem calling stored procedure

    When you run this as a script - it will run in the context of the database you are using. When you create it as a stored procedure, it...

  • RE: string building

    Seggerman (2/19/2009)


    I had this problem at an earlier job and it was a dog - arf! Making the WHERE select into a temp file helped a bit. If...

  • RE: queries across two database connections

    I would recommend using Redgate's SQL Data Compare instead of writing your own. But, if you don't want to go that route:

    1) Create a linked server from one system...

  • RE: How to convert INTEGER to TIME

    DECLARE @seconds int;

    SET @seconds = 14400;

    SELECT DATEADD(second, @seconds, '20090101')

    ,CONVERT(char(5), DATEADD(second, @seconds, '20090101'), 108);

  • RE: User vs. Instance\User

    Ahhh, yes - should have been clearer and stated that it shows up under logins. If you script the login, you will see the difference.

    For windows users it will...

  • RE: How do you manage a cluster in SQL 2005

    Yes - that is correct, if you count the private addresses needed for the cluster heartbeat connection. Forgot about those 🙂

  • RE: User vs. Instance\User

    If you look at the properties of each one of those users, you will see that the user with the instance\username is a windows user and those users without the...

  • RE: How do you manage a cluster in SQL 2005

    At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.

    One for each node

    One for the virtual cluster name

    One for the virtual...

  • RE: string building

    If you do run into a performance issue using the structure:

    WHERE (column = @parm OR @parm IS NULL)

    You can either move directly to Dynamic SQL, or you can try using...

  • RE: Selectecting records from the table falling in provided date range

    andrewd.smith (2/11/2009)


    If OP wants to select records where the date range in the table row overlaps the date range defined in the input parameters, then Vladan is right, and rtomkins'...

  • RE: Help to Select from 3 fields - no nulls & no blank strings

    What you have left to do is not going to be easy. Especially since you have no reliable method of determining that the first element in the space delimited...

  • RE: Trigger Vs Stored Procedure

    As written - your trigger is only valid when you can guarantee (for all time) that there will only ever be a single row updated at a time.

    If you try...

Viewing 15 posts - 5,521 through 5,535 (of 6,583 total)