You should run a copy_only backup to the nul device to see if the problem is reading the database data or writing the backup file to disk.

backup database [MyDatabase] to...

MissTippsInOz (8/24/2012)

---

Such passion for our topic!! It amused me to note that the original poster announced he'd got the answer he required 9 days ago now and has, presumably, gone...

I'll bet...

If all of your steps are TSQL steps, you could record the job start time in a table in the first step, and then each step could do a lookup...

I think most maintenance is actually new development activity that was skipped during initial development because the developer was in a hurry, under pressure, incompetent, lazy, etc.

In particular, design review...

Phil Parkin (8/23/2012)

---

MSzI (8/23/2012)

---

I would suggest:

IF EXISTS (SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[ABC_SCHEMA].[ABC_TABLE]') AND [Type] IN (N'U'))

DROP TABLE [ABC_SCHEMA].[ABC_TABLE]

Because:

1. It's safer to check the schema in...

GSquared (4/24/2008)

---

I'm not sure if what you're asking for is "max" and "min". Take a look at those in Books Online and see if they will do what you...

This is one of my all time favorite threads about an EVA:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61024

I especially like the query posted by RobWafle at 02/01/2006 12:05:48 that had over 40 left joins.

I still stand...

I don't see why just...

I have never seen an implementation of EAV that was not a complete disaster.

Some of the main issues are:

Hard to maintain domain integrity.

Hard to maintain referential integrity.

Extremely hard to enforce...

What is a deep-model?

Do you mean something like an entity-attribute-value (EAV) model?

If you use mirroring, you may need to modifiy the application connection strings to automatically failover to the active server.

I am a little confused by what you said:

"I have done quite a lot with SAP systems and in particular with BI." but then you say "I dont have professional...

Rainmaker097 (8/20/2012)

---

Hi,

I am able to insert more than 8000 characters. but when I select after converting to varchar, it chops the values.

For example, if you run the blow, you will...

Each instance of SQL Server has an install log directory where the initial install and upgrades are logged

For SQL 2008 on my computer it is:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

From SQL...