Forum Replies Created

Viewing 15 posts - 5,761 through 5,775 (of 13,460 total)

  • RE: Cannot connect to named SQL Server 2005 Express instances

    tI'd check for three things:

    1. Make sure the SQL Broswer service is running. That is the Service that handles the part of the connection when you request machinename\Instance1 ,...

    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 20, 2012 at 6:17 am

    #1461558

  • RE: Common table expressions and circular references

    For those of you who followed this thread, did anyone use this method to handle foreign keys with circular references?

    I adapted a couple of the posted examples, and against 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 18, 2012 at 10:01 am

    #1460935

  • RE: default value for foreign key column

    in the past, because the foreign key table is used for a drop down list, I've seen key-value pairs like 0 'Select...', and the default of zero 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!

    March 17, 2012 at 3:47 pm

    #1460906

  • RE: How to Retrieve the next record after clicking the next button

    My questions still apply;without details on what you have,what technology and what you've tried, i cannot give you any more advice than "the next button needs to retrieve the next...

    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 17, 2012 at 10:37 am

    #1460871

  • RE: How to Retrieve the next record after clicking the next button

    Not enough information, my friend. Remember we can only see what you post.

    Are you writing an application? If true,which language?

    Or maybe reporting services?

    Do you have any code you tried so...

    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 17, 2012 at 6:44 am

    #1460858

  • RE: SQL 2008R2 - ODBC cannot connect

    First check the windows firewall. Disable it on the server, and then try to connect via SSMS from a remote machine. If it connect, you know you have to...

    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 17, 2012 at 5:25 am

    #1460856

  • RE: default value for foreign key column

    The default value would need to be a real value in the foreign key table.

    An example might be a.n address record has a default value of the key to tbsrate...

    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 16, 2012 at 9:10 pm

    #1460822

  • RE: .asc file to .txt file

    ramchandra2cool (3/16/2012)

    when i did that i got junk characters there . can u pls advise

    ALL junk characters or SOME junk characters? was it human readable when you opened it?

    if all...

    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 16, 2012 at 2:56 pm

    #1460785

  • RE: How to compare results from two queries?

    halifaxdal (3/16/2012)

    Thanks.

    Why adding ROW_NUMBER() OVER (ORDER BY Q1.Code ASC) AS 'Row Number' gives me Row Number starting 900 and not in order?

    because there is no default order. SQL built 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 16, 2012 at 1:06 pm

    #1460719

  • RE: Cannot open or save a file in SSMS 2008 with new windows 7 box

    michael.packard (3/16/2012)

    No, SSMS is closed when I'm editing the registry, I wasn't specifically running regedit in administrator mode, but even when I did, my changes were overwritten.

    darn, sorry Michael, 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!

    March 16, 2012 at 12:15 pm

    #1460683

  • RE: Need to map network drive

    well the commands to create and delete are like this:

    but that's done via a command line...i'm not sure wehterh you'd do that in a script.

    I've done it via xp_cmdshell before...

    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 16, 2012 at 12:13 pm

    #1460680

  • RE: how to block developers to exec stored procedure to update accounting data from back end?

    ouch.

    so developers edit a procedure to manipulate data they are not supposed to touch, then put the original procedure body back to it's "normal" definition?

    AND this is happening on Production?

    wow.

    my...

    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 16, 2012 at 12:05 pm

    #1460674

  • RE: Cannot open or save a file in SSMS 2008 with new windows 7 box

    Are you editing the registry while SSMS is still open? i think it saves it's settings on exit, so you might be deleting the key, and closing SSMS re-writes 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 16, 2012 at 11:59 am

    #1460668

  • RE: ssms help

    Error 1068: The dependancy service or group failed to start .

    control Panel>>Administrator Tools>>Services:

    sounds like the password for the user running the service might have changed, or was never set...

    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 16, 2012 at 10:29 am

    #1460621

  • RE: Retrieve First Name and Last Name

    QQ-485619 (3/16/2012)

    I have a table which has a column called Name, which contains the name of our vendors. The data format in this column is lastname, firstName. For...

    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 16, 2012 at 9:03 am

    #1460564

Viewing 15 posts - 5,761 through 5,775 (of 13,460 total)