Why are you using script task to do this? Doesn't a file system task meet your needs?

SQLRNNR (7/21/2014)

---

I am a bit surprised this hasn't been asked yet and it seems REALLY important.

Why do you have 2000 log backups to restore?

If you truly have that many log...

Even though this site is owned by RedGate you might want to post this in the RedGate support forums. There isn't anything I can find in the UI that...

You need to filter sys.dm_db_index_usage_stats by database_id like this:

SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],

I.[NAME] AS [INDEX NAME],

USER_SEEKS,

USER_SCANS,

USER_LOOKUPS,

USER_UPDATES

FROM SYS.DM_DB_INDEX_USAGE_STATS AS S

INNER JOIN SYS.INDEXES AS I...

That expression get's yesterday's date not today's date. I usually just use =Today() as the expression to get today.

What error are getting?

What do you mean by what started the job? Do you mean you want to know if someone is using a PoSH script or .NET application to start the...

You can add a rowversion column to the table and do a comparison of the rowversion in the table and the rowversion stored in your app and then tell the...

You haven't told us what you are using for querying the database? Are you using SSRS, .NET, java? What are you using for database access, ad hoc SQL,...

Rebuild definitely does...

Yeah, it's a bummer. It would be nice if it was an errors collection like .NET has or a virtual errors table like inserted/deleted.

Definitely sounds like a parameter sniffing issue. The reason the ALTER works is because that causes a recompile at the next execution of the procedure. Updating statistics or...

You can't login using that login. Certificate based logins are designed to be used when signing a module (Procedure/function) that does a task that requires elevated permissions that you...

Greg Edwards-268690 (7/17/2014)

---

First thing...

Sean Lange (7/17/2014)

Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for me to have to fork...

Okay. I don't really get logging the new value since the new value is always the value currently in the table. All you need to do is change...