Forum Replies Created

Viewing 15 posts - 46 through 60 (of 172 total)

  • RE: Data type for Identity column

    You could setup a job that would reset (RESEED) the identity value using the DBCC CHECKIDENT command.  This can only be done by the table owner, sysadmin, or members of the...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    June 1, 2006 at 10:24 am

    #641233

  • RE: What datatype to use for primary key if the table is going to have a billion rows?

    mkeast, I do understand "kludge" (or "kluge") and it basically says that we on this forum may present solutions but those solutions are not the best solutions.  They may work but...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    May 26, 2006 at 3:06 pm

    #640453

  • RE: Users retained in DB when restoring to alternate server

    Sorry - ignore this post. 

    I just reiterated what was already answered.  I just missed it in my initial read.

     

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    May 19, 2006 at 1:05 pm

    #639082

  • RE: What datatype to use for primary key if the table is going to have a billion rows?

    Thanks once again, Joe, for your brow-beating and demeaning response that was of no help!

    Add to that the insult you just gave so many on this forum by referring to us...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    May 19, 2006 at 9:39 am

    #639043

  • RE: The Best Job

    Coach youth soccer!

    I started doing this about three years ago because of bad coaches and now I love the game and I love the kids.  I love to watch them...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    April 17, 2006 at 10:12 am

    #632796

  • RE: Import all the db tables to Excel sheet

    01000101-01101110-01100100

    01101111-01100110

    01100010-01110010-01100101-01100001-01101011-00100001

    01000111-01101111-01110100

    01110100-01101111

    01110111-01101111-01110010-01101011-0011101000101000

    E-n-d

    o-f

    b-r-e-a-k-!

    G-e-t

    t-o

    w-o-r-k-

     

     

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    March 28, 2006 at 8:58 am

    #629208

  • RE: Import all the db tables to Excel sheet

    01001001    I

    01110011    s

    01110100    t

    01101000    h

    01100101    e

    01110010    r

    01100101    e

    01100001    a

    01101110    n

    01100101    e

    01100011    c

    01101000    h

    01101111    o

    01101000    h

    01100101    e

    01110010    r

    01100101    e

    00111111    ?

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    March 28, 2006 at 8:09 am

    #629179

  • RE: Import all the db tables to Excel sheet

    01010111    W

    01101000    h

    01101111    o

    00100111    '

    01110011    s

    01010011    S

    01100011    c

    01101111    o

    01101111    o

    01110100    t

    00111111    ?

     

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    March 28, 2006 at 7:11 am

    #629144

  • RE: Import all the db tables to Excel sheet

    Try using the sp_tables procedure in a stored procedure and put the results into a temp table.  You could then use bcp to move the data to a CSV file...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    March 17, 2006 at 7:58 am

    #627320

  • RE: HELP - Recovery Model

    The log is only 10 MB and it is set to auto-grow but when the percentage would drop it would drop from around 70% down to about 20% but the...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 27, 2006 at 8:39 pm

    #617606

  • RE: Determine if a DB Backup is in Progress

    This will only let me know if the database is recovering.

    I have tried the DATABASEPROPERTY and DATABASEPROPERTYEX.  I checked the status in DATABASEPROPERTYEX while a backup was running and all...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 27, 2006 at 1:28 pm

    #617564

  • RE: Can''''t Convert a coma seperated list into a resut set

    Create the following function:

    CREATE FUNCTION udf_Generate_Inlist_to_Table(

     @list varchar(8000))

    RETURNS @tbl TABLE (listitem varchar (200) not null)

    AS

    BEGIN

     DECLARE @pos  int,

      @textpos int,

      @chunklen smallint,

      @str  nvarchar(4000),

      @tmpstr  nvarchar(4000),

      @leftover nvarchar(4000)

     SET @textpos = 1

     SET @leftover = ''

     WHILE @textpos <= DATALENGTH(@list)/2

     BEGIN

      SET @chunklen = 4000 - DATALENGTH(@leftover) /...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 26, 2006 at 7:40 am

    #617163

  • RE: Trace Flag 2861

    cmille19, I believe you are right.  While I was doing some work last night I found some remnants of a trial version of QuestCentral software I had installed on this...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 24, 2006 at 6:55 am

    #616647

  • RE: Trace Flag 2861

    No, no one else is working on the server.  This is a small server just for me for test some SQL Server stuff.

    I did some research before I posted so...

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 23, 2006 at 10:28 am

    #616492

  • RE: Reporting services problem after reinstalling framework 1.1

    I know this was a long time ago but did you ever find a solution?  I am working on the same problem right now and it is in our production environment.

    Thanks,

    hawg

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

    January 16, 2006 at 11:39 am

    #614976

Viewing 15 posts - 46 through 60 (of 172 total)