What are you using from .NET? Are you trying to read the raw XML or are you using the SSIS Object Model assemblies?

If you have 25 different file formats going into 25 different tables with different schemas then you will need 25 different Flat File Connection Managers, and at minimum one Data...

osql was deprecated in SQL 2005 so I would recommend to stop using it. sqlcmd is the replacement for it.

Are you trying to connect to a local or remote instance?...

All sp_MSForEachDB does is implement a cursor for you dynamically and run your code against each DB. Check the article I posted. The proc provided does the same thing, except...

From the provider error I am assuming you are trying to connect to a local instance. Please confirm.

Also, you posted in a 2008 forum but are saying 2005 SSMS. Please...

jrgomont (5/22/2013)

---

Thank you all for your replies. I fixed the issue. I have recreated a new variable and passed the value to the new one and it wirked. Fir some...

Mind sharing what was logged for the run where you missed backing up some databases?

Are you capturing the output of the job step to a log file or table, the options in job step advanced tab?

meh

UconnDBA (5/22/2013)

---

Can use sp_MSForEachDB, like below, to get results from each database on an instance.

EXEC sp_MSForEachDB 'select members.name AS UserName, RTRIM(LTRIM(roles.name)) AS RoleName

from sys.database_principals members

inner join sys.database_role_members drm

on members.principal_id =...

That's odd. I am not having any issues accessing my vm which includes a hyphen in the name:

Maybe check that you have permissions to access WMI on that server, i.e....

Looks like a validation error. Is it safe to assume that any paths to the attachment file are determined dynamically at runtime? Many times the problem with deploying to a...

In short, you can't, at least by Microsoft-supported...

ODBC would be my first choice these days but that only covers your connectivity, not the code going against the database. Unless you are writing ANSI-standard SQL that is so...

What about cases where a User-defined Database Role is a member of db_owner?