Forum Replies Created

Viewing 15 posts - 9,301 through 9,315 (of 13,460 total)

  • RE: Permission question

    you did not really provide any definitive requirements; your procedure is unnamed and your fourtables are pseudo names(TABLEA,etc)

    here is some pseudo code that is the basics of what i think...

    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!

    June 4, 2010 at 5:44 am

    #1176456

  • RE: Carriage return in xp_sendmail

    i bet the email is sent as html, and since html does not respect CrLf/Lf, you should substitute the <br /> instead:

    Set @Job = 'The following opportunity has been changed...

    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!

    June 3, 2010 at 10:51 am

    #1176084

  • RE: sa user login attempts

    uggg....you have a SQL server exposed directly to the internet? At our shop, we have a web server that is exposed to the internet, and it connects to a SLQ...

    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!

    June 3, 2010 at 8:37 am

    #1175993

  • RE: Store calculations in a table or use computed columns?

    the devil is in the details, but here's my two cents:

    use computed columns or a view which does the computation for you whenever possible.

    i don't know if you've ever tried...

    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!

    June 3, 2010 at 8:26 am

    #1175982

  • RE: Permission question

    denying UPDATE at the table level prevents "smith" from directly updating your table with the statement UPDATE TableB SET somevalue = ''

    if smith should not update tableB, he should...

    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!

    June 3, 2010 at 7:52 am

    #1175959

  • RE: Permission question

    also using roles is the recommended best practice for assigning permissions. If you do not want to use them, it's more likely you are not familiar with how useful they...

    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!

    June 3, 2010 at 7:45 am

    #1175951

  • RE: Permission question

    permissions are not cross checked the way you are thinking.

    this is working by design...an example might be you do not want "smith" to touch the tables directly, and only thru...

    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!

    June 3, 2010 at 7:41 am

    #1175947

  • RE: SQL Server: How do I ignore errors on a view creation?

    Sorry, it's not possible with a view.

    in SQL Server, only a procedure can be created where the objects it uses do not exist yet;

    everything else...tables with foreign keys, views 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!

    June 2, 2010 at 8:13 pm

    #1175654

  • RE: Audit stored procedures and functions?

    halifaxdal (6/2/2010)

    One thing missing here: is it possible to find out the last modified user? who made the last change? It seems not included in the sys.objects table. I do...

    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!

    June 2, 2010 at 2:43 pm

    #1175580

  • RE: .mdf 56GB TOO BIG HELP

    adding to what Gail said, here's screenshots of where in SSMS to see how much you could release by shrinking the database.

    you might want to move any existing backups off...

    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!

    June 2, 2010 at 12:44 pm

    #1175508

  • RE: Audit stored procedures and functions?

    halifaxdal (6/2/2010)

    Hi folks,

    I am just wondering if there is a way to track the usage of stored procedures and functions in SQL 2005? I want to know how many times...

    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!

    June 2, 2010 at 12:09 pm

    #1175490

  • RE: Selecting the latest dated record containing a value

    awesome Aaron;

    sometimes just a shove in the right direction gets you rolling;

    i had a brain block exactly like that last week, where i knew how to do something, but 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!

    June 2, 2010 at 11:09 am

    #1175446

  • RE: Selecting the latest dated record containing a value

    here you go Aaron;

    teh trick you want is to use hte ROW_NUMBER() function; that can give you "partitioned" results per PatientID, for example.

    if you can in the future, if...

    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!

    June 2, 2010 at 9:44 am

    #1175382

  • RE: Not enough storage is available to complete this operation

    take a look at this thread: someone was running into a similar situation:

    http://www.sqlservercentral.com/Forums/Topic930970-149-1.aspx

    without seeing your specific query against the linked server, i bet it is the same issue:

    i know...

    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!

    June 2, 2010 at 9:15 am

    #1175367

  • RE: Error 7399 - Resource limit was reached

    ok i know linked server queries are slow because if you join a local table to a remote table, the entire remote table is downloaded into local temp, and then...

    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!

    June 2, 2010 at 7:48 am

    #1175289

Viewing 15 posts - 9,301 through 9,315 (of 13,460 total)