Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 13,460 total)

  • RE: how to maintain test environment

    here's an adapted example of some code i use to check for invalid objects; this will recompile your procs/functions/views to allow you to point to a different database.

    at the end,...

    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!

    December 5, 2013 at 11:49 am

    #1671266

  • RE: sp_send_dbmail; one record at a time

    ok, here's a cursor example adapted a bit to your requirements;

    YOU will have to modify it to manage any date conversions/formats to varchar, as well as gracefully handle nulls, because...

    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!

    December 5, 2013 at 11:39 am

    #1671260

  • RE: sp_send_dbmail; one record at a time

    also, wouldn't it be better to send an email simply stating there is an alert/facilities are down,a nd direct them to a web page for details?

    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!

    December 5, 2013 at 9:46 am

    #1671205

  • RE: sp_send_dbmail; one record at a time

    ok, so how many rows does your query return?: and please confirm that if that returns 100 rows, you want 100 emails, one per row? is that what you are...

    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!

    December 5, 2013 at 9:40 am

    #1671202

  • RE: sp_send_dbmail; one record at a time

    wheelsthatgrip (12/5/2013)

    Hello All,

    I am using dbmail to send out the results of a query. The results are being sent to SMS users so the output has to be limited...

    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!

    December 5, 2013 at 8:50 am

    #1671164

  • RE: Triggers for insert,update,delete in MSSQL

    details. you'll wnat to provide details if you wantany meaningful answers.

    inside the trigger, you compare the columns in the virtual tablees INSERTED and DELETED to each other.

    ie

    IF EXISTS (SELECT 1...

    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!

    December 5, 2013 at 8:47 am

    #1671161

  • RE: Hit on DB from a User

    Ratheesh.K.Nair (12/5/2013)

    Hi Experts,

    We have a DB user names Supply . Application will hit the DB with this username.

    Is there anyway to find the hit happening to the database?Thanks 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!

    December 5, 2013 at 7:20 am

    #1671086

  • RE: Column properties of table variables

    Gail i just tried that, but cannot seem to get the object_id;

    for a temp table, i can get object_id('tempdb.dbo.TableName') no problem, but is there a trick for table variables?

    this is...

    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!

    December 5, 2013 at 7:13 am

    #1671080

  • RE: Triggers for insert,update,delete in MSSQL

    navimir (12/5/2013)

    I am working on triggers for insert,update and delete

    output of the trigger shows tablename,user and timestamp

    Is it possible to display the column name,old value and new value??

    There are around...

    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!

    December 5, 2013 at 6:40 am

    #1671052

  • RE: how to maintain test environment

    rightontarget (12/4/2013)

    but then I will have to edit every procedure to make sure that joins point to test instance of the database.

    so your procedures are using three part naming...

    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!

    December 5, 2013 at 6:23 am

    #1671039

  • RE: Android Tutorials

    I'm always into the free resources, as long as you are willing to pour your time into learning.

    I started straight from the source: android.com has a lot of of reosurces...

    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!

    December 5, 2013 at 5:37 am

    #1671008

  • RE: Restriction on Primary key

    sqlvogel (12/4/2013)

    That's incorrect. It's not necessary to create a primary key for referential integrity purposes. Referential Integrity is a good thing of course but you can enforce referential integrity against...

    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!

    December 4, 2013 at 1:46 pm

    #1670847

  • RE: Create table in MS SQL Server ffrom Quickbook

    at one point, built a .NET project that used the quickbooks connector from http://www.rssbus.com/;

    with that, and some minor configuration in quickbooks to allow remote access, i was able 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!

    December 4, 2013 at 10:48 am

    #1670795

  • RE: How to call procedure from function. Getting error Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function.

    mote.ajit2 (12/4/2013)

    Hi!

    I am trying to call procedure from function but getting following error.

    Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function.

    Actually I want table valued function...

    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!

    December 4, 2013 at 5:46 am

    #1670668

  • RE: Performance issues with SP

    sree-226516 (12/3/2013)

    Hi,

    We have a stored procedure which updates table A every 5 mins whole day(9AM to 7PM).Table A has only one day worth data and end of the day 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!

    December 3, 2013 at 2:39 pm

    #1670546

Viewing 15 posts - 2,836 through 2,850 (of 13,460 total)