Nicely written. Thanks for the explanation

Try installing SQL 2005 SP4 and check out http://www.sqlservercentral.com/Forums/Topic595592-146-1.aspx

check out http://ola.hallengren.com/. The script is excellant and if you don't want to actually do the reindexing you can set the appropriate parameter and just use this...

Absolutely the key is 'thoughtful'. The jacket I got wasn't a complete surprise. I was asked what size i wanted and I knew I was going to receive...

Non monetary rewards often are way more memorable. When I got my MCDBA my employer at the time bought me a jacket with 'Microsoft Certified DBA' embroidered on it....

While its an interesting idea, I'm not sure I really see a benefit here. I can already restore to a different name if I want so if this fuction...

Another way you could have accomplished what you wanted (gaining access to SQL) would have been to add your id to one of the groups

NWSRV2\SQLServer2005MSFTEUser$NWSRV2$DESENVOLVIMENTO

NWSRV2\SQLServer2005MSSQLUser$NWSRV2$DESENVOLVIMENTO

NWSRV2\SQLServer2005SQLAgentUser$NWSRV2$DESENVOLVIMENTO

And then log on. ...

I've never had any problems like this with the Forums. I use IE 7.

I agree with the article that this process adds nothing of value. There is no confusion between objects and prefixing them with object type only makes it difficult when...

Winnipeg, Manitoba Canada - right in the center of the country

Sorry for missunderstanding the question. 🙂 The code sure looks like it hasn't been updated to accomodate SP3. I can't answer for sure. I did find...

There is a 32 bit version and a 64 bit version for SQL Server 2005 SP2 and for SQL Server SP3. Is this what you are asking? this...

I periodically get emails extorting me to sign up for a PASS conference which I've never done. Beyond that I have no idea why I would join PASS. ...

see http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

for download of SP3

You may want to consider appropriate timing for your transaction log backups with respect to your full backups. Keep in mind the transaction log bakup is useful only in...