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. hmckillop

    Exporting specific data from DB into another DB

    Hello, I have been tasked with "migrating" data from one Oracle DB to another Oracle DB of same schema. This DB is used as a multi-tenant seperated by a logical column (e.g. Organisation ID). I am now being asked to move data from this DB into another DB in a different location - as such I...
  2. hmckillop

    Access to specific tables

    In SQL Enterprise Manager, you can add new users and only give them read only permission. There are plenty of articles on the web to do this, and you can do anything from permit read only access to these tables (alternatively create a new role which only has read only access to these tables and...
  3. hmckillop

    C# Console app quick quiz

    Hello, I was recently asked this question, and just wanted to pose this to the forum to see what people think is the best solution - post your answers and we can judge on performance, elegance and coding skill. Thanks PS - when complete I will post my answer (which isnt the most elegant)...
  4. hmckillop

    Bi-directional Replication Confllct

    Hello, In SQL 2008, you can enable conflict detection across a peer to peer topology. This option helps prevent the issues that are caused from undetected conflicts, including inconsistent application behavior and lost updates. By enabling this option, by default a conflicting change is treated...
  5. hmckillop

    How to create MS SQL2005 job/stored Procedure to copy files across

    Hello yes I can help 100% - dont do this as a SQL job or stored proc. This is scheduling/operating system job. You could do this in many ways, e.g. create a batch file [code] COPY \\sourcemachine\myshare\files.* \\targetmachine\targetfolder\ [schedulefile.bat] [\code] Then create a windows...
  6. hmckillop

    SQL vbs backup script not working

    A couple of things not sure will help- is "Connection" not a reserved word? eg. replace connection with dbConn or something else As a one off replace your Connection.Open Server(t) with Connection.open "Server(0) = "DRIVER={SQL Server};Server=SERVER;Database=master;uid=SQLBackup;pwd=PASSWORD"...
  7. hmckillop

    Can I send direct to another inbox?

    What you are talking about is not emailing but a messaging service. You have to remember what Outlook express is, its a client tool to access a remote mailbox. The mailbox is on a server which the mail is delivered to and from. If you want to write a personal messaging service there are many...
  8. hmckillop

    Incorrect Syntax Creating Stored Proc

    I think you need an END for the procedure BEGIN so USE [My_DB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_TC_MyProc] @MemberID varchar(10), @MemberOption varchar(50) AS BEGIN SET NOCOUNT ON; IF @MemberOption = 'ACT' INSERT...
  9. hmckillop

    SQL Server Certifications

    Apologies I misread. To go from MCDBA to MCTS on SQL Server you need 70-431. Then to go from MCDBA with MCTS on Sql Server to MCITP Database Administrator you need 70-447. Shouldnt be a problem to someone who already is a MCDBA. Good luck "I'm living so far beyond my income that we may...
  10. hmckillop

    SQL Server Certifications

    yes its just the 70-447. Have a look at http://www.microsoft.com/learning/en/us/certification/mcdba.aspx#tab3 under the upgrade path from MCDBA "I'm living so far beyond my income that we may almost be said to be living apart
  11. hmckillop

    Database Mirroring

    no worries "I'm living so far beyond my income that we may almost be said to be living apart
  12. hmckillop

    String to date

    I think there has got to be a simplier way, but anyway this works declare @v_string varchar(6) select @v_string = '081309' select CAST(substring(Right('000000' + convert(varchar(6),@v_string),6),1,2)+'/'+substring(Right('000000' +...
  13. hmckillop

    SQL Slow in the morning

    Is this a .NET WCF application which you use to access SQL Server? Or is this through Query Analyser running SQL ? If its the first, there is a known problem with startup with this, it can take anywhere between 15 and 30 seconds to startup. If its the latter then I would look at the machine...
  14. hmckillop

    Inserts twice

    Only things I can think of are - can you provide the DB using SQL profiler to see when your application runs - this will check is the application code calling the procedure twice. - you should also be able to check the table keywordstable to see if any triggers exist The code in itself is fine...
  15. hmckillop

    Database Mirroring

    As you have SQL 2005 standard (or enterprise) you get mirroring. You need to check your DB is in full recovery mode Sorry to state the obvious but have you After connecting to the principal server instance, in Object Explorer, click the server name to expand the server tree. Expand...
  16. hmckillop

    SQL Server Configuration

    Have you had a look at SQL replication - it will do exactly what you need and you can even use SSL to encrypt the data . I have recently completed this and you can do it over a LAN or internet, it will synch as you request e.g. 30 mins, encrypted etc. There are many articles on the web but I...
  17. hmckillop

    Database Mirroring

    Have a look at this http://technet.microsoft.com/en-us/library/cc917680.aspx it should give you all the info you need. "I'm living so far beyond my income that we may almost be said to be living apart
  18. hmckillop

    Best "update" strategy?

    One other point, if you have a look at the "batch" faq, it will give you another way to process the second version of your update but with more visibility on how well its running. http://www.tek-tips.com/faqs.cfm?fid=3141 "I'm living so far beyond my income that we may almost be said to be...
  19. hmckillop

    1004 Application or Object Defined Error

    a couple of pointers, - try debug.print on the strFormula and see if the formula can be paste into the cell - try assigning a simple formula e.g. "=sum(1,2)" - this will point to the syntax of build of the statement being the problem Without having all the reference data its hard to test...
  20. hmckillop

    Error - The FOR XML clause is invalid in views, inline functions...

    try this DECLARE @StrXML NVARCHAR(MAX) SELECT @StrXML = ( SELECT * from ( SELECT 'This' as col1, 'is' as col2, 'a' as col3, 'test 1' as col4 UNION SELECT 'This' as col1, 'is' as col2, 'a' as col3, 'test 2' as col4 ) y FOR XML PATH('Test'), ELEMENTS...

Part and Inventory Search

Back
Top