that's to be sure the leading zeroes are in place with hours < 10.

maybe just creating a trigger on each view may help out.

create a new table to monitor all objects.

create table dbo.T_MyMonitorredObjects

(ObjectName varchar(256) not null primary key

, UsageCounter int not...

did you drop and restore the db 'test' ?

If yes, check the user's default db.

if you should split for reusability,

and you cannot see any reusable parts,

what's left to be split ??

NEXT_RUN_DATE is int and not datetime and should be converted to datetime.

use something like this :

convert(datetime,substring(cast(run_date as char(8)) ,1,4) + '-' + substring(cast(run_date as char(8)) ,5,2) + '-' +...

- take a look at sp_attatch_db in BOL.

- you cannot attatch sql2k mdf/ldf to sql7 servers.

- You'll also have to sync db-users after you've attatched.

   use [User-db]

go

print 'print @@servername +...

installation gets stuck when "gathering install info"

Unless your sp has been defined using the "with recompile" keyword, it will only compile at first run (when loaded into proc-cache). Whenever it is kicked out of proc-cache it...

The only way of explaining why all of a sudden your proc is using an other execution plan is that is has been explicitly recompiled or that is has been...

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...