vote for #1

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I'd stick with one data file. Simpler is usually better.

As far as Netware, no chance. If anything, I'd like to see SQL Server on Linux, but after talking with developers...

No, best advice is to script things and run it against both databases. Similar to what I did here:

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Thanks for the commments and glad to see there is interest.

We hadn't planned on a CD due to cost, but we can work on that. Most likely we'll have downloads...

Lots of questions. On the simple recovery ?, it limits the restore ability. You can only restore up to the last full or full + diff backup. Not recommended...

Shouldn't be that much different, but keep in mind you want to pre-allocate the sql space, so you might make it larger for that reason.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

ER/Studio does, I believe.

alternative, setup a local server, make the changes to that and then script them. run the script using Windows Auth.Kludgy, but secure.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

the SPID is what you need, but you may need to store this along with some other identifier of the individual.

We used to do something similar in that we would...

Are you loading from the same server in both cases? Perhaps the server side package is not accessing the same package. Are you hard coding the server name? Is it...

Did you install Windows SP3? I think this happened to us recently. I didn't work the case, but I know that we had to call PSS and work with them...

Boy it's been a long time since I did any Visual Studio integration with SQL Server. As far as I remember, it was only for stored procedures.

Other than that, there...

Intersting script. Not sure I'd do it that way, but it's a great solution.

2nd vote also for explicit conversions. Better to do it yourself and be sure you don't get...

That isn't quite clear. Can you be a little more specific in what you are looking for? Is this in insert statement you need help with or a select?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

You may have virtual log segments that are not empty and preventing the shrinking. Use this script to help:

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Wow, someone agrees with me!

Use some secure protocols if you need them, definitely the stuff accepted in the industry is the best choice. Just be aware of...