I think you need a query like this:

SELECT

D.key_no,

D.org_code,

D.test_data,

D.status_code,

DT.org_code,

...

Hmm, interesting. Since I can't duplicate this I have no idea why it would be blank. The source for sysprocesses and sys.dm_exec_sessions are different so the difference must...

It sounds like you have the resultset property of the execute sql task to something other than None and it should be none. Unless you aren't using an Execute...

OLDCHAPPY (8/30/2011)

---

i'm migrating all columns. the problem is the image column, which i have read cannot be used in import/export. (still don't fully understand why!) i have not found a...

It's hard to say. It is very close, but the implementation is just different enough that it probably isn't. ...

A regular database backup consists of ALL the files in the database, so you'd have one 100GB database backup. You can do FILE or FILEGROUP backups to break up...

Are you sure that you have exceeded the alert threshold? Set it to an absurdly low number to test the email and then once you've validated that it is...

It depends on what you are going to be doing with the XML in the database. Will you be storing it as the XML data type? Will you...

Can you explain what you are doing with the variable? Are you using it as a static start date variable for the package? Are you populating using a...

Since the Import/Export wizard creates an SSIS package, you can save the package, then view it in BIDS to try to resolve the error.

What is the destination column type...

Try checking out this blog post, http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx, to help troubleshoot the error.

You can also look at this blog post, http://weblogs.sqlteam.com/markc/archive/2011/07/11/regaining-sysadmin-access-after-a-lockout.aspx, and the links it contains to learn how to...

Joie Andrew (8/27/2011)

---

Ah, okay. I ask because you won't be able to use sys.dm_db_index_usage_stats then since dynamic management objects were not introduced until SQL 2005. You could try using the...

Grant Fritchey (8/26/2011)

---

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them....

I'll just up...

ALZDBA (8/26/2011)

---

According to your script, IMO it is quit normal DRI checks may take a long time.

One of my standard advises for DRI is to support FK with matching indexes,...