Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 13,460 total)

  • RE: Importing Access Database table data using Stored Procedure

    SQLRNNR (7/30/2012)

    Which version of ACE drivers?

    for me, I was trying to use ACE 12.0 drivers, which i know i installed, and can use for Excel xlsx files via openrowset so...

    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 30, 2012 at 1:09 pm

    #1519368

  • RE: How to get sql server ip address

    edit: when i did ping /? from a command line, i do not see a -o option.

    in 2008 and above, you can get it from some of the DMV.s or...

    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 30, 2012 at 12:55 pm

    #1519359

  • RE: Importing Access Database table data using Stored Procedure

    on a similar note, has anyone gotten a linked server or openrowset command to work on 64 bit / ACE drivers?

    I see there is a connect item on it with...

    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 30, 2012 at 12:48 pm

    #1519355

  • RE: Monitoring Changes to Users in databases.

    which is actually being dropped, the login in sys.server_principals, or the user in databasename.sys..database_principals?

    if it is databasename.sys..database_principals, is the database being restored every quarter, by chance?

    if the backup doesn't contain...

    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 30, 2012 at 12:32 pm

    #1519347

  • RE: SQL Server 2008R2 using more memory

    that's normal and by design.

    SQL tries to keep everything in memory in order to better serve multiple requests for the same data.

    unless you tell it otherwise, SQL uses all 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 30, 2012 at 11:48 am

    #1519330

  • RE: Bogus Error Droping a creating Tables

    could your script be multiple commands, and you are adding the same table twice?(and maybe dropping it once.

    you seem to be on the right track as far as looking...

    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 30, 2012 at 11:15 am

    #1519314

  • RE: filter out values are not integer or null

    IsNumeric tests to see if the string matches any of a number of specific patterns for all sorts of data types.

    select isnumeric('3e0'),isnumeric('3,4'),isnumeric('$23,454')

    '18' is certainly convertable an integer, for example...did you...

    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 30, 2012 at 10:56 am

    #1519306

  • RE: filter out values are not integer or null

    select * from the table where the model not like '%[^0-9]%'

    that will filter out anything that has anything that is not in the range of 0-9 characters; so punctuuation,...

    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 30, 2012 at 10:38 am

    #1519284

  • RE: Can too many comments slow down stored procedure?

    maw74656 (7/30/2012)

    Are you suggesting there is no point where too many comments can slow it down, or that the point is so large its impractical to consider? What 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!

    July 30, 2012 at 10:11 am

    #1519266

  • RE: Permissions on Service Account

    the hiccup there, as you identified, is when files exist on the network, and not the local disk.

    The system account is one of those special accounts that never logs into...

    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 30, 2012 at 10:03 am

    #1519259

  • RE: Data Deletion in DB

    a server side DML trace is lightweight amd can provide the whodunnit info, but not the rollback of changes.

    For me, i think having a DML trace that rolls over...

    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 30, 2012 at 8:00 am

    #1519153

  • RE: How to add alohanumeric before ID

    the way i've always handled this situation is to continue to use an identity field, but adding a persisted calculated field that creates the desired alphanumeric based on a concatenation...

    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 30, 2012 at 6:33 am

    #1519111

  • RE: eventdata() - rename

    looking again, i think there is a TargetObjectName in the RENAME schema.

    -<xs:complexType name="EVENT_INSTANCE_RENAME"> -<xs:sequence>

    <!-- Basic Envelope -->

    <xs:element type="SSWNAMEType" name="EventType"/>

    <xs:element type="xs:string" name="PostTime"/>

    <xs:element type="xs:int" name="SPID"/>

    <!-- Server Scoped DDL -->

    ...

    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 2:21 pm

    #1515752

  • RE: eventdata() - rename

    looks like you are looking at the right tag, i think. maybe it's int he AlterTableActionList?

    http://schemas.microsoft.com/sqlserver/2006/11/eventdata/

    inthe ALTER_TABLE events,

    here's the XML tags:

    -<xs:complexType name="EVENT_INSTANCE_ALTER_TABLE"> -<xs:sequence>

    <!-- Basic Envelope -->

    <xs:element type="SSWNAMEType" name="EventType"/>

    <xs:element...

    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 2:11 pm

    #1515751

  • RE: i am a newbie . help me to learn sql server

    the Stairways series is a great start:

    http://www.sqlservercentral.com/stairway/

    there is a LOT of different subjects, and they build up in complexity and understanding as you go through each stairway.

    I'd recommend starting 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 20, 2012 at 11:15 am

    #1515667

Viewing 15 posts - 5,116 through 5,130 (of 13,460 total)