Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. osjohnm

    Replication Reference Guide - Best Book to Buy?

    I realise that this will be a very subjective topic but I'm thinking of changing jobs and my potential new employers make extensive use of replication. Been working as a DBA for 5yrs and have never needed to use replication. Only read whats in BOL and MCP exam topics. Looking for a...
  2. osjohnm

    2005 Linked Server - Erratic Query Results

    Hi all Quick background, clientsite was using SQL2000 and we had a DTS package which imported data from DB2/AS400 and then updated data in SQL2000. Something went haywire on server and can no longer access package. Clients solution is to upgrade to 2005 within 2 weeks. Clients didn't install...
  3. osjohnm

    JDE/AS400 Linked Server

    Hi all Been awhile since I've been here. On one of our client sites we are DTSing data to and from JDE running on AS400. The package works fine when executed manually but every now and then the job fails. It seems as if the clients have messed up their sql server instances as the only way to...
  4. osjohnm

    DIFFERENT DESTINATION SETS AT DIFFERENT TIMES?

    Hi all I'm struggling with scheduling of destination sets. Our ISA Server was configured by an external company. They do the tricky stuff and we do the daily tasks. There is currently one Deny Destination set which is on all the time. I need to have the current set only avtive between 17:30...
  5. osjohnm

    How to SAVE/COPY DB to a CD Rom

    Another thing to note is that you should run sp_change_users_login for the database like so: exec sp_change_users_login 'report' this will return a list of users in your database that don't matchup to a login on the new server. you might have to first create the missing login(s) on the...
  6. osjohnm

    START SERVICES ON AD WIN2K3 SERVER?

    Hi All THe server is running as DC(actually BDC) on W2K3 with SQL Server 2000. A domain user account was created to run the sql services but once the user and pwd have been entered and the service has been stopped, if you try and start the service we get an Access Is Denied error. Eventually...
  7. osjohnm

    PERMISSIONS TO START SQL SERVICES ON AD MACHINE

    Hi all The server is a BDC (as it was called in the good old days) running AD on w2k3.SQL Server 2000 is also running on this machine. A domain user account was created to run these SQL Server services. I add the accounts under services and grant log on as a service etc. I then stop the service...
  8. osjohnm

    cool source of sql scripts

    well here is my 20c worth..... >>"but you never need to use a cursor in sql server". I have to disagree with your statement and agree with James and stravis. You can't generalise like that. If you never need to use cursors then why did Microsoft include it in SQL Server? Thats like...
  9. osjohnm

    Transaction Error

    Hi This link is more appropriate I think. http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 John
  10. osjohnm

    Transaction Error

    Hi You can try using XACT_ABORT in your procedure an set its value to ON. SET XACT_ABORT ON ..... Have a look at the following article at Microsoft's support site. http://support.microsoft.com/default.aspx?scid=kb;en-us;329332 Hope this helps John
  11. osjohnm

    Prefix: sp, sp_, or not...

    Hi Here is the link to the article: http://www.sql-server-performance.com/stored_procedures.asp John
  12. osjohnm

    Prefix: sp, sp_, or not...

    Hi If you use the sp_ as a prefix for procedures and you execute the procedure in one of your user databases, SQL Server will first attempt to find the procedure in the master database and then the user database. THis would affect performance but you wouldn't even notice it. I don't remember...
  13. osjohnm

    SQL 2K ON SAME BOX AS AD2k/2k3, PROS & CONS?

    Hi all I'm trying to determine what the pros and cons of having sql installed on the same machine as AD are. The server will actuall be the BDC(as it used to be called before AD came along),which will be the new dataserver of our company. Any assistance will be appreciated. Thanks John
  14. osjohnm

    Using Order by / Group by?

    Hi Try this: select id, name, seq from (your tablename) order by id, seq John
  15. osjohnm

    Access Table A in DB1 from DB2

    Hi You need to use the fully qualified name which consists of: DATABASE.OWNER.TABLE eg. select * from DB2.dbo.USER Since want a view you can right click on Views in DB1 in Enterprise Manager > New View and you can build your query there and save it as User. Alternatively you can use query...
  16. osjohnm

    Session Problems

    Hi all I'm actually a DBA but our entire team is researching our problem. We use SQL 2000, ASP, W2K Server, IIS 5.0 and COM+. We have an issue with our application where the objects are being "stolen" between sessions/processes. Eg. In one session your logon info is domain\john and...
  17. osjohnm

    Session Problems

    Hi all I'm actually a DBA but our entire team is researching our problem. We use SQL 2000, ASP, W2K Server, IIS 5.0 and COM+. We have an issue with our application where the objects are being "stolen" between sessions/processes. Eg. In one session your logon info is domain\john and...
  18. osjohnm

    Reducing size of Log File

    Hi I'm guessing that you are running SQL 2000 and that your database uses the FULL recovery model and that you don't backup your database frequently? By default the FULL recovery model is used in SQL 2k unless SIMPLE or BULK-LOGGED are specified. Using FULL is the best as it writes every...
  19. osjohnm

    Decrypt Stored Procedures

    Hi You can DECRYPT stored procedures. Create the following procedure and then execute it by passing in the ENCRYPTED procedure's name. create PROCEDURE sp_decrypt_sp (@objectName varchar(50)) AS DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3...
  20. osjohnm

    Create File In Procedure without XP_CMDSHELL?

    Hi all Would have use the keyword search but it is still down. Is there away to generate a txt file from within a stored procedure without using xp_cmdshell? Currently we use xp_cmdshell dtsrun, this is being called within about 20 procedures. We are executing it manually on an adhoc basis...

Part and Inventory Search

Back
Top