Dynamic Disks are an easy way to expand an existing drive's size but they have some inherent overhead and create a less fault tolerant environment. I would avoid them whenever...

The A in A-DBN is for Alerts. If you simply want the DB Name in the output of a standard job why would you need a token? :Whistling:

You would just...

Yes. Keep experimenting until you learn them. Tokens do work, I use them all the time.

It could be any number of things but based on what you have stated it sounds like a good place to start would be with the Oracle driver and possibly...

Is this an SSIS question or a T-SQL question?

Just restarting Agent will not affect the Database Engine in and of itself. Restarting Agent can have some side-effects though that you'll want to check on beforehand. Check for jobs...

I think you are misunderstanding. The token in the print statement will not affect the Alert email, only the output of the job step itself. If you want to send...

If it were a deadlock scenario it would be sorted by the database engine (one would be chosen as a victim and be killed) in fairly short order.

You'll want to...

Tokens are to be embedded within the job step command text. They are replaced at runtime with the value pointed to by the token.

From Example A in the article I...

http://www.youtube.com/watch?v=0ZuC4MmMzcg

Try it like this:

WITH XMLNAMESPACES (DEFAULT 'x-schema:D:\APPS\Customer.xdr')

What you're asking is what Central Management Server was designed for.

blugecko (2/5/2013)

---

Hi There,

I use a connection string as follows to connect to my SQL Server:

Data Source=IPADDRESS;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=USER;Password=PASSWORD;Asynchronous Processing=True;MultipleActiveResultSets=True;Connection Timeout=60;

This works for most people connecting to it, however...

Without more detailed information about what you are trying to do and what you have tried so far all I can do is refer you to Books Online:

Using Tokens in...

Just a heads up, I just noticed you're using DBNETLIB which is a deprecated driver in SQL 2008 and to my knowledge is no longer supported being supported in SQL...