But maybe it is more easy to use a backup-restore procedure to create and fill a database.

Can you clearify why you want/need to script it?

For my knowledge there is no complete scripting available for what you want to do.

You can easily generate a script to create your tables and even the database (right click...

You can also create a backup of the current database and restore this backup on the new server and with the new database name. The advantage is that you can...

maybe some of these links will provide you enough information to create what you want:

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/2691/

http://www.sqlservercentral.com/Forums/Topic442795-8-1.aspx

http://www.sqlservercentral.com/Forums/Topic517308-338-1.aspx

To return the value of a SP use this:

CREATE PROCEDURE dbo.Dummy

@Dummy int

@Output varchar(50) output

AS

...

CREATE PROCEDURE dbo.Dummy

@Dummy as int

AS

SELECT *...

For my understanding...

According to the connection string, the application connect to SQL using integrated security. That means the Windows-logins of the user is forwarded...

ezekielen (7/17/2008)

---

Take care with the DTS. Try to test them in 2005 environment.

To edit DTS in SQL SERVER 2005 you need a microsoft tool named: SQLServer2005_DTS.msi , is available...

When your solution works as required, there is no need to change it. If you want to get rid of the scheduled task: in your scenario SSIS has to be...

I'm sorry, but I don't have the time to provide a answer/sample.

I can give you a hint though: probably you can use the COUNT to see how many scores are...

Can you tell which of the indexes (which index_id) are missing?

I am also very curious about how other think about this.

Recently a company asked my advice on this. After consulting some of my collegues, we decided to follow Microsoft's statement...

Microsoft has a website for troubleshooting Database Mail

http://msdn.microsoft.com/nl-nl/library/ms188663(en-us).aspx

No, Database Mail is not available in SQL Server 2005 Express Edition.