I think I will have to live with the cursor because Im using this script on an ERP database which hosts 1350 tables.

Thanks for all your help. Appreciate it.

Regards,

Dilip

This query looks impressive, But can i do away with the cursor i.e. Can I extend this query to place the criteria value for dataareaid column or I will have...

I'm using the QA and here's my script..This will retreive all the rowcounts for all tables in a database which has this column called "dataareaid" and for a particular criteria.

declare...

Hey Phil,

Thanks for the prompt reply!

Actually, Im executing a batch of T-SQL statements and getting it in a .txt file, Here, I want to suppress this error message Server: Msg...

By using DBCC INDEXDEFRAG / REINDEX should have the done the job for you..Extent Scan Fragmentation shows a higher percentage if your indexes are spanning multiple pages and not in...

Hi,

Did you try re-initializing the subscription option and also to manually re-run the snapshot agent? Becoz I had also run in some different types of problems with SQL CE Merge...

Thanks both of you for the inputs. I actually have applied the latest service pack(SP4) on my server..

Thanks and Regards,

Dilip

If some fragmentation exists, either you can use DBCC DEINDEXFRAG or DBCC DBREINDEX which will build ur indexes with an appropriate fill factor which you can provide..

You are right logical...

As long as your full and tlog backups are okay and u can recover them in any emergency, then it's alrite..

But saying so, u always wud like to have a...

Hi Ashik,

Integrity check are used for determining corrupt data, reallocation of indexes, repairing index pages etc. Integrity and optimization tasks are time-consuming and if it fails will effect the full...

In the second query, you might be getting this error "Incorrect syntax near 'sp_dropserver'"..

This is because, "You can execute a stored procedure without using the EXEC keyword if the stored...

Raj, you can do these settings and prevent the QA from showing you the exception messages, but the recommended approach would be to check the variable in tsql and then...

You can handle the divide-by-zero exceptions by using SET ARITHABORT ON/OFF switches. For more help, u can refer BOL. All the best

Rajesh,

You are welcome,buddy.

I'm not sure if I understand your business logic correctly but what I get from ur post is you are looking for a different connection to SQL...

Here you go...

Step1

I created a sample stored proc in my northwind database which inserts one record into region table

--**************************************

create procedure usp_InsRegion

as

set nocount on

insert into dbo.region values('5','Asia')

--**************************************

Step 2 Execute it the...