http://db.ittoolbox.com/documents/document.asp?i=2551

http://support.microsoft.com/default.aspx?scid=kb;EN-US;308126

Select Sum(RowCnt) From SysIndexes

 Where ObjectProperty(id,'isUserTable')=1 and indid in (0,1)

Think you need a bit more than this but it may help a bit!

http://www.atlantamdf.com/presentations/AtlantaMDF_111201_examples.txt

Bit of a quick hack!

Use split function from http://www.sqlservercentral.com/scripts/contributions/850.asp

Declare @Answ varchar(8000)

Set @Answ=''

Select @Answ=@Answ+strval+' '

    From (Select Case When Not strval like '%[0-9]%'

                        And Cast(Lower(strVal) as varbinary(8000))=Cast(strVal as...

Phillcart, sorry I was referring to the fact that with instr the parameters are 'really' switched around. Something I am running into myself between TSQL and VB/VbScript.

Do you use VB?

? instr(1,"123","2",vbTextCompare )

Need a bit more work!

Declare @Cnt Int,

           @MaxRecords Int

Set @Cnt=-10000

Select @MaxRecords=Count(*) From Orig

While @Cnt<=@MaxRecords

     Begin

     Set @Cnt=@Cnt+10000

     Insert SomeTable

          Select o.t+','+

              (Select t from Orig as oo Where...

One, I have used with some parameters/options at http://www.databasejournal.com/scripts/article.php/1500031

Agree can you post the error?

Permissions

ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These permissions...

Create Table YourOrigTable(T varchar(8000))

Go

Insert YourOrigTable values('****************************')

Insert YourOrigTable values('fld1=bbbb ,fld2=aaaa, fld3=dddd')

Insert YourOrigTable values('fld4=zzzz,fld5=eeee,fld6=nnnn,')

Insert YourOrigTable values('fld7=ddd,fld8=ssss,fld9=0980989,fld11=0u09')

Insert YourOrigTable values('****************************')

Insert YourOrigTable values('fld1=bbb1 ,fld2=aaaa, fld3=dddd')

Insert YourOrigTable values('fld4=zzz1,fld5=eeee,fld6=nnnn,')

Insert YourOrigTable values('fld7=dd1,fld8=ssss,fld9=0980989,fld11=0u09')

Insert YourOrigTable values('****************************')

GO

Select     IDENTITY(int, 1,1) as i,

           ...

Do the producer of the data in table 2 always write the date in the same format, example MM/DD/YYYY?

BOL 2000:

Query Analyzer Keyboard Shortcuts

This table displays the keyboard shortcuts available in SQL Query Analyzer.

Interesting!

http://lists.isb.sdnpk.org/pipermail/comp-list/2003-January/001741.html

Example:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Drop Table [dbo].[Test]
GO

CREATE TABLE [dbo].[Test] (
 [IntIdentityCol] [int] IDENTITY (2147483647, 1) NOT NULL ,
 [ColB] [varchar] (50) NULL...

BOL 2000:

The IDENTITY property can be assigned to tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) columns.

bigint

     Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).