Reporting services was released in 2004 as a separate tool almost two years after VS2003 was released. So I am not sure how you get the SSRS templates for...

I prefer the Agent because I have used a package that runs for five hours a day five days a week moving data from DB2 AS400 to SQL Server 2000...

This version of VS2005/8 is called premier partner edition generally known as BIDS it can only be used to do BI(business intelligence) development. If you want to develop databases...

Run the code below in Management studio, check the link below for more options.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

http://support.microsoft.com/kb/321185

You could run it with a proxy account for the Agent using Admin level permissions but in IBM or other RDBMS the owner of the package must also be admin....

I think you have got a cookie related bug in SSRS but the SSRS team never accept bugs so here is a thread with work arounds and two blog posts...

You may need source control which you can get with MSDN license or you could store all stored procedures in the databases using the stored procedures. That usually means...

So then I tried to create a proxy for SQL Server agent with a credential. I even gave the credential my domain account user and password to use (the...

I then navigate the CD to ..\tools\setup and try to run the SQLRun_Tools.msi directly and the installer comes up and starts going through the extracting and installation preperation then the...

Running aspnet_regiis is required for any development using Asp.net 2.0 and above IIS version is not relevant. So yes run the aspnet_regiis and you also need to add the...

I have looked are your code many times and I did not see any transactions and you are not using cursor which uses implicit transactions like fetch. You are...

Those configurations don't work in Asp.net in some cases because SQL Server and Windows are just made by Microsoft security in both are very different.

Hi,

Parts of the original post was wrong because Windows 2000 comes with IIS 5 not IIS 6 and if you are using IIS 7 with SQL Server 2000 may need...

Check the thread below I have added two threads from another forum the ODBC connection should work your problems may be Admin permissions related and SSIS instance running. If you...

LINQ which is math in .NET objects still exists what is being replaced by Entity Framework is LINQ to SQL which is a mistake because what is the issue is...