Forum Replies Created
Viewing 15 posts - 37,066 through 37,080 (of 39,520 total)
-
RE: SP Security Administration
You will save headaches as Brian mentioned. ALWAYS use roles and groups. NEVER assign individual users.
Steve Jones
-
RE: Programming to run like Profiler?
What do you mean? Run profiler programmatically? This can be done. There are stored procedures to run server side traces.
Steve Jones
-
RE: Putting 7.0 db files into 2000
I believe you can restore or attach a SQL 7 database, but you'd have to try. Can't hurt.
You do not need to run "sp_change..." unless you need the users. You...
-
RE: Recover Database marked as Suspect?
Thanks for answering
Steve Jones
-
RE: Stored Proc Question
search google with "decrypt stored procedure"
Steve Jones
-
RE: INSERT taking long to execute
Are these a single transaction?
Check the log and data phyiscal location, you may have a hardware issue.
Are you sure this is hte only index?
Steve Jones
-
RE: select statement to get max year
max should give you the max date. Are these character values?
you can do max(datepart(year, value))
Steve Jones
-
RE: SP Security Administration
You will need to assign the execute right, but you can create your own role to do this and assign the users to the role. It can be a user...
-
RE: Object ID in which Database?
This is a page id from the pages stored in the db. You can get the objectid from each database and query each table (Select *). One should give you...
-
RE: 4.2 to 6.5 Conversion
Not sure about this one.
Steve Jones
-
RE: 4.2 to 6.5 Conversion
bcp out, bcp in. Backups are not compatible.
Steve Jones
-
RE: Object ID in which Database?
search sysobjects in each database.
Steve Jones
-
RE: TRIGGER HELP!
use if
create trigger
as
if (select status from inserted) = 'Complete'
update table
set completedate = getdate()
from inserted
where table.pk =...
-
RE: Maintenance Plan Failure
Is there any history in the jobs? As Andy said, check that they are not running.
Steve Jones
-
RE: "DERIVEDTBL" ?
I saw this today in Access as well for a subquery.
Don't "build" queries. Write them.
Steve Jones
Viewing 15 posts - 37,066 through 37,080 (of 39,520 total)