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.

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