Forum Replies Created

Viewing 15 posts - 5,236 through 5,250 (of 13,460 total)

  • RE: Adding a primary key to the IIS ODBC logging table

    i wouldn't be fixated on having a primary key just for the sake of having a primary key;

    if you will be searching by [logtime] date primarily , i would simply...

    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!

    July 9, 2012 at 11:02 am

    #1510448

  • RE: Help me in Query

    you replaced "D" with a space.

    repalce with an empty string instead:

    select LTRIM(REPLACE(A_H, 'D', '')) from tableA

    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!

    July 9, 2012 at 8:18 am

    #1510359

  • RE: Help me in Query

    if you search the forums here, there is a function "dbo.StripnonNumeric" that could help as well;

    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!

    July 9, 2012 at 7:08 am

    #1510319

  • RE: Monitoring tool

    also take a look at the two articles here on SQL Server Central;

    they list a lot of free tools, some of which are related to monitoring:

    Free Tools for the SQL...

    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!

    July 9, 2012 at 6:13 am

    #1510289

  • RE: Increment Name Tag

    julien.dutel (7/6/2012)

    Thanks Lowell! Actually it generate the statement very-well. I was looking for a code that directly give me the desired dataset, is there a way to execute a string...

    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!

    July 6, 2012 at 1:27 pm

    #1509879

  • RE: Increment Name Tag

    this will generate the statements so you can copy and paste them with just a little bit of cleanup:

    SELECT

    'SELECT Signal_Index, Sample_TDate_' + convert(varchar,N) + ', Sample_Value_' + convert(varchar,N) + '...

    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!

    July 6, 2012 at 1:09 pm

    #1509873

  • RE: Linked Server missing tables

    by default, a linked server will only show the objects available in the DEFAULT DATABASE of the loginthat is connecting;

    That's important, because if you have a login 'bob' that has...

    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!

    July 6, 2012 at 11:18 am

    #1509816

  • RE: Create a role for editing stored procedures

    to get just the existing procs, you want to use the sys tables to help generate the commands you need:

    SELECT

    'GRANT ALTER ON ' + schema_name(schema_id) + '.' + quotename(name)...

    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!

    July 6, 2012 at 11:12 am

    #1509813

  • RE: Create a role for editing stored procedures

    Kenneth.Fisher (7/6/2012)

    I'm trying to create a role to give to developers to edit stored procedures. I've granted it CREATE PROCEDURE at the database level but the user is still...

    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!

    July 6, 2012 at 11:08 am

    #1509810

  • RE: SQL tidy tools

    I purchased the SSMS Addin from The same company BrainDonor mentioned;

    $50 bucks, and I went for the add-In vs the batch processing executable, as my coding is more...

    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!

    July 6, 2012 at 9:57 am

    #1509778

  • RE: MSDB.dbo.sp_send_dbmail sending blank html body

    print your @tableHTML variable before you get to the sp_sendmail.

    is it null, maybe due to concatination? that would make your html body blank for sure.

    check your one parameter and three...

    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!

    July 6, 2012 at 8:52 am

    #1509737

  • RE: updating file custom properties

    this was an interesting article on setting custom file attributes;

    http://blog.rodhowarth.com/2008/06/how-to-set-custom-attributes-file.html

    i found it interesting that you can set attributes on non- MS Office files, and the attribute stays as long as...

    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!

    July 6, 2012 at 8:48 am

    #1509735

  • RE: Unable to Transfer .Zip file to the another Server using xp_cmdshell in SQL Job

    most likely permissions.

    The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,xp_cmdshell,bcp with a "trusted" connection, sp_OA type functions...

    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!

    July 6, 2012 at 5:24 am

    #1509610

  • RE: Soundex and the Irish

    soundex returns 0000 whenever a non A-Z,a-z character occurs: so commas hypens, numbers or the quote all give you misleading data.

    personally, i had always stripped out the values fromt...

    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!

    July 5, 2012 at 1:06 pm

    #1509310

  • RE: Revert Last Delete Statement on in SQL Mgmt Studio

    another longshot: if CDC is enabled for your table, you could get the values fromt hat:

    --find any tables that are tracked via Change Data Capture

    SELECT

    name...

    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!

    July 5, 2012 at 10:37 am

    #1509223

Viewing 15 posts - 5,236 through 5,250 (of 13,460 total)