for SQL Server 2005

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

select count (*) from sys.sysobjects where xtype ='U'

select count (*) from sys.objects where type ='U'

select count (*) from INFORMATION_SCHEMA.TABLES where table_type='base table'

for SQL Server 2000

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

select count (*)...

You have 2 instances of SQL Express running .

and also make sure you do not drop indexes from system tables / views .

Always run this query on the objects on which you want to drop indexes :

select (object_name(object_id))...

thats right .You need not to find it in sp_configure .Its enabled by default but you need to be sysadmin.

when you create a SP and want to put values at run time then you declare the SP as the way you have shown :

create PROCEDURE [dbo].[ee_updateStatus]

(

@v_assetId varchar(25),

@v_status varchar(1),

@v_timestamp...

what is the error that you get : check the event and SQL Server logs

post the errors here

To remove distinct you need to make sure that the parent child relationship be maintained in the tables and the columns should not have the redundant values .

So you will...

SELECT TOP 1* FROM TicketActivity

SELECT MIN(TicketId) FROM TicketActivity

The above 2 queries are different.

But you can also run the min query as below :

select top 1 ticketid from TicketActivity order by...

I remember this happened with one of my clients in the past .

But sadly i am not able to find that mail with all the steps i took .

basically it...

as per MS best practices :

-> put data files on a separate physical Raid 1+0 drive

-> Put Log files on a separate physical Raid 1+0 drive

-> Put tempdb...

Why to apply so many differential backups when one would suffice 🙂

Once you find it , stop taking backups on network .

you will endup loosing it many times .many a times if you verify the backups you will find them corrupt...

small repro for you based on above answer by wayne :

step 1 : create table test (a int,b int,c int)

Step 2: insert into test values (2,2,2)

go 10

step 3: create proc...

atlast after so many exchanges you got the answer .

Yes , you need to keep on applying the logs for the updates to that the snapshot on the mirrored database...

We cannot restore the filegroup backup from one database to another ..