Theres also INFORMATION_SCHEMA.ROUTINES view which you can get at least stored procedure and function names and definitions from.  All the INFORMATION_SCHEMA views are supposed to be...

Another method:

Open the Security entry in Object Explorer (at the server level, not the database level). 

Right-click on Logins and select New Login...  Give it a name, select SQL Server...

The bit type is treated more like a Boolean in SQL2K5, you can now use 'True' and 'False' in queries as well as 1 and 0.  Can you use a...

If it's a .Net 2.0 app, you could as a minimum encrypt the sensitive data section.  Still, no excuse not to use a least-rights account!

Not quite sure exactly what you're after here... If you want a script of the existing permissions in a database, in Object Explorer right click on the database in question, and...

To do a one-off copy of new SPs and functions to another database, just script them from Management Studio into a new query window, connect to the target database and...

Wow, where to start...?

The first thing to think about is the capacity of the PC you are running the database on.  I assume that you've got a single PC server which is...

Using parameters has the advantage of reducing the possibility of SQL injection attacks, as well as making it easier to move your SQL into stored procedures later (always a good...

_strSQL = "select f.food_desc as Food, jfe.quantity, jfe.calories, jfe.fat, jfe.meal_id as mealtime " & _

"from food f " & _

"inner join journal_food_entry jfe on f.food_id = jfe.food_id " & _

"inner join...

Alternatively, get someone to password protect it, don't let them tell anyone the password, and then kill them   Might be considered a...

NTFS permissions are definitely the way to go.  Only trusted personnel should be able to make changes to the permissions, and hence be able to make changes to the file. ...

i suspect that the integration package is disabling the trigger before doing the insert, then re-enabling it afterwards.  Not sure where that would be controlled from.  However, I'm not sure...

Generally I'd probably do pretty much what you're talking about, though I think I might be tempted not to stripe the two disks, just create one or more filegroups and allocate them...

The only excuse I've ever heard for starting a database field with an underscore was that it was then a direct match for a field in the client program (C++...

Hi Eric,

Can you clarify something where I think you've contradicted yourself?  You said: "A MODEL can only have one unique combination of facility, department, role, but a MODEL can have many unique...