Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 13,460 total)

  • RE: Insert - Row or table level locking

    i believe locking on insert will depend on the PK of your table, and clustered indexes, if any., and how many rows you are inserting.

    if you have an identity column...

    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 24, 2016 at 10:24 am

    #1874133

  • RE: SSIS Packages Job fails no information in Job History

    you should still check what i mentioned.

    last run status can still be seen in Job Activity Monitor with a big red X, but the history could be erased.

    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 22, 2016 at 1:25 pm

    #1874028

  • RE: Default Value RAND issue

    multi row inserts will insert the same default value form RAND() for all rows in the insert statement.

    is that ok? (oops! tip of the hat to Jacob, who noticed 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!

    April 22, 2016 at 12:44 pm

    #1874008

  • RE: SSIS Packages Job fails no information in Job History

    check to see how long your history retention is; it could easily have been written, but aged out by the time you look at it.

    if it is still a 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!

    April 22, 2016 at 12:38 pm

    #1874004

  • RE: Issue sending or receiving email from SQL Server

    it's been a while on this thread, but i had this occurred to me twice since i last followed up on this;

    here's some notes i took about the service broker...

    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 21, 2016 at 2:54 pm

    #1873787

  • RE: Get DDL for any SQL 2005 table

    I'm guessing it has something to do with collation.

    can you run these commands, and report what the values are?

    with that, i could replicate the issue, ib et:

    select databasepropertyex(db_name(),'collation')

    select databasepropertyex('master','collation')

    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 20, 2016 at 12:17 pm

    #1873432

  • RE: Get DDL for any SQL 2005 table

    bgrossnickle are you using the original code fromt eh article, or the updated code from the discussions here?

    over the years, we've made a lot of improvements; your example table...

    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 20, 2016 at 9:31 am

    #1873389

  • RE: Connect to an Analysis Services cube from SSMS

    you can also do a shift + Right Click on the item to get a Run As Different User context,w here you can put in the other domain credentials.

    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 20, 2016 at 5:51 am

    #1873275

  • RE: Restrict Access to Excel Work Book using powershell

    limiting access to an existing workbook would simply be permissions on a file share, right?

    I don't think you need powershell for that, just assign the right permissions to a folder...

    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 19, 2016 at 5:39 am

    #1873009

  • RE: Regex pattern is throwing error when i'm using it in where Clause

    you posted in SQL2008 forum, so my questions are for that platform. i think you might be posting a MySQL question in a SQL Server centric forum though.

    Since SQL 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 18, 2016 at 2:23 pm

    #1872900

  • RE: Many to Many Relationship - Healthcare Diagnosis

    did you already grab the General Equivilency Mapping stuff?

    https://www.cms.gov/medicare/coding/icd10/2015-icd-10-cm-and-gems.html

    your example is a great one how codes don't have exact equivelents

    in the file for ICD9 to OCD10, 250.00 maps to E11.9,...

    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 18, 2016 at 10:50 am

    #1872835

  • RE: Timeouts in SQL Server 2008 r2 Clustered Environment

    GonnaCatchIT (4/15/2016)

    Thanks for the inputs.

    I tried increasing the timeout to a 1 hour , but still get the same issue.

    If the Query plans are being generated differently on 2 environments....

    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 18, 2016 at 10:31 am

    #1872824

  • RE: SQL Help Please

    we can't help you with homework, but if you have specific questions you can't seem to get right, if you show us what you've done,we can offer suggestions.

    If i...

    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 18, 2016 at 5:26 am

    #1872702

  • RE: IF EXISTS still running subquery when column not found

    the If does not shortcut the validation for objects and columns. all objects must exist before the statement executes. you see the smae behavior if you have an ADD column...

    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 15, 2016 at 1:23 pm

    #1872500

  • RE: Accessing Reports via Server Name

    i think it's related to permissions; a lot of the time someone might get a permissions error that says

    "User does not have required permissions. Verify that sufficient permissions have...

    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 15, 2016 at 1:18 pm

    #1872497

Viewing 15 posts - 1,111 through 1,125 (of 13,460 total)