If you are going to connect to Informix from SQL Server you need an ODBC driver to connect to it.  Data Direct has some drivers (www.datadirect.com/products/odbc) but you probably...

This might be the opportunity you need to set up different users and passwords for the projects instead of using the standard System Administrator login which no one should have...

If you are renaming them (a real pain), underscores (_) will also work as a replacement for dashes with no problems.  I've used both 'CamelBack' and underscores and I think...

I am having the same problem.  I just downloaded Management Studio Express today and registered both the Sql Server Express Edition that came with my Visual Studio .Net 2003 and...

If you backup the log WITH NO_TRUNCATE you will not free up any space which doesn't address the initial problem Mark had of running out of space.  I've seen transaction...

If you do backup the transaction log with truncate_only and shrink the log file, this would be a good time to do a full backup of the database.  Since the...

Just curious, what kind of job needs to be run every 10 seconds?

Steve

Here's a sample of one I use from vb6:

gsSql = "EXEC sp_password '" + txtPassword.Text + "', '" + txtPWNew.Text + "', '" + txtUser.Text + "'"

gconGIMS.Execute gsSql

straight SQL:

EXEC sp_password 'old-password',...

Just a quick tip that may help to get all those column names easily and without typos; when working in query analyzer you can get a complete list of the field...

Another idea that might work for you is:

ORDER BY companyId, isnumeric(locationCode), len(locationCode), locationCode

Steve 

I'm confused.  If you are equating "SA-rights" as a Login that has been given the server role System Adminstrator (SysAdmin), this can only be given to Logins (individual or NT...

What is your business need for trying to install a 7.0 DB?  I would guess that you can't because, from what I've heard, to install a database on the same...

There is no autonumber field type but there are types of fields that can be given the Identity property that will automatically be incremented when a row is inserted.  See...

I'd also look into bringing over the Logins.  They are stored in the Master Database.  I don't think you would be able to restore or attach the old Master DB...

Maybe you want to use IDENT_CURRENT to get the last identity value generated for a specific table.  From BOL

• IDENT_CURRENT returns the last identity value generated for a specific table...