Forum Replies Created

Viewing 15 posts - 9,676 through 9,690 (of 13,460 total)

  • RE: Can we have both SQL 2005 and 2008 client tools on the same PC?

    on my machine i had 2005 installed a couple of times as various instance names...then i installed 2008. cleaning up some extra unneeded isntance names,

    i now have the 2005 db...

    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!

    April 16, 2010 at 8:23 am

    #1152865

  • RE: Map IP Address to a Geographical Location

    i must have tunnel vision this morning;

    i didn't see any BULK insert scripts for the files; after downloading the csv files, i see they are UNIX style(slash r for 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!

    April 16, 2010 at 7:05 am

    #1152797

  • RE: SQL 2005 collation

    there is a default collation at the database level, which you can see in sys.databases.

    collation is not at the table level, but for each individual column. the value is visible...

    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!

    April 16, 2010 at 6:19 am

    #1152756

  • RE: Change the Date Format

    first, you should never store dates as any datatype except datetime.

    fix it now so you don't have the same issue in the future; if it's stored as a date,...

    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!

    April 16, 2010 at 6:16 am

    #1152753

  • RE: SQL Server procedure- Strange problem

    i believe the setting "Generate Scripts For Dependant Objects" is True on one machine, but not the other.

    Tools>>Options in SSMS, then you have to find the node "SQL Server Object...

    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!

    April 16, 2010 at 5:55 am

    #1152741

  • RE: Profiler dbid = 0

    I know that when you look at sys.triggers and the db_id is zero, it's because it is a Logon Audit trigger, so it's not associated to a specific database, but...

    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!

    April 15, 2010 at 11:07 am

    #1152300

  • RE: Unexplained Client Disconnects

    just hazarding a guess, but since this is running on Express, could the AUTOCLOSE setting of the database be causing the disconnect of the client connections, when SQL Server decides...

    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!

    April 15, 2010 at 11:02 am

    #1152299

  • RE: How to: Rename foreign key constraint

    it's the full syntax for a constraint instead of the shortcut for a foreign key:

    ALTER TABLE dbo.a

    ADD CONSTRAINT FK_MyForeignKey FOREIGN KEY (id) REFERENCES dbo.b(id);

    to rename a constraint that has 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!

    April 15, 2010 at 9:20 am

    #1152206

  • RE: Database Mirroring Faqs

    I found a lot of stuff on Database Mirroring here:

    database mirroring sql server 2008

    general questions and information gathering stuff like that is what google is awesome at; the forums here...

    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!

    April 15, 2010 at 7:09 am

    #1152077

  • RE: Apostrophe's and Variables Headache

    Paul Clark-418949 (4/15/2010)

    PICNIC (Problem In Chair Not In Computer)

    hehe in my shop we call that a problem with the CKI (Chair to Keyboard Interface);

    it can often be fixed witht...

    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!

    April 15, 2010 at 6:41 am

    #1152060

  • RE: dateDiff question

    I'm a little weak on your requirement, so help me clarify it:

    you have an openDate and a closedDate.

    I thought the closedDate should be x business Days greater than the openDate;...

    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!

    April 15, 2010 at 6:26 am

    #1152051

  • RE: Are "SELECT Statements" cached?

    yes, the plan could be cached; it's not guaranteed.

    I have an older book that explains it in some detail...the answer is if SQL thinks there is a high cost 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!

    April 14, 2010 at 9:25 pm

    #1151858

  • RE: dateDiff question

    without the two tables (tblSale and tbl1 ) and some sample data, i can only make a guess that is syntactically correct;

    my assumption in my example is that the Closeddate...

    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!

    April 14, 2010 at 11:38 am

    #1151591

  • RE: Missing last 2 Days records ..How can i recover ..

    John Paul-702936 (4/14/2010)

    SIMPLE

    ouch.

    assuming deletion of specific data, then the data is lost. there is no way to recover deleted data when in SIMPLE mode;

    the typical thing you'd have to do...

    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!

    April 14, 2010 at 11:15 am

    #1151569

  • RE: not allow the user to copy the report

    that's pretty dumb. if you don't want them to see it, don't give them access to the report at all, period. if they are seeing "too much", tweak the report...

    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!

    April 14, 2010 at 10:37 am

    #1151536

Viewing 15 posts - 9,676 through 9,690 (of 13,460 total)