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

Hmm, no point in maintaining indexes for 11 months in which they are not being used.

But 30 days? That's a different q. Typically it depends on the size...

In Oracle, a TRUNCATE indeed cannot be rolled back. [Oracle uses a fundamentally different way of handling table allocations that would make it essentially impossible for Oracle to rollback...

GilaMonster (8/27/2013)

---

davidandrews13 (8/27/2013)

---

good advice. i'll certainly get in the habit and also update Procedures as-and-when i get to them so that, come day zero, it wont be such a big...

Sorry, but that's...