Thanks Elliott,

Yes agree with your point.

I am trying to do data archiving. Moving OLD records from Live DB to Archived DB.

So live DB should have records only those records which...

Well, the purpose of giving that example was to explain the context.

I have seen similar situations that sometime Insert path OR sometime Update path at same level takes the precedence.

Is...

I have asked how to use them and NOT what to use ?

Any script/idea already avaiable please.

Thanks.

Got it.

Added two hidden column in the table

Textbox1 =RowNumber("DataSet1")

TestBox2 =1

Now in report footer Added following 3 TextBoxes with expressions

TextBox3 = =MIN(ReportItems!textbox1.Value) -- For first record number

TextBox4 = =MAX(ReportItems!textbox1.Value)...

Thanks Gail,

SSIS maintenance cost is very high. There are so many tables in the production. Everytime there is a change in structure, you might need a change in SSIS as...

Oh yes agreed. Thanks.

But thats what i am trying to do. Delete record before setup log-shipping and then remove Log of that deletion before i create a Log-shipping. So whenever...

1. You can check your job history if the backup job completed successfully.

2. Check in msdb with following query

select database_name, backup_start_date, backup_finish_date, is_damaged

from

msdb.dbo.backupset

where

database name like '%YourDB%'

3. Check the backup file...

Hello,

Check in the activity monitor if there are any constant wait types OR blocked transactions.

If it is a live OLTP database then plan this activity in off-peak hours.

Check what is...

Based on your example, Not really sure what you really want.

Try "Ntile" in the in-line view and then write a grouping query on that result.

Otherwise give some more specific and...

Adding using SSMS GUI.

Subscription created successfully.

I can see the subscription under publication and under local subscription as well. BUT replication monitor is giving that error message.

SO?

Hello Experts:

Following are the steps:

1. Starting Agent

2. Initializing

3. Invalid column name 'is_not_for_replication'.

Following is the exact error message:

Command attempted:

if object_id('sys.sp_MSrestoresavedforeignkeys') < 0 exec sys.sp_MSdropfkreferencingarticle @destination_object_name = N'tblTable', @destination_owner_name = N'dbo'

(Transaction...

Thanks folks,

Don't get bored and frustrated 🙂

I believe that these questions can come to any beginner's mind and your experience can really help them deciding, if DBA is really a...

Great!

Now in a project life cycle, Ideally, who can best handle the project team ?

An experienced database (designer+administrator) OR an Application architect ? I think not System Administrator

Cheers

Hello,

Getting following error if i create an OLE DB soruce to remote DB

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked...

but why there is a delay when the setting is set to zero ?

can you read my detailed comments above.