kapil_kk (8/30/2013)

---

You are adding a new column with IDENTITY property and it works..

The thing is that we cant...

Float only takes 4 bytes to store if you specify a precision of 24 or less.

It takes 4 bytes to store a float value (up to 24 digits).

DOH, just realized, the proc should check for an explicitly specified schema name and parse out the names before adding brackets:

alter PROC [dbo].[sp_getrecords]

(

@TableName sysname

)

AS

declare @SchemaName sysname

set...

Sean Lange (8/29/2013)

---

ScottPletcher (8/29/2013)

---

Here's an idea: let the proc get the schema name for you :-), then you don't even have to type it in at all!

create PROC [dbo].[sp_getrecords]

(...

Yes, that should work, although it's a lot of extra work and...

Jay Purvis (8/29/2013)

---

No, it was a development server, but it is still a pain to not be able to restore system databases.

Especially when the builds were released only a month...

Yes. Once a transaction begins, it must either...

No.

You can't make an IDENTITY skip a specific value(s).

If you start at -1 and increment by 1, there is always the possibility you will get a 0 in...

Here's an idea: let the proc get the schema name for you :-), then you don't even have to type it in at all!

create PROC [dbo].[sp_getrecords]

(

@TableName sysname

)

AS...

Row selection is controlled by "only" 4 tables:

FROM

...

ALTER TABLE dbo.tblemployee

ADD ident int IDENTITY(1, 1) NOT NULL

Edit: Added "NOT NULL"

Isabelle2378 (8/27/2013)

---

Yes, that is correct Scott. The tables have unique clustered indexes that was all added when the ERP system was installed to maintain its referential integrity. I...

Sean Lange (8/27/2013)

---

Isabelle2378 (8/27/2013)

---

Hi,

My tables do not have primary keys and as I understand it, transactional replication requires primary keys so my question is: Has anybody found a 3rd...

You might need to use ROW_NUMBER() instead, if there is any chance of a gap/missing number in the EntryID column (note that by definition identity columns can have gaps in...