Forum Replies Created
Viewing 15 posts - 37,366 through 37,380 (of 39,818 total)
-
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
-
RE: Microsoft - Love 'em or Hate 'em?
They are. I think the message is out that security and stability are more important than features. Notice .NEt server went RC1 the other day. Was supposed to be gold...
-
RE: Cleaning Bad Database Design
I tend to do this on an ongoing basis. To revisit an entire design is not usually practical or possible given uptime needs.
In my last job, we would contstantly identidy...
Viewing 15 posts - 37,366 through 37,380 (of 39,818 total)