Amazing - yet another new thing that I have learned about SQL !!!

Where I am at we have 270+ instances mixed about 60/40 at SQL 2005/SQL 2000.

Our plan is to bypass SQL 2008 totally and thenpossibly look SQL 2008 R2 some...

oops ... did in in 2005 - well varchar(8192) will work - then one has to walk through the text ...

Sorry 2 Gb is all you can use in SQL Server 2000 Standard

here are some useful links:

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1157395,00.html

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

As DBAs we generally have 'different' working hours. Lots of nights and weekends - especially for 'production support DBAs. So why would you find it 'odd' to be on SSC...

Give this a whirl ...

One of the three following statements or a combination of the two of these statements will work. This depends on whether there are 'newlines', 'carriage...

Clarification please ...

You state that you are using Windows Server 2003 Enterprise but only SQL 2000.

Is SQL 2000 'Standard' or 'Enterprise' ?

If it is 'Standard', well, the extra memory does...

hmmm ... could it be that there is a transaction log backup that runs DBCC ?

and just what is the format of the 4 bytes shown ?

Try downloading .NET fremawork from MS - and reinstalling.

After that you will have to execute Windows Update to reapply the SPs and security fixes for .NET.

Try perfroming a 'repair' on .NET 2.0 ...

We have found this to work in some instances.

Ask your network folks if they changed any routing or firewall rules.

Also, if your network is segmented it may not show all servers. Again of you have multiple V-LANs the...

I have had good luck with Sybase's PowerDesigner. Below is a link to the evaluation version.

http://response.sybase.com/forms/PowerDesigner15Arch

here is a query I used for the same situation in SQL 2005:

update msdb.dbo.sysdtspackages90

set packagedata=

CAST(

replace(CAST(CAST(packagedata AS varbinary(MAX)) AS varchar(MAX))

,'OLD_SERVERNAME\INSTANCE,PORT#','NEW_SERVERNAME\INSTANCE')

AS varbinary(MAX))

where name like 'SOME_SUBSET_OF_PACKAGE_NAMES'

I believe that it can be modified to...

yet another way to skin the cat - no sp_executesql

alter proc usp_get

as

begin

declare @sql varchar(100)

select @sql='create view dbo.vw_select as select '+char(39)+'2009-01-01'+Char(39)+' As a'

print @sql

exec (@sql)

end

go

exec usp_get