Agreed. To business, "doing it right the first time" may mean, "Get the product out as soon as possible, bugs or not, so long as the public backlash for the...

What error message do you receive?

Yup. My rule was to uninstall all versions of the beta, then install the latest releases whenever one updated. Since RTM, I've made sure to uninstall beta completely, then install...

Seems to me that you can code a generic script which cycles through every recordset and then cycles through every row with every column, it wouldn't be hard at all......

This works because the sysadmin maps into a database as dbo. Another technique is the one described using sp_addalias, a holdover from SQL Server 6.5 (and considered deprecated... it also...

The alias isn't necessary. Being a member of db_ddladmin is sufficient. However, as dcpeterson pointed out, when they do the CREATE or ALTER, they are going to have to specify...

You can install with less than 512 MB of RAM. I have it installed on a Windows 2000 Pro machine with only 256 MB.

What issues were you having with...

You can transfer a particular schema to dbo by the following:

ALTER AUTHORIZATION ON SCHEMA::<schema name> TO dbo

If the 'user' is already a user in the database, you can't make it the owner. In this case you'll need to remove the user, either through sp_revokedbaccess (old method)...

I don't know much about connecting up FoxPro, but came across this in a search. Don't know if it is helpful to you but here it is:

January 20, 2006 at 3:10 pm

#616234

I wrote an article on stored procedure recompilation:

Stored Procedures and Caching

Microsoft's article on how to troubleshoot blocking problems:

INF: Understanding and Resolving SQL Server 7.0 or...

Take a look at the ::fn_get_sql() system function. You'll probably need to couple that with a cursor but that'll tell you the SQL statments which are executing.

If it's to the same server, the SIDs should match up between the logins at the server level and the users at the database level. If that's not the case,...

I'm going to piggy-back on what David has already written just to try and give an analogy that may help in visualizing the different levels of access.

Think of SQL...

Yes. Each SQL Server instance runs a separate sqlservr process which can be viewed with a tool like Perfmon or Process Explorer (from SysInternals). The catch with Perfmon is it'll...