The following URL contains a comparison of PostgreSQL 8.4, Microsoft SQL Server 2008 & MySQL 5.1:

http://www.postgresonline.com/journal/archives/130-Cross-Compare-of-PostgreSQL-8.4,-SQL-Server-2008,-MySQL-5.1.html

Phil Parkin (6/12/2011)

---

I'd like to see that. Please provide details of how the FST can...

Steve Hindle-535638 (6/7/2011)

---

If a user is a member of the dbo database role, in what circumstances might they need any other database role memebrship?

The reason I ask this is I...

Have you considered consolidating the PaymentItemD_zAgro,PaymentItemD_zBiz & PaymentItemD_zKWSP Tables into one table and store the payment type value 'agro', 'business' & 'kwsp' in this column?

One thing that I noticied was that you may want to consider a UserType Table as opposed to UserTypeA and UserTypeB tables and separate columns?

I assume that you have a...

You should post your connection strings as requested.

Not sure of the details but ...

http://blogs.msdn.com/b/spike/archive/2008/11/07/sql-server-error-10060-sql-server-error-10061.aspx

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/27684811-1a59-4273-b7ed-3cc990b4f20a

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70972

You should try and avoid assigning the number based on a value on a table and use the identity if possible.

If you go with the update table methodology you need...

What does your ad have to do with this thread?

PostgreSQL is an Open Source Database.

I converted a Database from PostgreSQL to SQL Server several years ago.

I can't speculate on it's future but if you can afford a license my...

Tiya (6/3/2011)

---

Sorry forgot to attach error message on sql 2005

Msg 4832, Level 16, State 1, Line 2

Bulk load: An unexpected end of file was encountered in the data file.

Msg 7399,...

irena.bulatovic (5/30/2011)

---

File was on the same machine as sql server and if I put scrip into vbs file on the server it works fine but from job on the same...

Two articles on setting regional settings:

http://support.microsoft.com/kb/273558

http://stackoverflow.com/questions/211549/how-to-change-system-default-regional-settings-in-windows-xp

😉

Uing @@ERROR usually requires a GOTO and/or lots of IF statements.

Try ... Catch makes the code easier to maintain.

As far as nested Try Catch an example of a Grandparent, Parent...

You may want to post this question in the SSIS Forum as was suggested in your other forum:

http://www.sqlservercentral.com/Forums/Topic1116550-391-1.aspx

Try not using the NOT Operator as in AND LOWER(s.Model) NOT LIKE ('%express%')in the Discovery.dbo.sysSoftware Table or any other table.

That will force a table scan.