Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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' +...

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

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

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

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

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

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

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

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