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' )

use SCOPE_IDENTITY( ) 

According to books online :

• IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.

• @@IDENTITY returns the last identity...

Here is a nice article regarding SQL Server UPDATE STATISTICS Tips :

http://www.sql-server-performance.com/statistics.asp

Maybe it helps in solving this problem.

If your sql-column is defined nullable (. gets null), there should be no problem with SAS.

This is what we use to bulkload data using SAS.

%let sqlDWH =

   provider="sqloledb"

   properties=('data source'='mysqlserver' 'Initial Catalog'='mydb'...

Check Autostats db-setting !

sql7 and sql2k pre sp3 exec sp_dboption N'yourdb', N'auto create statistics', N'true'  --

sql2k sp3 : ALTER DATABASE yourdb SET AUTO_CREATE_STATISTICS ON...

msdb is a systemdb. I don't know if #-version restore is supported

Personaly I would script the sql7 jobs, alerts, .... and then implement...

don't add these keys if your sqlserver works !

search for a "TcpPort"-key. It has to be there and then you know you'll adjust...