Forum Replies Created

Viewing 15 posts - 6,406 through 6,420 (of 13,460 total)

  • RE: I have a coworker....

    my issue with it is that no matter how long you wait between the clicks to "add 30 seconds", 30 seconds + 30 seconds = 60 seconds....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2011 at 10:32 am

    #1408061

  • RE: Oracle data to Sql server

    if you watch the first video, it does a quick demo showing how the schema is migrated, and then how data requires a seperate click/call, so you'll get your...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2011 at 6:01 am

    #1407792

  • RE: Migrating oracledata to sql server

    duplicate thread:

    follow it all here where the detailed answers exist:

    http://www.sqlservercentral.com/Forums/Topic1205779-146-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2011 at 6:00 am

    #1407786

  • RE: Migrating oracledata to sql server

    duplicate thread:

    follow it all here where the detailed answers exist:

    http://www.sqlservercentral.com/Forums/Topic1205779-146-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2011 at 5:59 am

    #1407784

  • RE: Oracle data to Sql server

    rocky@123 (11/15/2011)

    could anyone provide the step by step process for migrating the oracle data(only specific objects) to Sql Server using SSMA tool..

    Thanks

    looks like there is a series of videos here...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 15, 2011 at 5:55 am

    #1407780

  • RE: Cannot Restore Service Master Key

    the code you posted points to two different folders; 'C:\SQLServerFiles\serviceMasterKey'

    and 'C:\SQLServerFiles\TDE\serviceMasterKey'

    could that have been the issue? the extra folder?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 5:58 pm

    #1407589

  • RE: Datdiff of hh,mm.mi

    something like this?

    select [Years] = datediff(year,0,ET-ST)-1,

    [Months] =...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 1:59 pm

    #1407521

  • RE: Alert Based on Query Result

    not sure about an Alert, but certainly from a scheduled job; i simply use IF EXISTS...sp_send_dbmail

    i use this a lot actually, here's a rough example:

    IF EXISTS(SELECT *

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 1:19 pm

    #1407499

  • RE: Help with a Select against sys.databases

    for reference, this DDL trigger worked for me;

    ALTER TRIGGER [Create_Database_Trigger]

    ON ALL Server

    WITH EXECUTE AS 'sa'

    FOR Create_Database -- Captures a Create Database Event

    AS

    DECLARE

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 10:09 am

    #1407377

  • RE: Help with a Select against sys.databases

    somewhere in there you need something like this: that was a partial from my own version of a DDL trigger:

    DECLARE @msg XML

    SET @msg = EVENTDATA()

    --replace also msg. with @msg.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 9:56 am

    #1407358

  • RE: Help with a Select against sys.databases

    GilaMonster (11/14/2011)

    Err, no. Look at the EventData function that's available in DDL triggers. From that you can extract the actual command run, who ran it, from where, etc, etc, no...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 9:21 am

    #1407300

  • RE: Unable to connect using sql server name but connects thru ip address

    sounds like a networking issue with the WINS(Windows Internet Name Service)

    are you on a network with a primary domain controller providing that service, or just happen to be on a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 8:53 am

    #1407242

  • RE: CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

    PaulB-TheOneAndOnly (11/14/2011)

    About tools... yes!... Brain 1.0 has been very useful 🙂

    kewl! where can i download that?! 😀

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 14, 2011 at 6:09 am

    #1407107

  • RE: CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

    shubham.saxena67 (11/12/2011)

    Dear Friends,

    I want to convert stored procedure that containing Loops ,Table valued

    functions,Scalar Function written in Oracle to SQL Procedure and functions

    Is there any tool ?

    Thanks!!

    no, there's no...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 12, 2011 at 5:38 am

    #1406691

  • RE: Utility like Beyond Compare for SQL Server

    WinMerge has a great GUI, windiff can be called forma command line, they are for comparing two text files for differences...is that what you are after?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 11, 2011 at 11:40 am

    #1406537

Viewing 15 posts - 6,406 through 6,420 (of 13,460 total)