You create the column Jmessage initially but don't pull over the message to populate it.

I'm playing with it now and modified this piece of code with the addition in bold.

--Change...

you can modify the following line to handle more naming possibilities on tables

SET @Statement = 'UPDATE STATISTICS ' + '[' + @tablename + ']' + ' WITH...

Would adding the option(maxdop 1) help in this case?

One other gotcha if you ever have a 64 bit instance of 2005 trying to connect to a linked server that's a 32 bit instance of SQL 2000 then you...

There is a free option for Reporting Services on SQL Server 2000. This link should get you started: http://www.sqlservercentral.com/articles/reportingservicespartioverviewarchitectureandinsta/1303/[/url].

As far as 2005 Reporting Services you could start with :

http://www.microsoft.com/sql/technologies/reporting/default.mspx

http://www.databasejournal.com/features/mssql/article.php/3573361

Hope...

Before you do the update, try to do a select and see what you are dealing with.

I wouldn't go below Crystal XI.

However, have you considered the Reporting Services that comes bundled with SQL Server 2005? It might be a better option.

are you connecting to another 2005 instance?

I've had better luck with the commands vs the gui.

EXECUTE sp_addlinkedserver @server='remoteserver', @srvproduct='SQL Server'

EXECUTE sp_addlinkedsrvlogin @rmtsrvname='remoteserver', @useself='false',

@rmtuser='username', @rmtpassword='password'

Maybe I need to clarify.

The SQL Server 2005 instance on Server 1 will be building a database from the data contained in a SQL Server 2000 instance on Server 2.

An...

yea, we are already running 64bit OS with 32bit SQL.

If it's 2005 and the DTS package (legacy) or SSIS package runs from 2005 and builds its data from a 2000...

Have a look at dbcc memorystatus and see what it says

1. Add /PAE to boot.ini

2. Give SQL 14GB of RAM

sp_configure 'show advanced options', 1

RECONFIGURE

GO

sp_configure 'awe enabled', 1

RECONFIGURE

GO

sp_configure 'max server memory',...

http://www.microsoft.com/sql/editions/64bit/SQL64bitAdvantages.mspx has a few more details as well.

It would appear that it would be a better idea to start moving towards 64bit on x64.

We are currently running 32bit SQL...

Can you possibly rephrase your question? I'm not sure I understand if you are only asking about 70-431 exam specifically. As for as a pdf goes, I believe preplogic offers...

http://www.red-gate.com/products/SQL_Data_Generator/index.htm

You could also just loop through it and do it manually.

This isn't exactly what you are wanting but maybe it will point you in the right direction. I don't have time to play with it right this minute.

http://www.sqlservercentral.com/articles/Monitoring/20010422115752/84/[/url]