Forum Replies Created
Viewing 15 posts - 38,266 through 38,280 (of 39,456 total)
-
RE: Trigger Question
This looks good. The only thing is it will not work for multi row updates. Something to keep in mind.
I'll dbl check the syntax and mock something up as I...
-
RE: Index naming Standards
Since I don't work with indexes constantly, I just use _NDX1, NDX2, etc. For clustered I use _IDX. Holdovers from the past.
I tend to tune and then let things alone...
-
RE: passing parm to openquery
You could just build the sql and then do a replace for ' with ''. I think Brian has the best idea.
Steve Jones
-
RE: Error In Query
No idea if Brian's suggestion is wrong. Each column, table, or database can have a different code page/collation sequence.
Steve Jones
-
RE: Trigger Question
This is a really long way to go about this. Can you just post the resulting trigger code?
This looks like the right track. You check for updated() and do the...
-
RE: DBA Learning Experiences (Oops!)
Not sure. I'll get up from my desk and go check. Are you highlighting lines and then doing it?
Steve Jones
-
RE: Delete old baqckups?
Did you check the rights for the SQLAgnet? Log in as this user and see if you can delete the files. Also check the logs for the maintenance plans.
Steve Jones
-
RE: Set NULL as EMPTY
Yes, unless an implicit conversion can be made. Try this:
create table MyTest
( myid int
, MyVal char( 1)
)
go
insert MyTest (MyID) values (1)
insert MyTest (MyVal) values ('A')
go
select * from MyTest
select
MyID
,...
-
RE: Tr. Log File Corrupt (HD fail) detached cant atach
No that I know of. If this is valuble data, I'd call MS and get a case going.
Steve Jones
-
RE: MSSQL 2000. Exam 70-229
Good luck. Come back if you have more questions. No, I wrote the 229 Design book. J Steven Jones.
Steve Jones
Viewing 15 posts - 38,266 through 38,280 (of 39,456 total)