Brandie - are you still a dba? lol

Did you EVER get an answer for this? I have same question. I run 2012 ssms blah blah blah.

thanks if you...

how about if you bring the data down to your local just using bcp - instead of trying to go directly into Access?  after you have it local, then import...

To the original post...  Builtin\Administrators should not be removed but rather explicitly Denied.  The service accounts that run sql server should be domain level and do not require NT SA permissioning...

(I can take no credit for it, but I'm sure I found it on sqlservercentral)

try this...

if objectproperty (object_id('Sp_Shrinklog_Now'),'isProcedure') = 1 drop procedure Sp_Shrinklog_Now

GO

Create Procedure Sp_Shrinklog_Now @databaseName sysname, @duration Int =...

here's come ideas you can put together to be as simple or complicated as you want...

xp_fixeddrives - check to see how much remaining free space

check size of last backup batch...

Sounds like your environment is where DBAs are also sql programmers and will work with these standards directly.  I suggest you have a meeting with the most senior DBA "SDBA" (experienced...

I've had this happen.  Turned out for me to be some type of permissioning.  Remember the SQL Agent will run with whatever account starts the service.  You will need to...

Who are you hiding the data from or is this just an exercise to see if you can do it?  1 or 2 columns I can understand (salaries, credit card...

a customer of mine had a problem and I found in their DTS package they were using UNC naming to designate a file. When I changed this to a...

To administer(create, modify, run, stop, enable..) jobs you either have to be in sysadmin role or be logged in as owner of the job. with a little work, nearly...

My master database create date show year 2000. Anyone care to guess why this is if it was just built?

Paul, your script is good. thanks!