Forum Replies Created

Viewing 15 posts - 5,506 through 5,520 (of 13,460 total)

  • RE: dataset ?

    SQL_path (5/9/2012)

    Hi all,

    My query has data that drives off of @reportstart @reportend but for the same paramerters the dataset in the report runs blank, therefore available values are empty....

    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!

    May 9, 2012 at 12:48 pm

    #1485262

  • RE: Convert From Zone times in SQL Server 2008 R2

    can you change the processes to start using GETUTCDATE instead of GETDATE when you are building your time stamps?

    that's greenwhich(sp?) time, so you can better compare dates between data at...

    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!

    May 9, 2012 at 11:02 am

    #1485199

  • RE: XP_Cmdshell 'Access is denied'

    ravisamigo (5/8/2012)

    Hi All,

    xp_cmdshell 'dir \\Server001\e$' - running in Server2

    xp_cmdshell 'dir \\Server002\e$' - running in server1

    OUTPUT : 'Access is denied.'

    But I'm able to access through RUN(WIN+R) command from server1 to server2...

    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!

    May 9, 2012 at 10:35 am

    #1485191

  • RE: Table that has all the dates from 2000 till today

    I've posted my version of a Calendar table a few times in some other posts; take a look at my version, and you can decide whether you want to use...

    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!

    May 9, 2012 at 10:06 am

    #1485163

  • RE: lost permissions to execute stored proc

    if someone, say a developer, had a change to the code, and did a DROP PROCEDURE usp_blahBlah and then did CREATE PROCEDURE usp_BlahBlah, the permissiosn will be lost.

    if 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!

    May 9, 2012 at 8:36 am

    #1485094

  • RE: Optimize select query

    with the DDL, we could see if the column MessageTimeStamp was datetime or not...i suspect it's a varchar because of the code converting it to datetime.

    you could add persisted...

    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!

    May 8, 2012 at 6:52 am

    #1484480

  • RE: int vs small int and tiny int

    back in my vb6 days, i had to debug someone elses program that used vb6 int (32767 max size) on a program that had been in place for years 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!

    May 8, 2012 at 6:16 am

    #1484459

  • RE: Find out why a SP failed.

    If you can modify the proc code, you could add something that raises an error yourself;

    For example if not exists(SELECT therRecordstoDelete) or testing if @@rowcount =0

    And log info to helpxdiagnose...

    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!

    May 8, 2012 at 4:24 am

    #1484417

  • RE: Primary Key column also a Foreign Key column in same table...

    wow, it's possible to do that if you create the foreign key with the NOCHECk command;

    still that's just making a mess : looks like someone was just slapping bad code...

    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!

    May 7, 2012 at 2:31 pm

    #1484230

  • RE: uninstall sql server 2000

    if you can connect to it via query analyzer or enterprise manager, you can get the version installed.

    in QA, you can simply SELECT @@VERSION

    in enterprise manager, (it's been a while)...

    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!

    May 7, 2012 at 11:53 am

    #1484156

  • RE: Trigger with db_send_mail and try catch

    pamozer (5/7/2012)

    So I'm thinking I wasn't completely clear in my issue. The dbmail works fine. I am trying to do a try catch in case somebody goes 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!

    May 7, 2012 at 9:57 am

    #1484114

  • RE: How to check the columns within the table?

    well, it depends on the results you want, right?

    you had said at first you just wanted check how many rows are existed as like as above scenario...

    so displaying the stuff...

    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!

    May 7, 2012 at 9:05 am

    #1484094

  • RE: New Features in 2008

    bandarimohan 57273 (5/7/2012)

    Can any one say what are new features available in 2008 please....

    try this page, and change the drop down menu to 2008 instead of 2012;

    there's far too many...

    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!

    May 7, 2012 at 9:01 am

    #1484091

  • RE: How to check the columns within the table?

    Great job posting the DDL, that makes it SO easy to help!

    by using the INTERSEC operator, i seem to get the results you might be looking for;

    you could do somethign...

    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!

    May 7, 2012 at 8:49 am

    #1484087

  • RE: Find out why a SP failed.

    i guess it depends on what you mean by failed. do you mean:

    1. zero rows got deleted, but you expected it to delete something,

    2. or do you mean...

    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!

    May 7, 2012 at 8:40 am

    #1484082

Viewing 15 posts - 5,506 through 5,520 (of 13,460 total)