Forum Replies Created

Viewing 15 posts - 5,626 through 5,640 (of 13,460 total)

  • RE: Problems with $(...) powershell sintax in SQL Server

    constant strings have to be quoted out i think,

    so I'm fairly sure this is the right syntax:

    $BackupFiles=get-childItem -name -include "*_"+$NumberOfWeek+"_*"

    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!

    April 9, 2012 at 12:39 pm

    #1470858

  • RE: Use Extended Properties or a separate db for definitions?

    i prefer the extended properties, because they stay with the database they are describing;

    that's really the purpose of the extended properties anyway;

    it also makes it a lot easier for any...

    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!

    April 9, 2012 at 9:03 am

    #1470690

  • RE: Calling dynmic sql from function

    you are correct; dynamic SQL is not allowed in a UDF, dynamic SQL limits you to either a procedure or ad-hoc code that will need to be built and executed...

    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!

    April 9, 2012 at 8:07 am

    #1470665

  • RE: Backup and Restore permission to user

    a person with db_owner permissions has the ability to backup, restore, or even drop their own database, i believe.

    that's very easy to test.

    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!

    April 9, 2012 at 6:08 am

    #1470606

  • RE: A trigger that has been added by someone else before, also I've done on, modify, I get the following error.

    well it sounds like there is a few things going wrong here; is this a CLR trigger or a regular TSQL trigger? a TSQL trigger should not be going 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!

    April 9, 2012 at 5:32 am

    #1470597

  • RE: Database Mail does not work on New Server

    welsh can you go to one of your servers you know you already set up and is working, and use my script to reverse engineer database mail settings?

    then you can...

    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!

    April 7, 2012 at 2:22 pm

    #1470451

  • RE: Database Mail does not work on New Server

    i think if you look at the profile, the checkbox for "This server requires a secure connection(SSL) is checked.

    the error message says the mail server doesn't support SSL for 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!

    April 7, 2012 at 1:46 pm

    #1470447

  • RE: Trigger to capture data before and after an update

    ok based on your table scheme you posted, this correctly builds a string and prints it, listing only columns that CHANGED, along with some hopefully helpful audit information.

    I'll leave it...

    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!

    April 6, 2012 at 2:12 pm

    #1470278

  • RE: Trigger to capture data before and after an update

    ok, one of the things you'll run into first is permissions to send mail inside the trigger.

    EVERY user that can access the table will need to a user in 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!

    April 6, 2012 at 1:31 pm

    #1470258

  • RE: Trigger to capture data before and after an update

    how many columns are"critical" that you have to track for changes in the table to be emailed?

    It would be pretty easy to modify my example, but i'd like to see...

    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!

    April 6, 2012 at 1:11 pm

    #1470252

  • RE: Trigger to capture data before and after an update

    here's an example i put together for a different post;

    it's getting inserted items, putting them into a comma delimited string(because of course the trigger could have multiple rows!)

    for your trigger,...

    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!

    April 6, 2012 at 12:57 pm

    #1470241

  • RE: Item Stock Update problem (Set Based solution)

    capn.hector (4/6/2012)

    ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update every conversion factor...

    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!

    April 6, 2012 at 7:57 am

    #1470103

  • RE: Item Stock Update problem (Set Based solution)

    are you storing just the xml in the database, or processing the xml?

    if you are processing the xml, don't you stick the data into a Product Sold Table somewhere? then...

    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!

    April 6, 2012 at 6:06 am

    #1470049

  • RE: How to get entire database objects statements(queries)....:(

    also, save the script as a txt / sql file, not a word doc; depending on your settings for autocorrect, some words could get changed from the actual script in...

    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!

    April 6, 2012 at 4:58 am

    #1470026

  • RE: Filter Extended Properties by Schema

    Welsh Corgi (4/5/2012)

    Lowell,

    Hey yeah your right, thanks.

    Whatever happened to your Dog Avatar? I liked it. What model is that Gas:-) Mask? I did not see that one before.

    yeah my dog...

    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!

    April 5, 2012 at 2:44 pm

    #1469838

Viewing 15 posts - 5,626 through 5,640 (of 13,460 total)