K. Brian Kelley

Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 6,104 total)

RE: Another Bug Hunt

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...
K. Brian Kelley
@kbriankelley

January 24, 2006 at 7:22 am

#616657
RE: Job Fails when owned by user account

What error message do you receive?
K. Brian Kelley
@kbriankelley

January 24, 2006 at 7:20 am

#616655
RE: Using SQL Server 2000 with visual Studio 2005

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...
K. Brian Kelley
@kbriankelley

January 23, 2006 at 1:41 pm

#616531
RE: we''''ve seen the (comprehensive html server information) script... tough to edit.

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......
K. Brian Kelley
@kbriankelley

January 23, 2006 at 1:27 pm

#616528
RE: Altering Table/Creating table changes dbo

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...
K. Brian Kelley
@kbriankelley

January 23, 2006 at 1:24 pm

#616527
RE: Altering Table/Creating table changes dbo

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...
K. Brian Kelley
@kbriankelley

January 23, 2006 at 1:20 pm

#616525
RE: Using SQL Server 2000 with visual Studio 2005

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...
K. Brian Kelley
@kbriankelley

January 21, 2006 at 11:32 am

#616274
RE: change database owner

You can transfer a particular schema to dbo by the following:
ALTER AUTHORIZATION ON SCHEMA::<schema name> TO dbo
K. Brian Kelley
@kbriankelley

January 20, 2006 at 9:02 pm

#616260
RE: change database owner

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)...
K. Brian Kelley
@kbriankelley

January 20, 2006 at 8:32 pm

#616258
RE: Ad Hoc Access Denied

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:
K. Brian Kelley
@kbriankelley

January 20, 2006 at 3:10 pm

#616234

RE: Locking Issues

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...

K. Brian Kelley
@kbriankelley

January 20, 2006 at 2:53 pm

#616231

RE: Can you determine which SPID is waiting on OPENQUERY?

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.

K. Brian Kelley
@kbriankelley

January 20, 2006 at 2:48 pm

#616229

RE: SQL Account Error: maybe undocumented

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,...

K. Brian Kelley
@kbriankelley

January 20, 2006 at 2:45 pm

#616228

RE: sp_addrolemember, sp_grantlogin, sp_grantdbaccess

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...

K. Brian Kelley
@kbriankelley

January 20, 2006 at 7:21 am

#616064

RE: Sql Resource usage

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...

K. Brian Kelley
@kbriankelley

January 19, 2006 at 8:11 pm

#615977

Viewing 15 posts - 2,326 through 2,340 (of 6,104 total)