You were told to use the @@ROWCOUNT function. Here is how you would use it:

delete from bill_detail where bill_detail in (9878506)

and policy = 4236807;

SET @v_delete = @@ROWCOUNT;

update prem set...

I'm going to go out on a limb here and say that you can't replicate to a text file.

mintsql (5/8/2012)

---

I'll try to be more clear:

We have a table, lets call it Automobiles. We also have a backup table of Automobiles before it was modified, called AutoB. In both...

I would say it depends on the size of the databases and the amount of activity on each database.

But by how much? 😛

You don't. SSC forum threads stay open.

looking at what your current max memory setting is at, you may want to consider changing it to a more resonable value, like 28672MB (28GB). If your installation of...

Cadavre (5/8/2012)

---

You can change the "zero" date at a server level, so test it before you count on it...

You should always specify the schema with the tablename in the from clause. Microsoft recommends this as well.

Just for S & G's try this:

DROP PROCEDURE [MyBook].[uspGetCatelogues] ;

GO

CREATE PROCEDURE [MyBook].[uspGetCatelogues]

(

@user-id BIGINT,

@RoleId bigint,

@CodeStatus...

Does this table also exist in the MyBook schema?

What schema is this table in? tblUserBookMapping

I have no idea what you are talking about. What do you...

How are you executing the stored proceudres and are you getting an error messages when you do?

I have created numerous indexed views and answered numerous questions about them here on ssc as well, made this an easy question. Thanks!