Forum Replies Created

Viewing 15 posts - 12,211 through 12,225 (of 13,460 total)

  • RE: Calculating stored bytes of data in a varbinary(MAX) field

    damn that is interesting...my first instinct was that the len() function would work on a varchar(max), but it just returns 8000 if it is too big: I'll look some more.....

    create...

    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!

    November 14, 2007 at 10:19 am

    #751167

  • RE: Help with delete procedure

    Rama (11/14/2007)

    Hi,

    I have a delete procedure that has to check a dependent table (t2) for records before deleting from the main table (t1). If there is records the procedure has...

    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!

    November 14, 2007 at 10:04 am

    #751163

  • RE: sql server replicatoin requires actual server name to make a connection to the server

    if your other SQL server has a dynamic IP, and you need a real hostname for it, look at the free services at dyndns.org.

    you run a service on your remote...

    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!

    November 12, 2007 at 10:58 am

    #750326

  • RE: Sponsored Content

    I also have no problem with sponsored articles...a lot of the time,regardless of the source,they have a valueable lesson or tidbit of knowledge in them.

    As long as it's technical, it'd...

    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!

    November 12, 2007 at 7:55 am

    #750256

  • RE: SQL Server 2000 connecting to a .Net application

    I have a very similar situation: we use virtual machines for testing our application. the virtual machines can connect to dozens of sql servers on our network with no problem.

    ...

    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!

    November 12, 2007 at 6:34 am

    #750224

  • RE: System Stored Procedure Question

    well i found that SQL2005 has a stored proc to mark a specific object as system, instead of an on/off switch, so I'm still looking:

    -- SS2k5 provides a stored procedure...

    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!

    November 7, 2007 at 12:19 pm

    #749192

  • RE: Using Variables as column names in select statement

    Thanks Theo; I really need to test that myself , as I clearly don't make enough triggers; I should have known that...i assumed that the tables would only be populated...

    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!

    November 7, 2007 at 4:34 am

    #749034

  • RE: Sending mail with ole automation

    as i remember it, parameters may not be constructed inline; they have to be built and then passed:

    exec @res = sp_OASetProperty @oMail, 'TextBody', 'This is a reminder to let you...

    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!

    November 6, 2007 at 7:58 pm

    #748930

  • RE: System Stored Procedure Question

    pretty sure this is what happened:

    somebody ran this command:

    --Turn system object marking on

    EXEC master.dbo.sp_MS_upd_sysobj_category 1

    after that is run, all commands that create objects in SQL 2000 are system objects. this...

    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!

    November 6, 2007 at 1:40 pm

    #748845

  • RE: Search specific string in data in all tables

    here's something i use, and i'm sure i'm stating the obvious and what you already did tog et back up and running, but you'd be best off doing a back...

    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!

    November 6, 2007 at 1:35 pm

    #748841

  • RE: Using Variables as column names in select statement

    SET @execSQL = 'DECLARE @BeforeValue sql_variant, @AfterValue sql_variant '+

    'SELECT @BeforeValue = D.['+@ColumnName+'], '+

    ...

    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!

    November 6, 2007 at 10:30 am

    #748768

  • RE: Inserting random order of numbers between defined range

    Jeff Moden (11/6/2007)

    Kewl! Anyone interested in a million row duration test on this? 😀 I'd need some help 'cause I don't have 2k5...

    Jeff I feel really bad...

    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!

    November 6, 2007 at 9:33 am

    #748743

  • RE: How to find the last time a table was updated

    unless you have the database recovery Model property set to Full instead of Simple, there is no way to determine this without adding features yourself.

    if the database is set 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!

    November 5, 2007 at 6:12 pm

    #748462

  • RE: Truncate table based on foreign key relationships

    ok how about this:

    get all the tables in FK hierarchy order; truncate tables with no FK, and for teh rest of the tables that feature foreign keys delete ...

    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!

    November 5, 2007 at 5:01 pm

    #748455

  • RE: Lookup data from another table

    it's just an expansion on the first...you have to join Contacts a second time...to do that, you must ALIAS at least one of the contact table references:

    SELECT Stage3.Stage3ld, Issues.IssueDesc, C1.FirstName...

    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!

    November 5, 2007 at 10:47 am

    #748340

Viewing 15 posts - 12,211 through 12,225 (of 13,460 total)