Ken,

I've had the exact same problem when using Visio to diagram a Foxpro 2.6 database.  So frustrating!!!

So yeah, the process doesn't always work with older db's.

Cheers,

Angela

If the default language is US_English and you want to change it to British or whatever, using @@Language would have to be hardcoded into your stored procs everytime.  @@Language only...

wz700,

While not disputing changing @@language may determine language and datetime formats, I have always changed it in Regional Settings so that it is consistent across the server.

Interestingly, upon checking my...

Hi Meto,

Yes. Regional Settings DO affect SQL Server. 

You should always change your Regional Settings before installing SQL Server as SQL Server looks at these...

Create a function, then use this function in your stored proc.

/*This function will evaluate an input string and convert it to title-case format.

it uses the delimchars parameter to determine what...

I like #1 but I don't understand the point of having the cube either, like a lot of other people.

Why not have a database symbol?  That makes more sense to...

David,

There is more than one test required to gain the MCDBA certification.  Your best place to find information about an MCDBA is the Microsoft website.

BTW, Why do you want to...

Fred,

Have you checked what Gary has suggested?  Please tell us what you have found out from the developer in response to Gary's questions.

Angela

How are you importing the file?  Can you please describe the process.  Also, are you using any temp tables in the process?

What do you mean by invisible mode?  You can put your database in single user mode but you won't be able to have users run transactions.

Angela

I have had a simalar problem in the past.  Server1 had default collation of SQL_Latin1_General_CP1_CI_AS and Server2 had a default collation of Latin1_General_CI_AS but the database had the SQL collation. ...

I don't have a solution but the same thing happens to me.  We have Service Pack 3a on all our servers (SQL Server 2000 & W2K) and it's still a problem. ...

Personally, I like the old forum software as well, but I can understand that you've made a commitment to running the site on this new version.

The major things I don't...

Where I was working previously we used Excel for most users, because it's no additional cost if you already run MS Office and it gave users the results they required...

What do you mean by "network access".  Just because you can ping the actual server does not mean you can connect to a database.  You must be granted the rights...