Because at the time of my post I had very little sleep and VSS usually equates to Visual SourceSafe in development environments. With that said, SQL Server 2005 supports database...

By default, normal database users don't have this ability. They only have it if the CREATE PROCEDURE right has been granted to them. In some cases you can use DENY...

SQL Express is based on SQL Server 2005. I know you can't take a backup from SQL Server 2005 and restore back to SQL Server 2000. So I don't believe...

Here is the official word from Microsoft:

How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server...

Sat in a briefing by Microsoft on this one. The most the speaker (one of the program managers at Microsoft) had seen mirrored from one server was 20, and that...

Yes, they announced the Always On initiative here at TechEd. I still haven't gotten a chance to pigeon-hole some SAN vendors, but basically there are certified vendors (HP, EMC, etc.)...

By default, the location is:

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

Shoot a private mail to Steve Jones. The SSC.com provider I don't believe is in the DC area, but you can get his experiences.

I'd tend to lean more towards what Colin recommends, because I don't tend to trust upgrades. I like clean installs, but that's me. In any case, have you run this...

One option is to write an extended stored procedure using Visual C++. You could then call the extended stored procedure from within SQL Server to generate the email. If you...

I'm not sure what the interviewer was getting at then. You can do the SELECT INTO using a (NOLOCK) (or just an INSERT ... SELECT with the (NOLOCK) if the...

1) How you connect via EM doesn't determine if the SQL Server is in Windows Authentication or Mixed Mode. That's determined by a registry value SQL Server reads on startup....

Could it be a collation issue where the SQL Server is configured to be case sensitive?

C2 auditing is resource intensive because it probably captures more than what his auditors are asking for. However, it will certain do the job. Look at doing server side traces...

The best practice is to create user-defined database roles within your SQL Server database. The roles should correspond to, well, roles. For instance, in a help desk database, you might...