Hello --

Thank-you for your reply. It turns out one of the other administrators deleted the databases in question, and neglected to tell me. I have reconfigured the...

Hello --

I double-checked the database that was the target for the integrity check, and it is the one that is the subject of this discussion.

Hello --

I created a plan via the Maintenance Wizard that would do an integrity check to the database in question. When I ran this particular check, it completed...

Hello --

When I went through the motions to restore the database I made sure to go to the Files page, and change the FileStream location to the new...

My apologies for asking this: What log file should I reference to get the command syntax requested in your posting?

Thank-you.

Hello --

The filestream was moved via the following steps:

1. The database was backed up, and subsequently deleted within the Studio utility.
2. The database was restored...

Hello --

Thank-you for your reply. The errors that I am seeing are the following:

Date and time: 2017-06-09 06:06:36
Command: DBCC CHECKDB ([RayStationPatientDB_502_Q1_2017]) WITH NO_INFOMSGS, ALL_ERRORMSGS,...

Hello --

It turns out the system in question had not been added to the appropriate Active Directory organizational unit prior to my logging onto it.

Once that was completed, the...

Hello --

That additional line did the trick!

This script will work well for us, and I just want to thank everyone for their help on this.

Hello --

Just so we're on the same page. The script in question is the following:

exec sp_MSForEachDB

'

USE ?;

if exists

(select table_name

from information_schema.tables

...

Hello --

I reran the script, and it did produce output. The only thing is, the names of the respective databases were not listed. Is the output based on the order...

Hello --

I inserted the syntax UNION ALL in the script, and the following errors appeared on-screen:

Msg 156, Level 15, State 1, Procedure FindPatient, Line 34

Incorrect syntax near the keyword 'UNION'.

Msg...

Hello --

Thank-you for your posting, I ran the script you posted, substituting the actual patient ID in the appropriate slot. However, the query produced the following error for

each of the...

Hello --

I have the list of columns within the table that will be queried, and I can insert them into the script at the two TODO locations. Is this the...

Hello --

The databases in question are the following:

More than likely it will be a single query at a given time, and all the dbo.RS_Patient_6 tables are identical.