Forum Replies Created

Viewing 15 posts - 8,026 through 8,040 (of 13,460 total)

  • RE: Object has 2 owners

    what does this return?

    SELECT

    schema_name(6) As schemaName,

    object_name(519060985) As Objectname,

    'EXEC sp_changeobjectowner '''

    + QUOTENAME(schema_name(6))

    + '.'

    + QUOTENAME(object_name(519060985)) + ''''

    AS PotentialCommand

    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 1, 2011 at 11:48 am

    #1293110

  • RE: sql code works fine - front end application is slow?

    is your code a stored procedure which runs quickly when static values are tested in SSMS, but slow when it is called with parameters from the application?

    That's a sign of...

    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 1, 2011 at 11:08 am

    #1293088

  • RE: FIX LENGTH

    to get fixed length, you'll need to convert to CHAR datatypes, so they are padded with spaces.

    something like this maybe?:

    INSERT INTO Tran_file (id,RAW_data)

    SELECT 2 as id,

    'US1'+

    CONVERT(CHAR(8), GETDATE(), 1)+

    '1001'+

    '1'+

    '000'+

    CAST(ORDACR# AS CHAR...

    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 1, 2011 at 8:21 am

    #1292970

  • RE: Adding Extended Properties to a SQL Server Instance (2005+)

    extended properties are stored in a database; so to make any sense i guess you'd store instance information in master, right? that's where i'd add them;

    this worked on my master...

    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 1, 2011 at 7:42 am

    #1292929

  • RE: Database Documentation

    harsha.bhagat1 (3/1/2011)

    Thank you for the reply,

    But I think I am not being able to make clear what I actually want.

    In simple terms I want to document the database into word...

    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 1, 2011 at 6:08 am

    #1292847

  • RE: Database Documentation

    yes, i understood that...

    what i was telling you is compared to what i would call a "normal" process, you are doing it backwards...you put the data in the database, and...

    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 1, 2011 at 6:03 am

    #1292843

  • RE: Database Owner

    In addition to what others have said...

    db_owner is a role, so you could have lots of users as members of that role...and as previously stated, they can do anything 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 1, 2011 at 5:57 am

    #1292839

  • RE: Database Documentation

    additionally, both Enterprise Manager and SSMS GUIS's have the built in ability to add an extended property for ease of use: just go to teh table and select "Design",...

    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 1, 2011 at 5:48 am

    #1292831

  • RE: Database Documentation

    actually, what a lot of people do is to put the data in the database itself by using extended properties...(sys.sp_addextendedproperty / fn_listextendedproperty)

    you can put descriptions up to 255 chars 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 1, 2011 at 5:41 am

    #1292830

  • RE: Usage of ad-hoc SQL Express instances within an organzation

    there was a recent thread on teh same subject:

    http://www.sqlservercentral.com/Forums/Topic1056364-324-1.aspx

    a lot of people reported they lean towards a "don't ask don't tell" policy, so if they don't ask for your expertise...

    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 28, 2011 at 3:45 pm

    #1292633

  • RE: Disappearing DML Triggers

    Rich Yarger (2/28/2011)

    Could it be that this is happening because the version of SQL Server is 2005 Express?

    nope...something is specifically occurring...there's got to be something that is issuing the commands...

    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 28, 2011 at 3:42 pm

    #1292632

  • RE: How do I get this date format?

    i made a simple csv with a bunch of the possible dateformats.

    it looks like using convert with format 109 or 126 is probably best...it leaves the date and time alone...

    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 28, 2011 at 2:56 pm

    #1292613

  • RE: get parent object id in profiler trace

    i'm not sure what you mean by parent object...a trigger, for example, would have the parent_object_id in sys.objects, but i don't think a specific command would have any references 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!

    February 28, 2011 at 2:04 pm

    #1292578

  • RE: How do I get this date format?

    here's a quick example of a bunch of the formats available. sometimes you need to combine some of them togetehr to get exactly what you are after:

    FormattedDate ...

    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 28, 2011 at 12:25 pm

    #1292522

  • RE: why the avatar picture you use

    ok i saw this image on derp.membase and had to switch avatars today. not my dog, but what a pic.

    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 28, 2011 at 11:13 am

    #1292468

Viewing 15 posts - 8,026 through 8,040 (of 13,460 total)