Forum Replies Created

Viewing 15 posts - 11,806 through 11,820 (of 13,460 total)

  • RE: Where is SSMS/SSMS-EE

    you need to find the SQL Server Express 2005 with Advanced Services:

    Microsoft SQL Server 2005 Express Edition with Advanced Services

    that contains the Express version of SS management Studio

    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!

    December 20, 2008 at 8:49 am

    #915745

  • RE: Insert from Multiline Textbox

    i didn't have studio in fromt of me; this is the correct syntax:

    For i = 0 To myArray.Length...

    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!

    December 16, 2008 at 11:33 am

    #913368

  • RE: Insert from Multiline Textbox

    you tried what? you didn't really say what you tried...i doubt you tried using parameters.

    what are you doing? are you expecting that if the Me.textbox1.Text contains 8 lines of data,...

    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!

    December 16, 2008 at 10:30 am

    #913313

  • RE: Insert from Multiline Textbox

    you should always use parameters to prevent sql injection attacks;

    here's what you need to change:

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

    ...

    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!

    December 15, 2008 at 8:31 pm

    #912902

  • RE: Importing data from one server to another

    personally, i think linked servers are the best way to tackle this;

    a link to ServerA allows you to join to serverB , then filter the data based on the join...

    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!

    December 15, 2008 at 6:49 pm

    #912887

  • RE: Database Restore Takes Hours - Is this normal?

    I'd look for two things: how much free disk space is on the server? if it's not much over the size of the restore, that would be an issue, as...

    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!

    December 15, 2008 at 7:22 am

    #912447

  • RE: Copy database shrinks mdf file

    i believe what you are seeing is the difference in the reserved space of the database....

    you can create a new database right now, which is just a copy 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!

    December 15, 2008 at 6:54 am

    #912430

  • RE: Execute a Stored Procedure using SQLXML

    there's an XML Workshop article here [/url] on SSC that shows how to get the number of records in xml, and then loops thru the set, but it depends on...

    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!

    December 12, 2008 at 2:58 pm

    #911937

  • RE: Execute a Stored Procedure using SQLXML

    I'm not sure what you want to do yet either;

    what is in the xml? is it data ro sql commands or what?

    what does your stored procedure do ?

    Are 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!

    December 12, 2008 at 2:51 pm

    #911930

  • RE: Error when Creating a View

    Christopher Stobbs (12/12/2008)

    Looks like the TSQL column is too small you either need to do as Lynn said and disable the triggers or simply alter the table and extend 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!

    December 12, 2008 at 10:27 am

    #911785

  • RE: Use of Coalesce function

    i believe COALESCE requires all parameters to be the same data type, right?

    Coalesce(int,varchar) will fail.

    this fails:

    select(coalesce([Number],' Not Assigned')) from

    (SELECT 1 AS [Number] UNION

    SELECT 2 UNION

    SELECT NULL...

    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!

    December 12, 2008 at 10:23 am

    #911779

  • RE: Error when Creating a View

    I'm with Chris; I'm hitting refresh every 5 seconds to see what we find out next!

    good learning day today!

    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!

    December 12, 2008 at 10:11 am

    #911767

  • RE: Error when Creating a View

    the issue is the audit table's definition;

    can you

    sp_help ddlog

    one of the columns is too small for the desitnation data, causing the trigger to error and rollback, which prevents...

    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!

    December 12, 2008 at 10:04 am

    #911756

  • RE: Error when Creating a View

    ok to see the definition, this works fine:

    select object_definition(object_id) ,*

    from sys.triggers

    where parent_class=0

    i see the type ="TR" And Type_desc = SQL_TRIGGER

    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!

    December 12, 2008 at 9:58 am

    #911748

  • RE: Error when Creating a View

    also, i added my audit just now to a clean database,a nd even though i KNOW the table exists, when i try to sp_helptext the trigger on the database, it...

    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!

    December 12, 2008 at 9:51 am

    #911740

Viewing 15 posts - 11,806 through 11,820 (of 13,460 total)