Relatively easy concept... have a character defined that acts as a separator.

EG. ¦,;: could all be used

IT,HR,Sales.... etc

You will then need to LOOP through, pulling a value off each time...

I know most seem to "love" this concept of face-to-face time, but generally as a DBA you are working on multiple items of work at once and you have to...

Is the backup drive a "shared" backup drive, so multiple backups being written at the same time?

I would be looking at the SAN backup drive as the bottleneck.

JET drivers are not supported on 64bit.

I know for SSIS, in order to create a connection to an EXCEL file, you have to run SSIS in 32bit mode. Never...

Where is (and was) the backup file being written? Was the backup to local drives as well? Is the current backup to SAN or another server? Perhaps a routing issue...

OCTom (2/18/2011)

---

I was asked what my favorite animal was. I answered cats. The interviewer was a dog lover and stopped the interview right there.

Another strange one was when I...

Why?

I implemented an Integration (SSIS) Server at one of my previous places and its still going strong.

Odd question, but why?

SELECT

CASE

WHEN X = 10 THEN 0

ELSE...

Just noticed this on 2000.... been too long for me as well.

Some examples of tables, data and usage would be useful. How many pages are in these tables (less than 1000 wont re-index as you expect)?

I am about to speak to my manager (in the next week or so) about working for home 2 days a week. Problem is, that I live (well family friends,...

1 stored procedure with a mass of declared variables and GOTO statements, nobody would want to reverse engineer that :hehe:

Of all the apps out there that use SQL code, the...

can you post the full error as it stands in the log? as well as the string for the ODBC connection?

Marco V (2/22/2011)

---

isnt the error then login for user...

have you tried using the user name and password to logon and then access SQL? Has someone "removed/disabled" the AD account?