Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 13,460 total)

  • RE: Send email issue

    is there a message from the mail server itself? unable to relay, mailbox full, etc?

    that's probably where the error is, my server requires a username and password to authenticate via...

    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!

    August 30, 2011 at 10:06 am

    #1375108

  • RE: bcp Errors

    Charlie I only see two things.

    i think the call to the procedure has to be fully qualified, i always put the servername.schemaname, but that might not be an issue.

    the other...

    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!

    August 30, 2011 at 9:52 am

    #1375099

  • RE: Find birthdays of a week

    this seems to work for me;

    i'm distilling each date to be the # of days fromt he beginning of the year.

    there's alot of dateadd/datediff in there, so it can be...

    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!

    August 30, 2011 at 6:34 am

    #1374928

  • RE: Error Converting Datetime to string

    at least some of your column values are not blank strings and also not convertable to a datetime...might want to look at it with this:

    SELECT [Closing Memo Date] As BadDate,*

    FROM

    YourTable...

    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!

    August 29, 2011 at 2:53 pm

    #1374735

  • RE: Regular Expression Replace using sql server function

    R.P.Rozema (8/29/2011)

    Good luck explaining this to your teacher 😉

    🙂

    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!

    August 29, 2011 at 1:39 pm

    #1374684

  • RE: Do NOT grant permission to create or drop any objects in teh database

    Guras (8/26/2011)

    But does 'DB_DenyDataWriter' prevent them from being able to create and drop objects in that database? In other words if I can give the role read and insert and...

    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!

    August 26, 2011 at 5:07 pm

    #1374161

  • RE: Do NOT grant permission to create or drop any objects in teh database

    fiarly straight forward, since by default, they have no rights to do anything that you don't give them rights to.

    here's a very simple example, but esentially you want to 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!

    August 26, 2011 at 3:04 pm

    #1374125

  • RE: Getting NULL for Object Name when trying to decode sys.dm_tran_locks.resource_associated_entity_id

    Mario the object_name() function has a second parameter for the database_id;;

    i suspect that's what you need to add;

    try this and confirm it fixes the issue...you'll see all i did was...

    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!

    August 26, 2011 at 2:55 pm

    #1374120

  • RE: Creating a Linked server to a server that has a hyphen in the name

    i think you can specify the port by adding comma portname to the server? my examples are assuming you use port 14433 as the port.

    for avoiding the dash and 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!

    August 26, 2011 at 12:30 pm

    #1374036

  • RE: Can't save a table

    MysteryJimbo (8/26/2011)

    I disagree.

    I've just tested this on a table column with no constraints, fk etc. Ran the statement given which worked instantly. I then did 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!

    August 26, 2011 at 7:10 am

    #1373743

  • RE: Can't save a table

    MysteryJimbo (8/26/2011)

    Dont do GUI. The GUI is very cautious when it comes to altering tables and will more often than not copy data into a temporary table, rename 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!

    August 26, 2011 at 6:54 am

    #1373731

  • RE: Can't save a table

    i leave mine unchecked, because if i'm going to change a table via the GUI, i know it handles all those drop/rename/new cosntraints automatically, so i'm not too worried;

    I'm 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!

    August 26, 2011 at 6:53 am

    #1373729

  • RE: Can't save a table

    sounds like you are changing a column that has FK or something on there that requires a drop and recreate fromt he GUI.

    there is a checkbox that prevents 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!

    August 26, 2011 at 6:37 am

    #1373715

  • RE: Searching/Querying Records from Database

    hellolasantha (8/25/2011)

    @Grant Fritchey

    @Lowell

    So

    if i get a copy of particular result set and kept in the memory,

    Do the key press interraction with the copy (which is in the memory)

    would...

    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!

    August 25, 2011 at 8:37 am

    #1373197

  • RE: CmdExec .bat file Failed

    to me, the error looks like the Kitchen.bat is not found in any of the folders in the %PATH% variable.

    the call looks like oyu expect it to exist inside...

    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!

    August 25, 2011 at 7:32 am

    #1373144

Viewing 15 posts - 6,856 through 6,870 (of 13,460 total)