Forum Replies Created
Viewing 15 posts - 38,566 through 38,580 (of 39,754 total)
-
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
-
RE: Inserting Date Problem
When you setup a user, do they not get British English as the default? Or is it always English?
Steve Jones
-
RE: ISQL script for Creating user, database and tables
what is your script like?
I would use isql, which is what the SQL Setup uses. In this you can specify the user to connect with using the -U option. I...
Viewing 15 posts - 38,566 through 38,580 (of 39,754 total)