Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 13,460 total)

  • RE: datediff fun

    i think we'd need a CREATE TABLE definition and a few rows of sample data;

    for the most part, i think it's joining a Calendar table to get all possible hours...

    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 10, 2011 at 9:00 am

    #1297155

  • RE: C# help ....can't figure out whats going wrong

    he means the operating system...command prompt's COPY command does it in a single line: you could call the Shell command for it:

    in SQL

    EXEC Master.dbo.xp_CmdShell 'COPY C:\Temp\Header.txt+C:\Temp\Test01.txt C:\Temp\MyWork.txt'

    in a command window,...

    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 10, 2011 at 8:43 am

    #1297139

  • RE: comaptibility levels

    you'll need to take that into consideration when you upgrade; If you have a separate development server, I'd start testing with higher compatibility right away just to start tracking 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 10, 2011 at 8:36 am

    #1297133

  • RE: The default backup path...where does SQL keep it?

    beautiful; exactly what i was looking for; thanks so much, Gianluca!

    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 10, 2011 at 7:35 am

    #1297098

  • RE: The default backup path...where does SQL keep it?

    do you think looking at sys.sysaltfiles fo rthe master database, and assuming there is a parallel \Backup folder at the same level as the \DATA folder is safe?

    --C:\Program Files\Microsoft...

    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 10, 2011 at 7:18 am

    #1297087

  • RE: The default backup path...where does SQL keep it?

    darn; both that registry key and the that script on SQL tips assumes you know WHICH installation you are looking for already...MSSQLSERVER,MSSQL.1,MSSQL.2, etc;

    I wanted it to be a bit 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!

    March 10, 2011 at 7:14 am

    #1297083

  • RE: Replacing all occurrences of text in table 1 with text from table 2 iteratively

    your idea is even easier to implement; you simply update the source with some tags and poof, some simple CSS on the page and they can see or not 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!

    March 10, 2011 at 6:33 am

    #1297051

  • RE: Replacing all occurrences of text in table 1 with text from table 2 iteratively

    i would simplify the issue a bit:

    items that contain badwords get archived off to a separate audit table, then update the messages directly to remove the bad words; the overhead...

    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 10, 2011 at 5:11 am

    #1297000

  • RE: Parse HL7 message

    FYI HL7 is a messaging specification for healthcare information systems.

    I goggled a bit after this, and it appears that the parsing is not a trivial thing; one of 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 9, 2011 at 7:32 am

    #1296500

  • RE: DB mail issue

    the error 5.7.1 Unable to relay says the issue is with your mail server refusing anonymous mail;

    usually a mail server requires mail to either come from 1)a trusted source/ip, or...

    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 8, 2011 at 7:59 pm

    #1296271

  • RE: Value does not fall within the expected range. (SqlMgmt)

    I think this happened to me once when I had upgraded the server to a higher version of a service pack, but not my local client tools; the local client...

    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 8, 2011 at 11:34 am

    #1296038

  • RE: Linked Servers

    ypk1984 (3/8/2011)

    Hi I dont know, weather this is valid question or not?

    So when we establish the linked servers, we can be able to see all the servers linked under 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 8, 2011 at 11:21 am

    #1296030

  • RE: SQL 2008 linked server to postgreSQL db failure

    I'm guessing that the issue has to do with your SQL2008 being 64 bit, and thus requires 64 bit postgres drivers.

    take a look at this article:

    http://www.postgresonline.com/journal/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html

    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 8, 2011 at 9:04 am

    #1295943

  • RE: How to test my new sql server?

    rgerald 53299 (3/8/2011)

    XP needs to be the "Pro" version or higher to work as a client.

    I'm not sure what you mean by that; as long as the driver, whether 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!

    March 8, 2011 at 8:03 am

    #1295896

  • RE: Is it possible to restore a database to a lower version server?

    backs are stored at a major version level: SQL200/2005/2008/R2;

    service packs do not alter the format of the backup files, so you can restore to any installation of 2005; 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!

    March 7, 2011 at 1:44 pm

    #1295573

Viewing 15 posts - 7,966 through 7,980 (of 13,460 total)