one more thing...this should be online rebuild.

Here is the table defination:

Coloumnname Type

idvarchar

part_numbervarchar

erial_novarchar

good_qtyint

bad_qtyint

locationnamevarchar

employeenovarchar

createdbyvarchar

creationdatedatetime

lastupdatedbyvarchar

lastupdatedatedatetime

lastupdateloginvarchar

downloadstatusflagvarchar

downloadbyvarchar

downloaddatedatetime

No Identity columns defined.

can you provide me the trigger which will collect the spid, loginname, and the host from where it is running, when a deletion occured.

Yes, we did that but no use.

We have set up the Profiler, but no use.

no, we don't have any triggers on that table

winash (10/11/2010)

---

This works only for the default instance - not for a named instance. Best way to go about renaming named...

Yes, you can rename the instances after installation:

sp_dropserver old_name

go

sp_addserver new_name

go

Permissions

Only members of the setupadmin and sysadmin fixed server roles can execute sp_addserver.

but its not a good practise to change the...

vixvu (10/5/2010)

---

Your second main query should work but you had a parenthesis in the wrong place. Here's the corrected version:

SELECT servername, dbname, CollectionDateTime, datafileinmbs, logfileinmbs, databaseinmbs

FROM temp2

WHERE (CollectionDateTime...

amarsale (10/2/2010)

---

hi,

write following query in a dataset and then add that dataset to the report parameter named say => ServerName

select distinct servername from temp2

union

select 'ALL'

Add the following query to...

Abs-225476 (9/30/2010)

---

Hi

Like Veeren4urs said you need to have a dataset which will provide a pick list for the parameters, something like :

select distinct country_name from customers

union all

select 'ALL'

Then...

george sibbald (9/28/2010)

---

logshipping creates a SQLAgent job to backup the log. So set the alert to execute that job. The job itself can be disabled so it doesn't run to...

select distinct servername from temp2

UNION

SELECT 'ALL'

Not giving required result.

Select distinct servername from temp2 is the query in the dataset.

Will below code works?

SELECT distinct servername from temp2

UNION

SELECT 0, 'ALL'

or do I need to do any modifications ?

Log backups are configurred as part of the logshipping, So I think its not possible to setup a thresh hold or a job in Logshipping configuration.

If it is individual log...

You might have configured the intervel for log backups in log shiping....try by to set it some what less interval from present interval

This might help you!!!