Forum Replies Created

Viewing 15 posts - 10,006 through 10,020 (of 13,460 total)

  • RE: Add Linked Server

    they linked server syntax you used is a bit different from what I typically use; i'm posting it here for reference;

    also, just a confirmation, your server is not 64 bit...

    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!

    February 5, 2010 at 6:40 am

    #1114379

  • RE: Speeding up a fast forward cursor proc

    tendayit thanks for posting everything we might need to analyze it; it's so large, it'd take a lot to look at it all;

    your functions 2200+lines ,and it's all doing...

    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!

    February 5, 2010 at 5:44 am

    #1114350

  • RE: Single mdf file attach in sql 2005

    imtiazm (2/4/2010)

    This is the reply i get

    ...

    File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

    File activation failure. The physical file name "f:\XXX.ldf" may be incorrect.

    The log cannot be...

    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!

    February 4, 2010 at 8:08 am

    #1113779

  • RE: Denying Access to Domain & BuiltIn Adminstrators

    the right thing to do is to go tell your other admins to not fiddle with your development server. Going behind their back and trying to lock them out is...

    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!

    February 4, 2010 at 6:33 am

    #1113697

  • RE: Help With REPLACE Function

    Rup you might want to check for other iterations based on html differences; for examples spaces before/after the equals sign just to be sure;

    i'm glad this worked for you.

    --original:

    set @pre...

    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!

    February 3, 2010 at 1:20 pm

    #1113164

  • RE: Help With REPLACE Function

    Ruprecht I'm halfway there from a sinlge command solution, but i wanted to post an immedite fix right away; if this is a one-time solution, this would give you everything...

    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!

    February 3, 2010 at 11:18 am

    #1113078

  • RE: Delete Duplicates from table with no identity column

    glad this was helpful for you , Leena; I've never found a practical use for it so far, but it is good to know; of course there is always 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!

    February 3, 2010 at 9:09 am

    #1112995

  • RE: can't add data source in Visual Studio with SQL Server ce 3.5

    eric could it have to do with disk permissions?

    for example, on my win7 laptop, i cannot write to c:\mydb.sdf, but i have no problem writing to C:\Program Files\Microsoft 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!

    February 3, 2010 at 8:45 am

    #1112967

  • RE: Change Data Capture Question

    would that mean you have to add a dml trace to the server so you can capture the user/application name/hostname and other information, i guess to complement the changes CDC...

    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!

    February 3, 2010 at 8:34 am

    #1112954

  • RE: Using stored proc in a user defined function.

    no, sorry DR; a function cannot call a stored procedure, only extended stored procedures;

    the reason is a function is not allowed to affect objects, and since a stored procedure could...

    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!

    February 3, 2010 at 7:50 am

    #1112899

  • RE: Remove individual NULLs, so each of record is distinct

    i think you'll have to use MAX(*) functions and a group by statement:

    SELECT

    Dt ,

    MAX(Wire) AS Wire,

    MAX(Convergys) As Convergys

    FROM YourTable

    Group By Dt

    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!

    February 2, 2010 at 12:14 pm

    #1112473

  • RE: Is there a way to remove the cancel button from a window?

    malware? it's just my crappy dev site that holds all my ugly screenshots and script examples; i don't see anything wrong, can you pm me whatever you are seeing?

    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!

    February 2, 2010 at 11:44 am

    #1112450

  • RE: Is there a way to remove the cancel button from a window?

    like Wayne said, there should be an event for OnFormClose you cna use to prevent the form from being destroyed if a process has not completed; also, you should also...

    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!

    February 2, 2010 at 11:22 am

    #1112441

  • RE: Most efficient way to retrieve top identity value.

    Gaby if you are inserting single rows at a time, even if there are lots of them per second, scop-identity() should work fine.

    if you have a single statement that is...

    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!

    February 2, 2010 at 11:07 am

    #1112435

  • RE: How to create a function that takes a table name and where clause as parameters

    look at the error you are getting; it should be very obvious;

    if i used your function for a table named "Customers" and a WHERE statement that was "CustomerName LIKE 'c%'

    what...

    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!

    February 2, 2010 at 10:04 am

    #1112389

Viewing 15 posts - 10,006 through 10,020 (of 13,460 total)