I must have had a very week moment

The pitfall was the query !

SELECT  sysFile.groupid AS GroupID

, SUBSTRING(sysFile.groupname,1,30) AS FilegroupName

, SUBSTRING(sysObj.name,1,30) AS ObjectName

FROM...

Are you using a command object with parameters to address the storedproc ?

Is the commandtype "storedproc" ?

Are the parameters defined with _exactly_ the same db-column-type (datatype, length, precision, scale, ...)...

Any hackers manual Chapter 1 Section 1 Paragraph 1 :

Logon with the default : for SQLserver user 'sa' password '' 

thanks for the reply.

fillfactor is default

(sql2k sp3a)

avgFreebytes = 38

I guess having near 100% pagedensity and near 100% ScanDensity the extendfrag maybe does not matter.

Some vendors generate ddl which only contains NVARCHAR alphanumeric columns.

Why ? "Just because we do."  

IMO this way the used components can...

IMO if you implement "ON DELETE CASCADE", you have to inform everybody who codes against your db who has write/delete permissions.

- Is it a good practise ? I'm not defaulting...

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.