Forum Replies Created

Viewing 15 posts - 7,336 through 7,350 (of 13,459 total)

  • RE: Backing up database mail configuration and linked servers

    i htink you also need a backup of master just in case;

    I thought the CREDENTIAL for any database mail username/pass used for the AUTH command are in master, and 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!

    June 23, 2011 at 1:13 pm

    #1343342

  • RE: How to import multiple CSV files.

    ok, BULK insert's about a zillion times easier to use than SSIS.

    your original table definition that you posted is missing two columns that appear in your data, country, and selection...

    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!

    June 23, 2011 at 11:31 am

    #1343269

  • RE: char(10) and char(13)

    CrLf is CHAR(13) + CHAR(10), i think you have the order reversed, so it's not finding anything.

    REPLACE(Col011, CHAR(13) + CHAR(10) , ' ') AS Expr2

    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!

    June 23, 2011 at 8:41 am

    #1343086

  • RE: Tail Log Backup in SQL Server 2005

    Ninja's_RGR'us (6/23/2011)

    Ah!, nice new sigh Lowell :w00t:

    Thanks! i got inspired by seeing at least three recent threads with that same theme.

    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!

    June 23, 2011 at 8:39 am

    #1343080

  • RE: Tail Log Backup in SQL Server 2005

    gotcha, so in a disaster recovery scenario like that, where the mdf was damaged/lost, you would not be able to do a tail backup...

    all you can do is restore the...

    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!

    June 23, 2011 at 8:35 am

    #1343074

  • RE: Trigger to insert records on a linked server else in a local server

    instead of a trigger, i strongly recommend a scheduled job that migrates the data to the linked server.

    if the linked server cannot be connected to(due to username/password, networking issues, or...

    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!

    June 23, 2011 at 8:31 am

    #1343072

  • RE: Tail Log Backup in SQL Server 2005

    if you deleted the mdf file, you had to have stopped the server to do it...so when you restarted the server, didn't the database show an error? did you recreate...

    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!

    June 23, 2011 at 8:24 am

    #1343067

  • RE: Convert text to number

    here is how i would do it:

    1.add a new float column to the table.

    2.UPDATE table set newcolumn = convert(float,oldcolumn) where isnumeric(oldcolumn) =1

    3. the columns that were non-numeric willb e null.....do...

    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!

    June 23, 2011 at 8:22 am

    #1343064

  • RE: How to extract "My Report" from the String /MY Reports/LotusNotes Ok/My English Report

    if the path will be less than 4 folders deep, you could use a trick with PARSENAME:

    /*

    (No column name)(No column name)(No column name)(No column name)

    NULLMY ReportsLotusNotes OkMy English Report

    */

    SELECT

    PARSENAME(ThePath,4),

    PARSENAME(ThePath,3),

    PARSENAME(ThePath,2),

    PARSENAME(ThePath,1)

    FROM

    ( 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!

    June 23, 2011 at 8:15 am

    #1343061

  • RE: Which procedures or function srae using my table???

    chandan_jha18 (6/23/2011)

    When i right click on the table and see dependencies, it shows me stored procedures or views depending on it. Is it a correct and reliable way?

    it's pretty close...

    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!

    June 23, 2011 at 7:56 am

    #1343046

  • RE: Want to restrict DBOWNER to Drop database

    i would think that a replacement role like this would give a user the rights they need to create objects and do any DML stiff, but take away the ability...

    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!

    June 22, 2011 at 9:49 am

    #1342534

  • RE: Rename of Foreign key/Default name

    i just renamed a foreign key no problem...

    sp_rename 'FK__SFPLGRP__SFGROUP__000BC426','FK_SFPLGRP_to_SFGROUP'

    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!

    June 22, 2011 at 9:35 am

    #1342514

  • RE: FIRST FUNCTION

    the FIRST function is an access function, and doesn't have a true equivilent in SQL server...the best you can do is TOP 1...ORDER BY

    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!

    June 22, 2011 at 9:32 am

    #1342505

  • RE: What "read only activity" can exist on databases

    for me "read only activity" means SELECT from views or tables; and more specifically, no INSERT/UPDATE/DELETE/EXECUTE rights to anything else in

    the database.

    maybe i can get you at least started...

    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!

    June 22, 2011 at 9:14 am

    #1342478

  • RE: URGENT HELP NEEDED

    since you are using access, those are two different queries;

    the GO statement is valid for SQL Server;

    each of the two queries needs to be saved separately...been a while since 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!

    June 22, 2011 at 4:42 am

    #1342302

Viewing 15 posts - 7,336 through 7,350 (of 13,459 total)