Thank you!  We may look at building a powershell script to do this, but comparing the mdfs to sys.databases is exactly the concept we needed.  SQL Server DBAs are the...

Fantastic reminder about this.  I don't have the luxury of getting to sit in my ivory tower and say "that's not my problem" in my environment when others make questionable...

"Adam wrote this article to try ANSI if he can PAD his resume…. On."

July 24, 2017 at 7:13 am

#1952359

"The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information,...

Someday I would like to learn to remember that I have been here before....googling this same situation, seeing I encountered it 2 years before and that two years before that...

Vision Solutions' Double-Take Share is another third party process that works. Alternatively, if the source Oracle tables have some kind of "row version" (it could be a datetime field...

You could use OPENROWSET to create a temporary table (example and link to example web page below) and check that the stored procedure definition matches your table variable definition.

SELECT ...

http://datapigtechnologies.com/blog/index.php/running-a-sql-stored-procedure-from-excel/

I've used this technique before for some quick and dirty "reports"...

We encountered this as well. We were writing a process to purge old backup files, using xp_cmdshell to bring back a DIR listing just like you have. We...

Kevin, I want to say thank you! (Kevin and I were co workers for a time, in fact at the time he wrote this post!). I am running...

"Be excellent to each other"

In your query, CAST the first field as a certain length and that should reduce the width it allocates in the email.

Sometimes I find that by going to linked servers in SSMS and setting the provider (I believe this would be the Jet provider) in and out of process sometimes "resets"...

SQL Server is not really an interface platform like Access. Typically you would handle user input and the interface through another programming language, although you could use Access as...

Your organization needs to suppoort saying no; it's easy to say this from an ivory tower perspective but you have to have management and executive support. At some companies...