Search results for query: *

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.

Having an issue, and wrestling match, with BCP import function … and it’s winning. Here is the command I am using. Have already created the output file using BCP without a hitch. ============================================================ Bcp reports..calendar2 in cal_out.txt –Usa –Prpt4m3...

Would like to know if there is a list or doc that describes what each stored procedure that ships w/ SQL7 and/or 2000 does. I have listed all the stored procedures out using sp_helpextendedproc. what i would like is a brief synopsis of what each sp does. Is there a doc on MS site or does someone...

Would like to know where, and if, the number of retries is logged for a job that completes sucessfully. I know when a job fails, and when the job step(s) have been set for "n" amount of reties, these are displayed when you check the "show steps details" for that job. What i...

Need to find a way to discover when tables where dropped and recreated. This procedure of course creamed our data. Would like to know where these transactions are captured and a way to view some type of date_time stamp. Would it be found in the T-logs or someplace else? Thanks Again Thanks for...

Ouch ... folks were trying to recreate a database on a server by scripting out a copy of a database that they wanted to replicate on another server. Of course in scripting out the database, the first options run are to drop tables. Here is were the problem happened. They applied the script to a...