I usually do what rbarryyoung says

But if you are deploying to many servers frequently, you can consider an SSIS package.

Use the Transfer SQL Server Objects Task. You can...

You have to do some diagnostics and post results unless you want to just get guessing answers.

on the db server in command prompt do:

telnet localhost 1433

do you get connected, or...

here is a query i use frequently when taking over databases I didn't create:

select b.table_name, a.name, a.type_desc

from information_schema.tables b left join sys.procedures a on OBJECT_DEFINITION(a.OBJECT_ID) like '%'+b.table_name+'%'

where b.table_type = 'BASE...

try this (you have some syntax incorrect)

DECLARE @cmd1 varchar(100)

SET @cmd1 = 'ALTER DATABASE [?] SET SINGLE_USER'

DECLARE @cmd2 varchar(100)

SET @cmd2 = 'dbcc checkdb('?',repair_rebuild) '

DECLARE @cmd3 varchar(100)

SET @cmd3 = 'ALTER DATABASE [?]...

change to

EXEC sp_MSforeachdb @command1="DBCC CHECKDB ('?')"

run this query instead

SELECT

SERVERPROPERTY('productversion') "version",

SERVERPROPERTY ('productlevel') "service pack",

SERVERPROPERTY ('edition') "edition"

Always suggest testing before installing a SP. So if you have a test server, do that first.

If...

I'd first check Oracle client folder (probably c:\Oracle) might need some perms.

Make sure the account you are running sql as has read access to this folder and subcontents.

Also, if you...

Get the ODBC Driver

http://www.postgresql.org/ftp/odbc/versions/msi/

then setup a standard ODBC link to your system DSN you create

http://msdn.microsoft.com/en-us/library/ms190479.aspx

I've never done it for this DB before, but works fine...

Sure this is possible.

Take nwind.mdb in root of C drive for example

Create new linked server in SSMS

Linked Server = NWIND

- Other Data Source Checked

Provider = Microsoft Jet 4.0 OLE...

from what i understand, what you are trying to do isnt supported by any OLE/ODBC provider I know of. Usually you encrypt a password when saved in a file...

You need to be a bit more clear on this..

Encrypted string in an application and building a connection string?

- decrypt password, build unencrypted connection string use that to connect.

Connection...

If you're just looking to transfer table data, create an SSIS package with a simple dataflow task.

Or you could look into the "SQL Server Migration Assistant for Access"

http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

I run this SP:

EXEC xp_fixeddrives

along with a bunch of other queries (error logs, failed agent jobs, db file usage, etc) against all primary sql servers on a scheduled agent job...