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...

Would simply adding this additional condition give you what you need?

.. and right(origin_tracer_no,2) <> 'No'

Management in the IT industry is different from other industries. If you look at the resume of IT managers, you'll see that most of them actually do not have a...

A clustered index on column(s) containing non-sequential data is one explanation for extremely poor performing inserts and updates. With a clustered table, SQL Server clusters the data pages (basically like,...

I've never liked the idea of creating foreign key constraints with the cascade UPDATE/DELETE option. Let's assume that a misguided developer is trying to insert/update data in the INV_STATUS dimension...