If you 're still using the default modeldb, you can copy another model mdf and ldf file from an other server ( dev ? )  to the datafilelocations of your...

did your temdb-file(s) autogrow ?

If this autogrow takes more time and the query times-out, you also get the message db-full , but the grow...

did you stop and restart sqlagent after you implemented the first alert ?

You have to when you implement your first active alert.

This generates the script you need.

SET nocount on

create table #tmpPKeys(

TABLE_QUALIFIER sysname,

TABLE_OWNER sysname not null,

TABLE_NAME sysname not null,

COLUMN_NAME sysname not null,

KEY_SEQ smallint not null,

PK_NAME sysname  null )

-- Get PK-info

insert into...

Is this what you want ?

It generates all needed statements without executing them !

-- creatie test case

if object_id('T_ParentMC') is null

begin

 create table T_ParentMC (

 col1 int identity(1,1) not null ,

 col2 int not...

Best practise is to always specify a specific database in your connectionstring !

Rule No x : never rely on a @#|$! default ! 

If...

I/O wize perfer the 6*.... but also provide the chanels ! or you may encounter chanel-queues.

you may want to post some sql and ddl (including indexes) and we may be able to help.

Like

Nice lock-hints

what's

set @mothercared = (select top 1 pin from ...)

did you resinc the users ?

check sp_change_users_login  in BOL !

this is what I use after restore :

Be carefull because it users systemobjects which way in not preferable !!

That is not what triggers are ment to do !

You can return the latest identity-value using SCOPE_IDENTITY ! Check BOL.

NET stop yourservice

NET start yourservice

will also you the trick if you're authorised.

p.s. even with msde you can make regular sql-backups,

    so there...

select id

,  case when isnull(ltrim(record1),'') = '' then 0 else 1 end

+  case when isnull(ltrim(record2),'') = '' then 0 else 1 end

+  case when isnull(ltrim(record3),'') = '' then...

If you are doing an index-review ...

run a trace that captures all sql and sp activity during a typical timeframe and have that analyzed by ITW, leaving it the option...

how about querying sysprotects ?

the errormessage is pointing to authorities granted by the user you want to be dropped.

select user_name(grantor), *

from sysprotects (nolock)

where grantor = USER_ID (  'youruser' )