Recent content by JamesJKusch

This may help ... pulled from some old notes I have. This is as expected, starting with SP3 a strong sa password is required for security reasons. You can use the switch SAPWD to go past this error. If you are not using the latest MSDE SP3a i recommend you use that version found in...

What about duplicate words that may be created in TableB. Meaning if one record in TableA has the phrase "Some Like It Hot" and another record has the phrase "Hot Potatoe". Parsing the records from TableA would produce 2 records in TableB with the word "Hot&quot...

Depends on what you are trying to track J. Kusch

As long as procsyst.sql does NOT include the DROP Procedure code, it will not over-write, recreate, the SPs that already reside. J. Kusch

its the period at tbe begining of tbe select statment that is causing the issue ... '.select stmt...'. Remove the initial period and all should be fine. J. Kusch

Morning Shawn, thanks for the post. have your offsite tech add this to your server, or if your feeling a bit brave it is rather easy. he will just cut the above code, enter into Enterprise Manager, choose Tools from the menu then choose Query Analyzer(QA). By default, when QA starts up its def...

Did that work for you situation? J. Kusch

Afternoon, create this procedure in the master DB. that way it can be accessable to all other DBs that may need to have their Tlog file reduced. once the procedure is created, run it out of Query Analyzer against the DB that has the large TLog. should reduce its size quite substantially...

Hey folks, anyone know of a pretty good sql tool like Toad for Oracle's PL/SQL? i have used TOAD on an oracle DB and it was really a solid app. wondering if SQL Server has any type of tool(s) that compares. J. Kusch

Afternoon Folk, Here is the dirt: Have linked tables from Access2K to Oracle8i. built a data entry form to populate tables. i need to have a value that is entered in a text box to populate the associated field in the table as well as another feild in the same table. In otherwords to have 1...

Are you trying to enter the value of NULL? if so, a ctrl-0, control-zero, will place a null in that field if it has been set to accept nulls, even in a bit field. J. Kusch

Try using an "end" after your commit. Thanks for all the help ... As Usual J. Kusch Chameleon Solutions, Inc.

Having an issue. There is a spid in the "Process Info" folder under "Management" in Enterprise Manager, MMC, that is hanging. What i have a question on is under the "Command" header of the "Process Info folder, between "Open Transactions" and...

Morning ... It looks as if you have found where to add the linked server so you are almost there. If not, it is under the Security .. Linked Servers tab of Enterprise Manager. After that right-click on the linked server tab and choose Added ... Choose the SQL Server radio button and check...

Morning. Is there a way to find out when a stored or extended procedure was last run? Thanks Thanks for all the help ... As Usual J. Kusch Chameleon Solutions, Inc.