Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 9,244 total)

  • RE: Login failed. The login is from an untrusted domain and cannot be used with Windows authenication (Microsoft SQL Server, Error: 18452)

    Are you receiving this after your domain migration?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Adding new database

    It sounds like the datafiles still exist on disk. Rather than creating a new database, try Attaching an existing database and browse to the disk files.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SAP requires SQL sysadmin to work

    I have worked with a few applications in the past that all required elevated privilege. This is a typical candidate for ring fencing to a separate instance.

    If the application is...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Dynamic Sql - Must declare the scalar variable

    bobyahed2dis (2/23/2014)


    Hello All,

    thanks for coming back to my post,

    i'm using the cursor as i need to cycle through the records one by one

    TEMPMONTHLYMATCHES_REPORTEDMONTHS contains the following;

    APP_ID = unique serial...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Resync log shipping after copy fails

    n00bDBA (2/21/2014)


    Hi all,

    ive had log shipping break due to the copy failing as there wasnt enough space on the drive.

    My first re-action is stop the log shipping jobs...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How is my user getting update permissions through stored procedure?

    Martin_Burton (2/19/2014)


    I have a user that has db_datareader role on a database and explicit grant Connect and Execute permissions on the same database, there are no other permissions set.

    My user...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mirroring failed after domain Migration

    pradeep.mohan (2/22/2014)


    Hi,

    After domain migration all mirroing connection is disconnected, how can i recover this i found windows event log

    "Database mirroring connection error 2 'DNS lookup failed with error: '11001(No such...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SAN format - SQL Clustered

    lsalih (2/21/2014)


    never mind, I was not searching correctly for how to implement it. There are many articles out there:

    http://www.sqlservercentral.com/Forums/Topic1058329-5-1.aspx

    I just made backups, put sql server cluster resources offline. Asked...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Dynamic Sql - Must declare the scalar variable

    bobyahed2dis (2/23/2014)


    Hello All,

    I'm very new to sql this is my first attempt, I am trying to use cursor with dynamic sql to identify the column name to insert values into,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: yippee i passed!!

    One step closer to my private pilots licence 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: yippee i passed!!

    ChrisM@home (2/21/2014)


    Will we have to call you Gloster now? 🙂 Well done Perry.

    No just Wing Cmdr will do 😀

    Jeff Moden (2/21/2014)


    Outstanding.

    Did you have to study for the urine test? 😛

    Besides...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can't start MSSQLSERVER service. Can't find file specified

    hayden_jones (2/21/2014)


    SQL 2008 R2. Windows Server 2008 R2.

    VMWARE

    Needed much more space on the drive SQL was installed on (E: drive).

    OS guys said, "we can't add that much space....

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: windows cluster quorum setting on windows server 2012

    after checking there is a trace flag

    -T272

    This will revert to the behaviour in previous versions of the product

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server cluster without Windows Failover Cluster

    Hi

    Parts 2-4 will be released soon

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: windows cluster quorum setting on windows server 2012

    yep that's what i'm seeing, jumps by 1000 each failover

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 3,526 through 3,540 (of 9,244 total)