You can consider partitioning your data on different drives. You can do partitioning by year or may be months if you want to. This way your performance will not suffer....

Yes. You will need a liscence for upgrading to 2008. If you want permanent test enviroment buy a developer version.

You will have to configure inbound rules for port 1433, 80 and 443 . The last 2 for reporting service and first one for sql server.

Plus rules for...

Hi,

Thanks for your reply. What I really want is that once the reports are put on the new server, the reports with subscriptions on them remain inactive, since I dont...

From purely programing perspective: I dont think this while loop will terminate

while (select id_promotionSub FROM dbo.sipFTdataStage)=5

begin

update dbo.sipFTdataStage

set net_price = 55

end

Steve is right in the previous post.

Hi,

Thanks for your reply. Actually after posting here, I tried migrating the reporting service from 2005 to 2008 using the msdn document. I used the approach of installing 2008 reporting...

Check your connection string again. If you have variables or configuration files check them too. I have feeling that the same server is being pointed in both the destinations.

You can skip the len(bookid) part by lion

SELECT MAX(convert(INT,SUBSTRING(bookid,3,8))) FROM tablename

If you are ready to spend around 50 dollars then it would be better to move to developer edition rather than putting efforts to migrate to mysql. Mysql has...

@Chirag and @home2end

I found this on msdn.

LIKE supports ASCII pattern matching and Unicode pattern matching. When all arguments (match_expression, pattern, and escape_character, if present) are ASCII...

SELECT * FROM sys.dm_exec_connections

SELECT * FROM sys.dm_exec_sessions

SELECT * FROM sys.dm_exec_requests

do u find increase in log size only or data file or both. I have done many migrations and have seen increase in log size sometimes. But since my migrations...

You need to use virtual drive to install the software. There are some free ones available for limited time period like alcoholsoft120. There are many others too. you can search...

Is there a specific reason you want to disable it?

There are two things you will have to do:

1) You will have to open create an ininbound firewall rule for ReportingservicesService.exe

2) Rule to Open the port 80

The machine need not...