Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 13,460 total)

  • RE: Linked Server error on Mirror DB

    The code is tested at parsing time for all objects to exist;

    it doesn't allow logical testing to be ignored.

    you could switch to dynamic SQL instead to avoid the error.

    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!

    May 31, 2013 at 6:55 am

    #1620047

  • RE: DB Randomly sets in Single User Mode

    riggins13 (5/31/2013)

    I ran the query, (changed the blank db to my db name) and I get nothing 🙁

    boggled

    well, the default trace only keeps the last 100 meg of DDL...

    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!

    May 31, 2013 at 6:34 am

    #1620039

  • RE: help writing SUBSTRING() expression please

    agreeing with Dave, it seems to work fine, but it assumes that MFM always exists and is always those three letters int eh first three chars.

    if we are grabbing something...

    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!

    May 31, 2013 at 6:23 am

    #1620034

  • RE: DB Randomly sets in Single User Mode

    Stating the obvious, a database doesn't just get set to single user by itself, some process or person actually issued the command.

    that ALTER DATABASE command counts as a DDL operation,...

    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!

    May 31, 2013 at 6:00 am

    #1620026

  • RE: Open SSMS 2012 using RUN window

    my SSMS for SQL 2012 is in this folder:

    "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

    My question for you is whether you want to Replace the current call for SSMS with the 2012...

    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!

    May 31, 2013 at 5:30 am

    #1620016

  • RE: Merge between two tables , on two different databases.

    i have to update destination table every week.

    weekly updates screams drop and recreate to me; if you needed any changes/updates that were mere seconds old, it might be 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!

    May 30, 2013 at 2:26 pm

    #1619908

  • RE: Merge between two tables , on two different databases.

    if this was just an insert form the source, you'd ideally want to find a way to find the max(id/createddate) from the target, and get records that are greater than...

    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!

    May 30, 2013 at 2:13 pm

    #1619901

  • RE: Are the posted questions getting worse?

    GilaMonster (5/30/2013)

    Lowell (5/30/2013)

    The products of 21 is 7 and 3.

    [nitpick]

    The factors of 21 are 7 and 3. The product of 7 and 3 is 21

    [/nitpick]

    it's a quote, i...

    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!

    May 30, 2013 at 1:52 pm

    #1619877

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (5/30/2013)

    GilaMonster (5/30/2013)

    The Dixie Flatline (5/30/2013)

    GilaMonster (5/30/2013)

    I just delete that kind of thing outright, long with the 'Answer my posted question', 'explain life, the universe and everything to...

    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!

    May 30, 2013 at 1:35 pm

    #1619861

  • RE: find dates where over x # of rows were created?

    my wild guess to provide a rough example: note i'm truncating the time portion of hte datetimes to the day.

    With YourTable

    As(

    SELECT 1 AS SomeColumnForGrouping,CONVERT(datetime,'2013-05-30 07:26:30.157') AS CreatedOn...

    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!

    May 30, 2013 at 1:30 pm

    #1619859

  • RE: Database Mail

    we have office365, so i just setup and tested a dbmail using it;

    here's the scripted results, which will probably help you a lot:

    i was in a rush, and named both...

    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!

    May 30, 2013 at 12:34 pm

    #1619814

  • RE: What do u mean by DB Refresh

    in my shop, it would mean grabbing another backup of the "production" database and restoring it over the top of the Test Database that the developers and QA groups use...

    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!

    May 30, 2013 at 9:40 am

    #1619764

  • RE: syntax stumped

    i think it's the +90 INSIDE the datediff: '20130401' + 90 probably turns into either 20130491 or '2013040190', either of which are not valid datetimes.

    maybe like this?

    select *, '20'...

    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!

    May 30, 2013 at 8:26 am

    #1619731

  • RE: BCP Failure

    most likely permissions,

    if you right click on that specific folder, and go to the security tab, you can see everyone who has permissions.

    * Note that NT Authority\Network Service DOES NOT...

    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!

    May 30, 2013 at 7:51 am

    #1619716

  • RE: Is there an open source equivalent to sqlcmd.exe?

    shew (5/30/2013)

    [Background information]

    I have a user who is convinced that his third party application is losing connection to SQL Server from a given app server (and the app will not...

    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!

    May 30, 2013 at 6:11 am

    #1619663

Viewing 15 posts - 3,361 through 3,375 (of 13,460 total)