Interesting, This article is the third item in the list on the home page.

Give er a read.

cheers

http://www.sqlservercentral.com/columnists/dasanka/callingcomfromtsql.asp

Size of db is reported using this system stored procedure

sp_helpdb

There are several ways to shrink a db, check books online for

DBCC SHRINKDATABASE

dbcc shrinkfile

A log file is an integral part...

Look for information_schema in books online.

It describes how you can get to that data using microsoft created logical views.

such as information_schema.columns.

select *

from information_schema.columns

where table_Name = 'mytable'

GL

I'm not exactly sure what your asking.

Are you using query analyzer?

Unless you are creating derived/calculated columns, you should be able to see the headings.

select userID, username, groupName

from tbl_users U

Inner join tbl_group_memberships gm on U.ID = gm.userID

inner join tbl_groups G on gm.GroupID = G.ID

order by username

if a user belongs to many groups you will have 1...

or

if your in query analzyer, select the database your working in on the top of the app.

Or in query analyzer

use Mydatabasename

Select *

from mytable

The addition of another ndf file will only be benefitted by putting that new file on a separate drive.

DB size is limited by the space on the disk. but at some point...

What do you mean set up variables?

And when records are inserted into table1, how do you know there are new records in table 2?

Is ther some kind of relationship between...

declare @foo varchar(5),

    @bar char(10)

set @Foo = 'abc'

set @bar = replicate(' ',10 - len(@Foo)) + @Foo

select @bar

The reason its slow is because by using a wildcard in the beginning of the string eliminates all chance of using an index to eliminate any candidate rows.

Full text indexing...

What username are you typing? Are you a member of DBO, and are all the tables created with an owner of DBO?

usernames as owners are there for a reason. From...

Nice, an advertisment article, the link at the bottom doesn't even work.

I'm surprised you'd come in here and ask a completely vague question and expect us to do all the legwork for you.

your initial question was fine

"Can anyone recommend a website...

Sounds like a poor way to solve the problem.

Data integrity will be a major issue for this type of solution

What if a user creates a record for the wrong department?

You...

I'll tell U if you hire me.

Try searching for and reading up on SQL DMO