Hello,

Possibly easies to start off with the Import Wizard to create the SSIS package, afterwards you can customise it as you wish.

The Wizard gives you the chance to both,...

Hello,

Which version of SQL Express do you have? Does it include the "Database Copy Wizard"?

According to the following article, it is definitely included in SP2: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm

Regards,

John Marsh

Hello,

You can create a custom DB Role. Grant Execute permission to this Role for all the required SPs. Remove all other Role memberships and unwanted permissions for the users. You...

Hello,

Try: Convert(Char(8), GetDate(), 112)

Is that is the output that you need?

Regards,

John Marsh

Hello Phil,

What data-types are the CRef column and @CRef variable?

My example would only work for character data-types e.g. it won’t work if zeros are being passed in.

Regards,

John

Hello,

There are tools such as Redgate's Data Compare that generate SQL Scripts for data transfer.

Regards,

John Marsh

Hello,

May be best then to script the table as well, create it in the target server and just use DTSWizard to transfer the data.

Regards,

John Marsh

Possibly from: http://msdn.microsoft.com/en-gb/express/bb410792.aspx

Hello,

Have you tried DTSWizrad.exe? I believe it is included with Express. It is the Import/Export Wizard.

Regards,

John Marsh

Hello,

In theory your SP should work. It depends what is being passed in when no parameter value is supplied e.g. if it is a Null or a string of spaces...

Hello,

Do you have DTSWizrad.exe on your machine? If so you can use that to transfer the table and data. You can then script the triggers and indexes from the original...

Hello,

This link will give you a better idea of what is contained in each BizTalk DB: http://msdn.microsoft.com/en-us/library/aa561125.aspx

Regards,

John Marsh

Hello Steve,

In SQL 2005, as well as the Grant/Deny option you also have the Enable/Disable option, which is probably what you did?

Having the BUILTIN\Administrators Login set as disabled won’t override...

Hello,

I'm not exactly sure what your question is, but the BizTalk DBs (e.g. BizTalkMsgBoxDb) are used internally by Microsoft's BizTalk Server. For example, to store messages that are being processed.

Regards,

John...

Hello Steve,

If you are a member of the local Administrators group on the Windows Server, then you are in it.

Regards,

John Marsh