I couldn't get that to work. I mean the syntax is good, but I got the same result. Its true that these are 0-length strings. So to...

So you only have Primary right?

Add a new filegroup. Add two or more files to the new filegroup.

Start...

The problem was between the chair and the keyboard.

I was valuing the -S parameter wrong in my sqlcmd login attempt.

Thanks. I'll try that tomorrow. My window for stopping the server today is over.

Also verify the destination path is still valid in your Agent job.

How about the data in the Express db? Does it fail trying to return the same record every time?

I exclude Disabled in a vb script that queries AD.

Here’s the check for a user being disabled in AD:

(userAccountControl:1.2.840.113556.1.4.803:=2)

So to exclude use (!userAccountControl:1.2.840.113556.1.4.803:=2) in the filter:

strFilter = "(&(objectCategory=person)(!userAccountControl:1.2.840.113556.1.4.803:=2)(objectClass=user)(memberOf=cn=CERUsers,ou=CER,ou=intranet applications,ou=groups,ou=khs,dc=myhouse,dc=org))"

From the...

Sorry, when I said fail, I meant the final result set wasn't correct, not that it logged an error. A failure with the logic.

It's updating a person's old UserID...

There's a lot of data here. I think a make-table query would push the Access limits. And it seems like it would be an additional step. I...

This is really an odd one. The vendor's client software has to be installed on the PC that opens Access. The Access autoexec macro runs their software that...

If you were deleting all data more than 6 months old as a single batch and the delete was still running when the system rebooted, the recovery is rolling back...

Trust me, I know. I wasn't consulted. I've already scolded the offending parties. They rebooted the server this morning because they said it was "unresponsive". They...

Set results to grid, then Save Results As. Options are csv or tab delimited.

Just checked the recovery status - and its moved quite a bit. 24% complete (approximately 8 hours left), Phase 3 of 3.

How can you live up to the DBA responsibilities without covering the basics? You can't implement any DR plan or plan for future capacity if you don't know what you've...