Yes we resolved it by changing the default value.

Right click on Server in Object Explorer of SSMS, then click on Properties, go to Connection page and change the Remote-Query timeout...

You need to script out jobs/logins and run the script on the SQL Server 2008. I think simply detach and attach of these system databases (master/msdb) will not work becuase...

Did Windows update updated SQL Server 2005 with SP2. If yes then do the above registration and I think it should work.

You can use below query to know the version:

SELECT...

SQL Server 2005 introduced the ability to partition a large relation into smaller logical chunks to improve the administration and management of large tables. It has also been used successfully...

Hi,

Thanks for your encouragement. Here are some pointers which might be helpful for you on table and index partitioning as well as on Filtered Index of SQL Server 2008.

Partitioned Tables...

Thanks Carla,

Yeah I missed to include declare statement, sorry for inconvenience.

Reader,

Kindly add these declare statement in script existing in first table of the article.

[font="Courier New"]DECLARE @CTO INT

DECLARE @DevManager INT

DECLARE @TESTManager...

The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. By default, these files are located in :\Program Files\Microsoft SQL Server\MSSQL10.\Binn\. Each instance of SQL Server has one...

Refer to the links below for clarification:

http://technet.microsoft.com/en-us/library/ms178028.aspx

http://technet.microsoft.com/en-us/library/ms190940.aspx

Thanks Chad for your clarification. This is exactly what I meant but it came other way which I didn't have any idea about. 🙂

Sorry for any inconvenience caused becuase of...

In my experiment from Microsoft SQL Server 2005 - 9.00.3042.00 to Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 upgrade of user database using backup/restore and attach/detach, it didn't change the...

I had similar issue in an environment with SQL Server 2005 with SP2.

I registered two dlls(command below) and its working fine now.

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\MsDtsSrvrUtil.dll

Hi,

I had similar issue and got resolved after registering dts.dll with following command:

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"

Refer to this KB article for more details: http://support.microsoft.com/kb/919224

Hi Mark Horninger, Jeffrey Irish, GSquared,

Thanks a lot for your encouraging words, it will definitely work as motivation forces in my future articles.

About intellisence feature, yes it works with...

Hi Sanjarani,

First of all, I would like to thank you for sparing sometime and reading the article.

I must say, I am delighted to have your valuable feedback and comments, which...

More details on "Maximum Capacity Specifications for SQL Server" can be found on the below given link:

http://msdn.microsoft.com/en-us/library/ms143432.aspx