GilaMonster (7/30/2015)

---

Lookups aren't related to seeks. Lookups will only be > 0 on a clustered index or heap. It's the number of key lookups/rid lookups done.

Updates are any modification. Insert,...

A similar question has been answered before see :

http://www.sqlservercentral.com/Forums/Topic508540-1291-1.aspx

Jack Corbett (7/14/2015)

---

Backing up a SQL Server database is an online operation so you don't have to suspend operations on the database in order to get a backup...

Thanks, get some 'false positives' for calls to stored procedures in the master, but this is working...

Used the code:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A_test]') and OBJECTPROPERTY(id,...

Sorry that I was not clear.

I would like a list...

Hello, thanks for your attention.

While messaging in this forum I came up with the following sollution:

-----------------------------------------------------------------------------

-- Solution method 1

-- Create a temptable of an actual table, where the identity column...

Sean Lange (12/12/2014)

---

Generic tools in a database are fraught with problems. They sound really cool but in practice they usually are pretty bad. They are incredibly difficult to build because...

I am building a generic tool. *)

The tool can be used on tables which are not in existence yet.

Ben

*)

More specific...

Yes I think it is over complicated, hense the question.

But I did not find a less cumbersome solution.

The specific usage was to add a stored procedure...

Yes this is what I was after.

Thanks very much for pointing me in the right direction.

I just implemented this within my code and it does...

First of all thanks for the example. (Kudos).

I adjusted the example see below. (The identity does not get updated)

When an update is done, all fields are updated exept the identity...

First of all thanks,

Now I see I did muck up a bit, the temp table ##WW should have been ordered, see the code below. Probably lost that part of the...

Thanks for both answers.

I'll probably will go for Luis solution.

This will solve my problem of generating views for more than one database using a single stored procedure.

Thx

Ben

Additional information.

The Showcontig information from both situations is very simular.

dbcc showcontig('B')

/*

-- FROM AN ERROR SITUATION :

DBCC SHOWCONTIG scanning 'B' table...

Table: 'BIL_Performed_Activities' (1157579162); index ID: 1, database ID: 11

TABLE level scan...