OK - Your answer didn't really address my question.

SQL Management Studio will save server registrations and show you job statuses.

If you want something outside of SQL Server then take a...

There no performance difference between the two.

CURRENT_TIMESTAMP is the ANSI SQL equivalent to GETDATE().

There's post discussing this which you may find useful.

http://www.sqlservercentral.com/Forums/Topic991342-373-1.aspx

Do a search for the DBMAIL and HMTL on the Microsoft MSDN site or BOL. There are some helpful examples that should point you in the right direction.

Are you passing any parameters from the .NET application to the DTS package?

If not then I suspect the issue is at the SQL Server.

If you are passing a parameter from...

Can I ask why you don't / want to register servers?

How will you access the data regarding the job without registering the servers?

Lynn Pettis (4/26/2012)

The bottom line is this, you can't use dynamic sql in a function. Your choices are...

Just g=Google SQL Azure tutorial.

Lots of links returned!

There is no defined list of scenario questions that I'm aware of.

From personal experience SQL Developers are not just "pure developers" as the features within SQL grow. I'd expect you'd...

I'm a bit confused from your question about the direction of data.

However, it seems to me that SSIS would be a good starting point - it can handle the import...

Hi there,

My initial question would be why do you need to break the table up? 45 columns is well within the limits of SQL Server 2008.

My recommendation would be to...

Ok, yes Jeff you have a point but at least its a starting point.:hehe:

That's really interesting Jeff. Years ago I went on a MCP course for SQL 2000. The instructor recommended 50% (!!!!) growth as a blanket strategy.

His reasoning was that few...

I'm sure you can Google that!

Hopefully you'll realise it's on a case-by-case basis with many different factors contributing to your strategy on how / when to grow a database.

Here's...

In SQL Management Studio, right click on the database, click Tasks and then Generate scripts.

Depending on the complexity of your database, generate scripts for tables, views and UDF's first, stored...

Take a look at the following link:

http://msdn.microsoft.com/en-us/library/ms175527.aspx