I ran this on sql2k sp2

use northwind

go

dbcc freeproccache

go

create proc palzdbatest

as

DECLARE @IntVariable INT

DECLARE @SQLString NVARCHAR(500)

DECLARE @ParmDefinition NVARCHAR(500)

SET @SQLString =

     N'SELECT * FROM employees...

helas, with sql7 there is no xp_sqlagent_proxy_account

how is this working for SQL7.0 sp4  ?

I've seen...

"DATEADD(mm,-4,GETDATE())" would be preferable because that way, at.ass_stopdate will still be sargeble and it's index (?) might be used

select year(datetimecolumn) as Year_datetimecolumn

, month(datetimecolumn) as Month_datetimecolumn

, count(*) as Counter

from mytable

group by  year(datetimecolumn)

, month(datetimecolumn)

order by Year_datetimecolumn, Month_datetimecolumn

correct, but what about sqluser-id's and their password ?

Windows-ids can be relinked with this script

SELECT 'if not...

follow the ms-workaround ?

WORKAROUND

To avoid this problem, do not use the NOLOCK hint or the READ UNCOMITTED transaction isolation level, or do not run...

- SQL2000 ?  (sql7 has more pitfalls)

- If you only want to move user-db, you might consider to use the copy-database-wizard. This will have unavailability of the db at the...

there is migration-software on the marked. I just cannot recall the providers company-name.

The where present at last years PASS-conference in Seattle.

You will have to alter the object-owner !

this may help out :

Select  'print '' object : ' + u.name + '.' + o.name  + ''' '  + char(13) + ' go...

- keep in mind that sql also has to manage rowlayout, nullable columns also have the need for management-place (1 byte per 7 nullable columns). Check "dbcc showcontig" for your...

Every time sqlserver starts (or starts a db) it will check if data is consistent.

If it detects there were running transactions at...

sysdepends may give you the inventory.

sp_refreshview @viewname =  'viewname'  may perform what you are looking for

- Because your goal is to move the db to a new server and postpone application-adaption, maybe you can consider to move the db's and at the old location only...

When reindexing put your recovery model to bulk-logged or your log will grow by the size of the rebuild data..

But don't let this discourage...