Talk about a tempest in a teapot!

Doctor, Lawyer, Engineer, Information Technologist, Cop.

Which one of these has too many syllables?

Anyways, IT Guy it is better than computer guy. Around here,...

Well, I managed to fix this, but I'm still troubled by how I did it.

Ignore the code.

I dropped the clustered index and rebuilt it with a different name. Everything...

DECLARE myCursor CURSOR

LOCAL

FOR

SELECT UsgSvc.UsgSvcID, Customer.CustID, UsgSvcMultiProvision.StatusID, UsgSvc.DisconnectDate,

UsgSvcMultiProvision.ProvisioningCompanyID, UsgSvcMultiProvision.PICTypeID

FROM UsgSvc, Customer, UsgSvcMultiProvision

WHERE UsgSvc.CustID = Customer.CustID AND

UsgSvc.UsgSvcID = UsgSvcMultiProvision.UsgSvcID AND

UsgSvc.CustID = @CustID

SET @CgException=60000

SET @errorcode=0

SET @ErrorString=''

...

I pseudocoded a lot of stuff in the example because I didn't think it would be important. I'll post the rest tonight.

Yeah, that is part of my problem.  For the client-server app they need db_writer, which would then spill over into other, non-validated and non-logged, applications.

Fear is a great demotivator.  I can't think of anything that will break that can't be fixed by entering the new password.  For example, if something has the old password...

The sp_trace_% stored procedures can run profiles and dump them to files.  Be prepared to spend a few hours learning how to configure the traces.

Be careful however, I've generated several gigs/hour of...

This is actually one of those topics I've seen discussed and rediscussed extensively, yielding more confusion than answers mostly.

What I want to know is if I set the /3gb switch...

Are you running Windows 2003?  Standard or Enterprise?

"Got to respectfully disagree here. Imagine we didn't correct the idea that the earth was the centre of the universe, that the earth is flat, that the theory of relativity...

Yes, but if I don't want to force a snapshot, then I can to this on my test instance:

sp_repladdcolumn 'TableName','ColumnB','int NULL','all',null,0,0

I see it actually go from my publisher to my...

I just realized there is another thread in this group where this is discussed in more detail.

I recently worked as a DBA under a (extremely painful) SOX environment.  Not only did I not have admin rights to the box, but I was also not SA on...

My (limited) understanding is that this is a measure of memory pressure.  If the pages are being dumped faster, it means SQL Server decided it needs those resources freed up since...

If you go to the exchange server and open the email account that SQL is using, do you see the emails?