'A small investment' - well, without any monetary benefit coming out of that 'let's try this' project, that's a no-go.

Furthermore, I don't like the way DevOps builds tiny...

What you do need, apart from the correct PowerShell version, is access to the BITS service. If that has been disabled or you do otherwise not have access to that...

Changed the code to =1, but I still get the same error during the maintenance...

[font="System"]

The index "PK_TABLE" (partition 1) on table "DB_TABLE" cannot be reorganized because page level locking is...

Durai,

Thank you. As I cannot change the database on a permanent basis, as we do not own the design of it, I may have to do a workaround of allowing...

Varun,

Have you checked if the account that your job is running as, has permissions on the database?

Cheers,

Rick

Varun,

Could you please provide a little context on what you are trying to achieve? With this short description, I can only say that you lack permissions to perform the query...

Cheers

Rick

Jim P. (1/24/2013)

Nadrek (1/24/2013)

But there are so many things that I'll find a developer has done and ask "What in the h*** were they thinking?" I'm glad the development team...

I partially agree.

Yes, developers should be develop software that can scale up and down as needed, but they still have to worry about the underlying 'hardware'. I put that between...

Lowell,

Thanks, now I understand the how and why. Always good to learn something.

Cheers

Rick

Thanks.

Still weird, as it did understand what I meant with PRINT @databasename 🙂

Ashish,

Thank you, your code does work. However, I would like to learn why my code does not work. Does it have anything to do with datatypes or something?

Cheers,

Rick

I'm not into e-books. While they might come in handy profesionnally (not carrying 32lbs of SQL books is much more comfortable), nothing beats turning a real page of your new...

Besides the pros and cons to setting the MAXDOP setting manually, there is one other factor coming into play: the application. An application may not allow you to have any...

SQL Server 2005 SP3 Cumulative Update 9 has been released.

Build: 9.0.4294

KB: http://support.microsoft.com/kb/980176

If both the Profiler Trace and the Server Side Trace were identically configured, and you saw different results in two different traces, the only conclusion that I know of is...