Can some one please reply ?

Please try increasing/decreasing the batch size else follow the below link -:

http://www.sqlbi.com/LinkClick.aspx?fileticket=svahq1Mpp9A%3D&tabid=169&mid=375

Please execute the below before setting up the logshipping. With the error I am presuming there is old entries. Execute both on primary and secondary.

use msdb

go

delete log_shipping_primary_databases

delete log_shipping_primary_secondaries

delete log_shipping_monitor_primary

delete log_shipping_monitor_history_detail

delete...

My guess could be this link,

https://connect.microsoft.com/SQLServer/feedback/details/520260/smo-generates-huge-amount-of-adhoc-queries

Let me check is some one scripting the whole database.

Thanks,

Ganesh

Thanks....I missed those columns.

Thanks for your help

I had the simmilar problem in SQL Server Express Edition and this is because of conflicts on the Microsoft provided msi.

After the SP2 is introduced this is not compatible with...

Yep. Thanks for the input.....

Finally I got this.....Could you please take a look and let me know if I am missing other than this....

Thanks to everyone....

I hope this looks very easy to me....

If the date is last day of the month {

SELECT dateadd(DAY, -1, dateadd(MONTH, -6, dateadd(DAY, 1, @date)))

}

else{

SELECT dateadd(MONTH,-6,@date)

}

Please correct me...

Thanks for the reply

The requirement is like this. I have a table

Policy_Term

policyid      policy_term_id     valid_start_date    valid_end_date  

    X123             1                05/31/2006           NULL

    x123              2                11/30/2006          NULL

This is how the data looks, the same table has...

On the Database Server

 Right Click MyNetworkPlaces -> Properties

 Right Click Local Area Connection -> Properties

 Select Internet Protocol(TCP/IP) -> Configure

 Go to Advanced Tab -> Speed & Duplex

  If the value is "auto"

  Set the...

Thanks a lot Farrell......I appreciate it....

It worked......

Thanks,

Ganesh

Thanks mark....

Sorry, I didn't frame my question properly....

My question was whether using cursor is optimized or using a while loop is optimized.

Consider a situation I have to loop through all...

Hi Db Gurus,

Atleast I would expect a compile time error, whereas it gives me a run time error. That's wierd.

Please help me out.

Thanks,

Ganesh

Scott,

From your message I got to understand, you basically require a SQL Server Database connectivity for your ASP Pages. If Iam correct, proceed with the existing Developer Edition SQL...

Theoritically, you can't have two instances with the same name.

Step 1: Uninstall all the SQL Server instances, if got installed.

Step 2: Install Developer Edition as the default instance.

Step 3: Install the MSDERelA...