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...

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...

Sorry - ignore this post. 

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

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...

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...

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-

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    ?

01010111    W

01101000    h

01101111    o

00100111    '

01110011    s

01010011    S

01100011    c

01101111    o

01101111    o

01110100    t

00111111    ?

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...

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...

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...

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) /...

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...

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...

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