Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 13,460 total)

  • RE: Converting Datetime2(0) to Datetime

    just guessing here, converting zero to datetime is allowed; converting zero to datetime2 isnot.

    select CONVERT(datetime,0)

    select CONVERT(datetime2,0)

    Msg 529, Level 16, State 2, Line 1

    Explicit conversion from data type int to datetime2...

    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!

    July 20, 2012 at 10:45 am

    #1515647

  • RE: Books on Disk Subsystem

    for best practices , this is a really good reference:

    Troubleshooting SQL Server: A Guide for the Accidental DBA

    by Jonathan Kehayias and Ted Krueger[/url]

    Simple-talk also has a collection of books,...

    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!

    July 20, 2012 at 7:11 am

    #1515505

  • RE: TCP/IP port on SQL server 2005

    unless you obscured the items you pasted for security reasons, it looks like you have two instances installed:

    SQLLocal\INSTANCE05,5678

    SQLLocal\INSTANCE02,2932

    so you should be able to conect to either of them by...

    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!

    July 20, 2012 at 6:20 am

    #1515477

  • RE: Please Give Me the Query For Below Mentioned Resultant Tables.

    nice first post, you provided quite a bit of info.

    my first point, is in the future, if you can provide your data as CREATE TABLE / INSERT INTO statements like...

    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!

    July 20, 2012 at 6:11 am

    #1515472

  • RE: Grant permission to access only 2 tables in a database

    sufiyan.sarguroh (7/20/2012)

    This does give access to only two tables , but does this prevent him from viewing the SPs and views ? Does it have to be done explicitly .

    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!

    July 20, 2012 at 4:30 am

    #1515404

  • RE: sys.dm_exec_query_plan question

    could it be that really large execution plans are getting truncated at 8K in the grid,and since it's not valid XML with an ending tag, you only see the text...

    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!

    July 19, 2012 at 3:32 pm

    #1515212

  • RE: Help the query

    i tried pasting your code in SQLserver management studio, and it gives errors;

    are you working in another language, or did you paste pseudocode?

    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!

    July 19, 2012 at 1:01 pm

    #1515120

  • RE: Help the query

    ranganathanmca (7/19/2012)

    Thanks for your reply,

    Actually i am passing the product id only so if 2 sub product we are getting 2 set of results, i need to avoid those type...

    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!

    July 19, 2012 at 12:34 pm

    #1515100

  • RE: Help the query

    my wild guess:

    SELECT *

    FROM [mainproduct]

    LEFT OUTER JOIN [subproduct]

    ON [mainproduct].mainproduct_id = [subproduct].mainproduct_id

    LEFT OUTER JOIN [product]

    ...

    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!

    July 19, 2012 at 12:15 pm

    #1515081

  • RE: How Many type of Function in SQL Server ?

    ok, so my answer is D. Seven function types. Final Answer.

    (...waiting for the failure buzzer.....)

    my thinking is there are the Built in functions plus these six others.

    AF = Aggregate function...

    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!

    July 19, 2012 at 11:43 am

    #1515061

  • RE: check collation settings

    sqlfriends (7/19/2012)

    Thanks, I know how to check collation from SSMS and code.

    I cannot connect to this server somehow from other SSMS client.

    And on the server itself no SSMS installed, there...

    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!

    July 19, 2012 at 10:59 am

    #1515016

  • RE: Recode 2008 Code to 2005 Code

    there's not very many differences between 2005 and 2008; first make sure the compatibility level on the target database really is 9.0/90 if it is 2005. you might be hitting...

    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!

    July 19, 2012 at 10:56 am

    #1515012

  • RE: check collation settings

    just tested this, seems to give what you asked for:

    select SERVERPROPERTY('Collation') As ServerCollation,

    name As DatabaseName,

    collation_name As DatabaseCollation

    from master.sys.databases

    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!

    July 19, 2012 at 10:51 am

    #1515005

  • RE: Restore Copy of Live DB to Production Server?

    Daxesh Patel (7/19/2012)[hr

    Hi Lowell,

    I have a question, did you restore existing database (replaced existing from backup) in your test or created new database from backup?

    Just curious

    Thanks in advance

    i tested 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!

    July 19, 2012 at 9:31 am

    #1514942

  • RE: Send Mail Fails when Exchange Server is unavailable...

    what you are asking is already built into the mail service on SQL.

    the service broker for mail automatically retries when the mail server is unavailable;

    you might want to change 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!

    July 19, 2012 at 9:27 am

    #1514938

Viewing 15 posts - 5,131 through 5,145 (of 13,460 total)