John McC

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 140 total)

RE: Database owners

This will show you the owner of any databases
select
name, suser_sname(sid) [User]
from
...

August 10, 2006 at 2:16 am

#654216
RE: MS Access & Excel installed on DEV server

But what happens when it's time to move the solution into Production? Unless you allow Access and Excel (and whatever else they end up wanting on the DEV box) onto the...

June 13, 2006 at 3:21 am

#643307
RE: Data Reader and View Creator

The syntax would be:
GRANT CREATE FUNCTION TO <user>

June 1, 2006 at 8:57 am

#641207
RE: Data Reader and View Creator

Using Query Analyser
GRANT CREATE VIEW TO <user>
GRANT SELECT ON <table> TO <user>

May 31, 2006 at 3:50 am

#640855
RE: Seucring MSDE

Deny Builtin/Administrators access

May 16, 2006 at 5:05 am

#638101
RE: Replacing machine name in where clause in SQL 2000

Build a sql string and execute.
DECLARE
@SQLString varchar(1000)
DECLARE @S2 nvarchar(1000)

May 3, 2006 at 4:08 am

#635527

RE: SQLServer 2000 Scheduled Job recurring every second

You might want to search the forum for SQL Server Job Scheduling. I remember someone posting about setting a schdule to run at fractions of a minute (editing a value in...

April 28, 2006 at 3:34 am

#634770

RE: Install of SQL server on Windows XP operating System

You can't. You can only install the client tools or MSDE on XP.

To install an actual server instance you need a "proper" server O/S (Win 2000/2003 server editions)

April 25, 2006 at 4:14 am

#633957

RE: select top 10 * from table Takes long time to run

Since NOLOCK does not apply any locks the time saved is from the Lock acquired, Lock released. It does run the risk of dirty reads if there are any transactions...

April 20, 2006 at 4:17 am

#633207