Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 13,460 total)

  • RE: Finding the Culprit for deleting Linked Server

    Remember the transaction log does not retain any information about WHO performed any operation.

    I cannot see it pointing to the level of detail you are looking for, like object...

    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!

    April 13, 2011 at 11:43 am

    #1311215

  • RE: Database Mail Ip

    the destination mail server? like whatever mail.yourserver.com resolves to? or the ipaddress of the SQL Server Sending the mail to that server?

    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!

    April 13, 2011 at 11:13 am

    #1311195

  • RE: Any draw backs to using Flag 836 with SQL Server 2008 r2 Ent?

    http://support.microsoft.com/kb/920093 (4/13/2011)

    Trace flag 836: Use the max server memory option for the buffer pool

    Trace flag 836 causes SQL Server to size the buffer pool at startup based on the value...

    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!

    April 13, 2011 at 9:46 am

    #1311118

  • RE: Join vs. Function

    yes, exactly...but don't take my word for it; play with this example i just slapped together: you get multiple rows back IF your function returns multipel rows:

    CREATE Function AvailSizes(@ObjectName varchar(30))

    returns...

    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!

    April 13, 2011 at 9:02 am

    #1311073

  • RE: Join vs. Function

    it's kind of confusing, yeah.

    no common data is required between the two.

    I try to think of an ITVF the way UPPER() or ROW_NUMBER() function works: it's going to return something...

    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!

    April 13, 2011 at 8:25 am

    #1311055

  • RE: Finding the Culprit for deleting Linked Server

    I'm afraid you are out of luck, unless you have a separate DML trace running prior to the offense.

    adding and dropping linked servers are not DDL operations, and do not...

    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!

    April 13, 2011 at 8:08 am

    #1311037

  • RE: VS 2008 VB.Net Database Development

    Paul i poke around codeproject.com an awful lot for grabbing .NET examples to adapt to my idea at the time, but I don't have a vb.net oriented forum handy for...

    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!

    April 13, 2011 at 8:01 am

    #1311033

  • RE: Join vs. Function

    glad I could help a little bit; post your scalar function here if you need help converting it to an ILTV;

    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!

    April 13, 2011 at 7:53 am

    #1311029

  • RE: Javacript interface with SQL

    yes and no;

    javascript in and of itself can't do it alone; it requires a postback to the server;

    so you need to either use a form post (submitting the whole aspx...

    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!

    April 13, 2011 at 5:53 am

    #1310954

  • RE: Search Tables for Matching GUID

    Dan's right where whenever GUID's are generated with a newId() function, they are unique, but if the business process was using them for FK equivilents, you can find out easy...

    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!

    April 12, 2011 at 2:52 pm

    #1310708

  • RE: SQL Server 2005 indexed view for non-unique column

    a clustered index does not have to be unique. it just stores the data in the order of the index for the fastest retrieval of the data.

    you are confusing a...

    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!

    April 12, 2011 at 1:16 pm

    #1310646

  • RE: Are cursors bad for iterating through the result set returned by a function?

    pdonley (4/12/2011)

    You have to understand that in the business world, band-aids are what management wants. They don't want me to re-write their system.

    management expects you to use your professional 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!

    April 12, 2011 at 9:50 am

    #1310478

  • RE: Command timeout from .net application

    don't you have to set both the connection timeout and your command object's command timeout?

    this works fo rme for example, waitng 45 seconds to make sure it lasts longer thna...

    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!

    April 12, 2011 at 8:52 am

    #1310438

  • RE: Database size estimation

    heck i'm throwing all sorts of numbers out there; i think i made my numbers extra huge to kick up some dirt so people would say "no! that's too much"

    ok...

    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!

    April 12, 2011 at 8:32 am

    #1310419

  • RE: SUSER_NAME() vs SUSER_SNAME()

    I think you are supposed to use SUSER_SNAME() in most situations.

    i believe the difference is SUSER_SNAME() would return a domain\username for those people who are not explicitly 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!

    April 12, 2011 at 6:52 am

    #1310336

Viewing 15 posts - 7,741 through 7,755 (of 13,460 total)