If there are well defined logical relationships between types of users, then you definately need to enforce this with foreign key constraints, or else referential integrity and performance issues will...

You said that both companies and individuals are basically 'users', which I assume means that they both login to the application with a profile and perform similar tasks. There could...

You stated "I was trained on SQL Server 2000 and pushed into Database Administrations..." as if it wasn't your choice to make. You also mention you're not having fun, the...

In my proc, I have the following two lines:

select @sql = 'insert into lookups (fieldname) select distinct '+QUOTENAME(@fieldname)+' from '+QUOTENAME(@tablename)+' where '+QUOTENAME(@fieldname)+' IS NOT NULL and ltrim(rtrim(convert(nvarchar(max),'+QUOTENAME(@fieldname)+'))) <> ''\'''

exec /*test*/...

As an alternative to SQL Server Agent, you could use Windows Scheduler and PowerShell scripts.

http://www.eggheadcafe.com/software/aspnet/30631798/server-2003-task-schedule.aspx

10 GB could accomodate an inventory of several hundred thousand items and tens of thousands...

It sounds like you've got something working with SMO, but as a side note for anyone interested, the following will list all parameters of datatype 'smallint' for all user created...

Eric, you touched a raw nerve by suggesting Access over SQL Server, so expect a bit of hate. With that said...

Microsoft Access offers no real protection over SQL Server with...

Execute a "checkpoint", and then again confirm if the secondary file has increased in size.

If someone is developing something like a desktop application for release as shareware, and they feel it's important to protect the contents of proprietary reference tables and SQL queries, then...

I don't think the option is available in the SSMS table designer, but look up CREATE TABLE in SQL Server Books Online, and see the option { TEXTIMAGE_ON { filegroup...

If the instance of SQL Server is running on the user's desktop, then by default, they are a privillaged user. Even if you embedded and encrypted the SQL statements inside...

I understand that you have hundreds of tables, and you want to "form relationships" between them. Could you describe in more detail what the objective is?

I'm thinking that this is...

-- Here is the setup:

declare @sample table (RecID int, RecType int, Hierarchy int, Msg char(1));

insert into @sample Values (1, 5555, 10, null );

insert into @sample Values (2, 5555, 20, null...

If you get them all to line up nose to rear, then you're lucky. It's been said that managing IT developers is like trying to herd cats.

-- create and insert a table variable containing missing numbers.

declare @missingnumbers table (n int not null primary key);

insert into @missingnumbers

select 1 union select 2 union select 4 union select 5...