Yes, but you should probably read up on files and filegroups b4 you proceed.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_6epf.asp

a db can have many files in 1 filegroup . Which sql server will spread data...

What exactly are you looking for?

Sql server books online is quite extensive, and should be able to answer alot of your questions.

From Books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_07_7yw5.asp

Here's some more light reading

http://www.sql-server-performance.com/tn_stored_procedures.asp

Your basically trying to build a dynamic search.

where some of the fields in the where clause are optional.

this will help you

http://www.sommarskog.se/dyn-search.html

Or you can performan parameterized queries from within .Net...

In addition to this Use the view definition field to do a like for specific table.

select a.table_name, a.column_name from information_schema.columns AS a

join information_schema.views AS v ON a.table_name = v.table_name

where...

From Books Online

Backup Devices

When creating backups, you must select a backup device for the data to be backed up to. Microsoft® SQL Server™ 2000 can back up databases, transaction...

Well, if you update stats, and records continue to pour into the table, the stats are a point in time count. Not a running count.

This thread basically covers it.

Triggers that read values from other tables in the other database.

Thats a tough way to build a system.

I've seen other posts like this, but I don't know that there has...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9okz.asp

The data in the system tables that indicates # of rows is not kept up to date real time, it is only updated when statistics are updated.

So the numbers will...

At this point you need to see if the dts package has the error, or if the .NET code has the error.

Go to Package properties, and set your global variable...

Using your example I do not get an error when I run.

use pubs

create procedure spr_test

@param1 int

as

declare test_cursor cursor for

 select emp_id, fname from employee where emp_id = @param1

--...

Can you run the dts package without error from sql server? not thru .NET?

The error indincates that your trying to log in using sa (Sql server login) but it wants a trusted connection (Check the server properties to see that it is in...

What is the error message?

Can you manually run the sql string in query analyzer?

Try it there, and you should see where the errors are

Do not have code for xirr, but if you can pull it off in t-sql then a sql function would be easiest, and work fine. extended stored procedures must be...