thanks rubes

we are going with the same approach stop data entry, move db's to another server, change DSN, rebuild server, install standard edition, move back the db's, and change the...

Glenn is there more than 1 instance of SQL or an instance of other RDBMS on the box?

I used to get that error.

it was fixed after i ran this:

sp_configure 'remote query timeout', 0

go

reconfigure with override

go

THANK YOU ALL FOR ALL YOUR REPLIES.

RUDY i modified my existing statement and added DATABASEPROPERTYEX and also used it to avoid read only databases as well.

 select name from sysdatabases

 where name...

SQL ORACLE it doesn't work

select name from master..sysdatabases where dbid not in(1,2,3,4) and status > 511 and status <1024.

so will use this query from now on.

select name from master..sysdatabases where...

Thanks for your replies

I will use

select name from master..sysdatabases where dbid not in(1,2,3,4) and status not in(512,528,536)

or i can use

select name from master..sysdatabases where dbid not in(1,2,3,4) and version is...

If you want to change the SID in sql 2000 you can use sp_help_revlogin

http://www.databasejournal.com/features/mssql/article.php/2228611

in sql 2005 you can use:

USE master

GO 

IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL

  DROP PROCEDURE...

Yes you can use SQL Agent to Execute a VB Script.

Create a new step.

Under Type choose "Operating System Command (CmdExec)"

In command window type the full path of the vbs.

C:\yourvbscript.vbs

sp_change_users_login 'auto_fix', 'yourlogin'

Run the above statement in the restored database.

This kb article should setup you up properly.

http://support.microsoft.com/kb/274750

The setup will ask you to point to Disk2 folder.

Disk 2 contains Tools, BIDS, SSMS and Books online.

Thanks steve.

I came up with this:

create

proc Exec_SQL_JOB

as

use

msdb

DECLARE

@PrintMessage NVARCHAR

You have to upgrade to Access 2007 or rewrite from scratch in 2007.

Access 2003 + SQL 2005 database (migrated from sql 2000) = nightmare.

That compatibility feature does not apply for...

Utsab

If you're using Execute Task to move data using ODBC here is something you might wanna take a look at.

http://blogs.simplifi.com/brucet/archive/2006/01/27/668.aspx scroll to the middle.

To find missing data use this query...