Create an SSMS shortcut that relies on the Runas and specify your other account in the runas parameters.

Another option is to create a little powershell script and place it on...

From a SQL server standpoint,

SQL server passwords are inherently less secure than Windows authentication; you can use a brute force/dictionary attach to attempt to get SQL server access. Windows Authentication...

Here are the numbers after today's 12:00pm transaction log backup. Missed the pre-backup numbers.

VLFs or dbcc loginfo(yourdb) returns 288 rows.

dbcc sqlperf(logspace) returns Log Size of 1588 MB (or the 1.5GB...

Thank you for the quick response.

I read the article and it says "If (once the log backups have been setup and scheduled based on the database's RPO) the log is...

I think it's okay ... search engines promises someone to stumble on this thread and they will have a fix to their issue. I'm just browsing hoping to gain more...

I have issued the following

USE [dbname]

GO

REVOKE CREATE VIEW...

That could be it. Not sure what is SPN ... but from the looks of this http://technet.microsoft.com/en-us/library/bb735885.aspx

this may very well be...

It's an existing LinkedServer. When I right click, Script to New Query Editor Window, I get the following: ***server name changed for obvious reasons ***

/****** Object: LinkedServer [ABC] ...

CREATE VIEWS permission denied in database 'DBNAME'.

Edit:

I actually found http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/bfd630bc-e405-4f9d-b63f-f673b3f4ccf5/

that has the same issue. They are saying it was a...

I clicked on the database name, Security tree, Users, right click his Username, Properties, Securables on SSMS2008. There is nothing on the Permissions: Explicit.

When I run

USE [dbname]

GO

EXEC sp_helpprotect...

There is no explicit permissions granted / deny on that username.

Great. So...

Sorry for being missing for so long; have been busy at work. Happy to report I passed 70-432.

codebyo (7/19/2012)

---

... it 's kinda awkward to have to study for many...

What do you mean by "new certs have to be renewed"? How do you renew it? Have to sit for another exam?

Thank you so much for all the opinions and insights.

I am primarily Oracle DBA (at my current job); and certified at both 10g and 11g. However, we do have a...