Recent content by jrc1

I think I found the problem but need help with a resolution. It appears there are some spaces either before or after the data. I used a trim on empno but it fails on chkdate. Below is a copy of the command: SELECT DISTINCT trim(prhpost.empno), trim(prhpost.chkdate), prhpost.chknumber FROM...

I have one table called table A and another called table B. Table A has the following columns: empno chkdate code org1 org2 etc... Table B is a command with the following columns: Select DISTINCT prpost.empno, prpost.chkdate , prpost.chknum from prpost prpost I have a left outer join linking...

I have a colum with values like "SAL","BRH", "TGL", "BRC", "AGL", etc....(many more) I want to sort in a specific order so I created a formula field shown below where it gives a column a new value (a,b,c) that I will use to sort on. The problem is the "IN" clause is not working. It returns...

I created an alert for sev 014 errors and assigned and operator response to it. The operator is set-up for email, pager and net send notification under the alert. In the operator set-up I provided an email address, pager e-mail name and net send address. I used the test button to test the...

Does anyone have any set procedures for Developers accessing the master db specifically xp_sendmail and xp_cmdshell. For xp_sendmail I created a SP that calls xp_sendmail and granted the Developer access to the SP. Also any thoughts on DTS pkg owners, naming conventions, etc.. Jeff

SQLSister, Thanks for the reply. Do you have any set procedures for Developers accessing the master db specifically xp_sendmail and xp_cmdshell. For xp_sendmail I created a SP that calls xp_sendmail and granted the Developer access to the SP. Also any thoughts on DTS pkg owners, naming...

I am a DBA trying to developer a list of standards/guidelines for our developers to follow. Included on the list is object naming conventions, database security and object privileges. One example is not using sp_ for user created stored procedure (recommend using usp_). Another example would...

We would like to create a copy of an existing datbase and refresh the database once a day(may need more frequent updates at a later date). We want both databases to reside on the same server. The initial thought was to use replication. 1. What other options are available? 2. Is replication...

I'm reconfiguring our maintenance plans. Based on research it seems best to not use the wizard or use the wizard then modify the job to incl. options not available using the wizard. 1. If I use the wizard, can I delete the plan created under "MANAGEMENT" in Enterprise Manager without...

I posted a similar message previously. I am interested to know how other companies handle documenting their servers and the datbases / applications that reside on them. Currently we are looking at documenting our servers/datbases. We were looking at documenting such information as server/db...

Does anyone know if the set-up options/schedules for a datbase maintenance plan(optimization, back-up, integrity, etc) are stored in a table somewhere in the datbase? I want to be able to define a query that pulls maintence plan information. For example I want to query a database and see if...

Does anyone know if the set-up options/schedules for a datbase maintenance plan(optimization, back-up, integrity, etc) are stored in a table somewhere in the datbase? I want to be able to define a query that pulls maintence plan information. For example I want to query a database and see if...

Thanks for the reply. I believe the mentioned script would produce three identical columns with the same values. I don't want to duplicate values. I want the values spread over a numerous columsn and not duplicated.

I am running multiple select statements in Query Analyzer. I would like to wrap the output of ONE of the the queries. For wxample if the table output first names like Jeff John Joe Jim I would like to format the output like Jeff, John, Joe, Jim or Jeff John Joe Jim How can I format...

SQL mail is turned on and configured properly. We are receiving maintenance reports from the same server/database via email on a daily basis.