Peter,

Collation is Database default.

The character does exist.

The problem is more as to find out why does even the À is greater than A, as soon as we add another character,...

Speaking of TRS-80, we wrote a baseball game, based on randomized result when you would hit the ball. The only interaction  was with the pitcher, you could trow a curve,...

Maybe Local System Account for MSSQLServer service has not enough rights to go out to the other server...

If you wish to manage the TN log, you can issue on a regular basis the dbcc_shrinkfile (see BOL for syntax) command to shrink the actual data file on the...

Where there an advantage of switching to a Bulk-Logged model instead?

Hi Colin,

LOG PI is not longer available. Company was bought and the product is N/A since then.

Lumigent has a trial offer. I am downloading it now!

Thanks for the info.

Hi Paul,

Is it the database backup that fails or the transaction log (if the TN log is part of the maintenance plan)?

Check if the new DB is on a Simple...

We have currently one database server, with multiple instances, so our consolidation is done for us. Server has 6GB, 4 CPUs and runs fine. Our ERP is on it, along...

There is a limit on what a guy can endure. Too bad for this guy, he will never be happy in life! With that kind of attitude...

Started three years ago as  Our IT Manager needed a Application/DBA type of guy and since I worked previously with Foxpro and MS Access, they thought I could do the...

The Collosus movie is a great one too, but The Matrix is my choice along with 2001, Space Odyssey (Ok not a complete computer geek movie but you can forget...

To answer your question, there is only one log file and you can't switch it. The solution here is to truncate the log file and then shrink the file itself...

Hi Steve,

What? Six inches of snow and schools are shut down? Lucky...Here in Montreal, we used to walk bare foot in 3 feet of snow to get to school!

Following Ramu, once your data is in a table in SQL Server, create an ODBC DSN that connects to the database and in MS Access, when choosing link table, choose...

Our SQL Server here runs multiple instances without any problems. Just bare in mind a good amount of memory and maybe some mem tuning for each of the instance and...