pervasive SQL V8 vs SQL server 2000

My company is trying to determine if they need to upgrade from our current Platinum accounting application that uses pervasive SQL V8 to another version of Platinum that uses SQL server 2000.

My manager wants a in-depth analysis comparing pervasive SQL V8 to SQL server 2000.

I have searched the web extensively but information is scarce.

Are there any articles or case studies that do an indepth analysis comparing both databases? Can someone please help me. It would be greatly appreciated.please don't cross-post

if you do not wish your thread to be in the pervasive forum, let me know if you wish it to be moved to the sql server (or any other) forum|||Here's a white paper that talks about cost of ownership of PSQL:
http://www.pervasive.com/download_Check.asp?download=/documentation/whitepapers/pdf/Aberdeen_v8.pdf
You're probably not going to find too many "in depth analysis" comparing the two databases because for the most part they don't occupy the same market.
Pervasive is marketed more for mid sized businesses where SQL Server is marketed toward the enterprise. That doesn't mean that PSQL can't hold it's own in the enterprise. I've seen PSQL running in an environment where there were 1500 + concurrent users hitting the database. I know that some very large companies use PSQL. For example, Fry's electronics uses PSQL for it's Point of Sale system. Here's a link with a "Wall of Fame" for PSQL references.
http://www.pervasive.com/lp/walloffame2/?referer=/psql/index.asp?promo=

Personalize Report

Hi all, I was wondering if there is a way to capture the current users windows login and use that to personalize as report by displaying the users name at the top...or customizing report output by using the windows login as a query or report parameter.

This is very simple with Visual Studio 2005.

If you only have SQL 2005, on the edit expression screen use Globals -> UserID.

|||

Yes, it is easy to do... You can create a report parameter to capture the user id by using

=User!UserID

This will return you the credentials of the user who is trying to run the report which you can use anywhere in the report.

sql

Permissions for BULK INSERT?

I'm trying to do a BULK INSERT into a SQL Server 2005 db from an aspx page. When I try to run the page, to insert into [myTable], I get:

The current user is not the database or object owner of table 'myTable'. Cannot perform SET operation.

But here's the kicker: if I use Server Management Studio to log into the same database, using the same credentials, and run the same query, it works fine.

My connection string looks like this:

connectionString="data source=myLocalMachine; initial catalog=myCatalog; user=joe; password=joe;" providerName="System.Data.SqlClient"

Can anybody tell me why it works when I log in via SMS, but not when I try the same query from my aspx? I'm totally stuck.

Thanks!I am no SQL Server 2005 expert, but as far as I am aware, running BULK INSERT from Server Management Studio will be using different user credentials than running the process from your ASP.NET page. As far as I understand it, user joe needs to have BulkAdminprivileges. Or, you need to termporarily impersonate an account whichhas those privileges.

Reading the documentation onBULK INSERT may help, as well asPermissions of Fixed Server Roles.