Forum Replies Created

Viewing 15 posts - 8,011 through 8,025 (of 13,460 total)

  • RE: custom sql server

    i think using the row_number function is the right way to tackle this; note i went to the trouble of putting your data into a consumable format; It helps you...

    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!

    March 3, 2011 at 11:47 am

    #1294200

  • RE: How to add email address in a t sql code

    --a query as an attachment to the email

    declare @body1 varchar(4000)

    set @body1 = 'Sample Email from SQL2008 ' + CONVERT( VARCHAR( 20 ), GETDATE(), 113 ) +

    ' '

    EXEC msdb.dbo.sp_send_dbmail

    ...

    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!

    March 3, 2011 at 8:44 am

    #1294063

  • RE: How to add email address in a t sql code

    you have to have setup database mail before you can use it.

    in SSMS, under the "management" folder, find Database Mail

    you have to create a profile, and also at least one...

    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!

    March 3, 2011 at 8:29 am

    #1294059

  • RE: How to add email address in a t sql code

    the parameters are comma delimited, you have a semi colon before @message.

    change to a comma.

    also, this param is spelled wrong:

    @receipent

    and i think you might need more parameters; see 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!

    March 3, 2011 at 7:56 am

    #1294033

  • RE: sql

    naveedanjum1 (3/3/2011)

    0 down vote favorite

    I am working with a database name xyz , table name a ,b, c, d. my question is if in table a name field , table...

    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!

    March 3, 2011 at 7:37 am

    #1294016

  • RE: SSIS Script Task - Need to color code excel cell based on certain value

    via SSIS, it's not possible; you'd have to automate excel in order to do that: formatting codes for excel cells are not exposed.

    see this thread for Koen's more complete answer:

    http://www.sqlservercentral.com/Forums/Topic1069138-148-1.aspx

    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!

    March 3, 2011 at 7:26 am

    #1294007

  • RE: How to add email address in a t sql code

    if your code is centralized, meaning all inserts occur in a single point of entry, like a stored procedure, then adding the email code to that stored procedure makes sense.

    if...

    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!

    March 3, 2011 at 7:18 am

    #1293998

  • RE: Change table name

    RENAME is the oracle command to do what you are asking.

    in sql server, a stopred procedure is used:

    EXEC sp_rename 'admin','administration'

    or

    EXEC sp_rename 'dbo.admin','administration'

    note the first parameter can accept just the tablename,...

    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!

    March 3, 2011 at 5:47 am

    #1293943

  • RE: Doubt in compile

    well, your proc's constructions not going to work, but i realize that was a prototype.

    you cannot have a GO command in the body of a procedure; to do what you...

    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!

    March 3, 2011 at 5:03 am

    #1293926

  • RE: Database mail configuration migration

    one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not know of any way to script out 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!

    March 3, 2011 at 4:53 am

    #1293916

  • RE: Is there a way to find the SQL port for a server remotely

    SQL Recon is a free utility that will help you find all installations on a network; other than that, it's reading the registry in multiple places on multiple machines, maybe...

    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!

    March 2, 2011 at 9:26 am

    #1293584

  • RE: Epoch to readable format

    can you add the # hours difference when calculating the server's getdate to the utc date?

    for example, this returns 5 form my EST server...it might vary depending on daylight savings:

    '

    --'returns...

    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!

    March 2, 2011 at 7:56 am

    #1293516

  • RE: Stored procedure aborts without message

    we'd be able to help better if you showed us the body of the stored proc; but in general, if you get an error that is level 16 or above,...

    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!

    March 2, 2011 at 5:28 am

    #1293427

  • RE: Add SQL Management Studio to Cluster Node

    the client tools(SSMS) to query the database are really separate from the cluster itself; it's no different than having Winzip on one server and not the other; it's 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!

    March 1, 2011 at 1:49 pm

    #1293198

  • RE: sql code works fine - front end application is slow?

    definitely parameter sniffing first; it is very doubtful your network is bogging down just for one app, unless it is returning a MillionBillion rows. this is one of the first...

    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!

    March 1, 2011 at 12:39 pm

    #1293156

Viewing 15 posts - 8,011 through 8,025 (of 13,460 total)