My philosophy on pruning (for procs anyway) has been to only prune procedures that (1) are completely unused, and (2) can easily be confused with other stored procedures because of...

I think the question that needs answered the most is the earlier one about whether the log file ballooned overnight or has just grown over time because you aren't doing...

DBA is different from SQL Developer and I think being a developer, industrial experience is very important. I used to work with people coming out of college without any...

After all, just because you know insurance doesn't mean that you've got an instance understanding of some new set of business requirements that have occured because of a change in...

I have recently moved from a company that was completely IM-integrated to one that does not utilize it at all, and it shocks me how much I miss it...of course...

My experience as I move across industries has been that the only "must-have" that is often non-negotiable is a degree, and that has been because at some point in the...

It sounded like the problem was that User1 is currently mapped to dbo and the DBA did not wish it to be...?

AndyG

You need to associate dbo with another user (SA is always a good candidate if you are using mixed auth)...

USE 'DBName';

EXEC sp_addalias 'sa', 'dbo'

You may need to droplogin on...

With Multi-instance clusters (Active-Active or Active-Active-Active) we have always applied the patches manually so that we can control the ultimate destination of the instances (Instance 1 on Node A, etc.)....

For...

The reason you receive errors when you parse the query is because you have not yet run the initial piece of the script which set the options etc and RECONFIGURE's...