I understand. You are asking about numbers as numbers, not a dictionary order. Then if you know your number as a string format you may convert string to an integer...

Add the Order By like this if you know that the number starts at the third character:

Order By substring(MyField,3,20)

If you don't know exactly how many letters are there before a number...

I would use Profiler trace with Audit Login, Audit Logout and Audit Login Failed events, set the rollover size 5 MB, once the file rolls over and the previous file...

Dan,

Do you know what is it that takes so much space in Master? Did you try to run sp_spaceused to see where does the space go?

First, you can start the trace right away.

Second (and this is what I normally do): I open Enterprise Manager Current Activity Window , ask the app developer the user name...

Daniela,

You would like to use SQL Server Profiler and create a Trace for the Security Audit events: Audit Login, Audit Logout and Audit Login Failed.

Nice!

I would add the following points in regards to High Availability:

- REQUIREMENTS (in Upper Case) document that specifies exactly what do the want

- Recovery Model

- DRP

- Virtual Server (as in...

Did someone really tested in practice?

If nobody wants to test I will test in the afternoon

Eric,

I am not sure you can define a custom server-level role, I have not heard of one. There are several fixed server roles and you can Grant/Deny/Revoke certain statement permissions...

Eric,

There are easy ways to create a script based on a list. But I would not advise it in your particular case. I would ask your network administrators to create...

English!

Talking about the language, the question should say not "which models CAN you use" but "which model(s) SHOULD you use"

I do agree with all that BOL does say we CAN...

I talked to this server support person and we decided we did not need these features that use MSDE and we uninstalled them, MSDE included. Then I installed SQL Server...

Susan,

Please, note that if your server is DELL some DELL server utilities do install MSDE. I was surprised too when found MSDE on a brand-new server. Then the server support...

Steve,

Thanks. I think it is not the Windows issue by itself but an application issue. Maybe a Microsoft Application issue. Something reset the BAK files association to something related to...

I too have a job on one 2005 server going towards other servers daily and querying MSDB and sending me an email. But nothing can replace a visual check and you...