Forum Replies Created
Viewing 15 posts - 38,281 through 38,295 (of 39,466 total)
-
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...
-
RE: Identity conflict
Keep in mind that I do not think this will handle indentity conflicts. If you allow updates to the subscriber and it takes an identity value already in use in...
-
RE: Set NULL as EMPTY
Yes, you would select isnull( column_name, '') replacing column_name iwth the appropriate column. Replace '' with whatever value you want returned ('NULL', 0, etc.).
Steve Jones
-
RE: what is the code page of current 6.5 db
Try running setup on the original SQL Server. It has options for rebuilding master, reinstalling, change network support, and code page. You should get the existing setttings from there.
Steve Jones
Viewing 15 posts - 38,281 through 38,295 (of 39,466 total)