Forum Replies Created

Viewing 15 posts - 5,176 through 5,190 (of 13,460 total)

  • RE: Identify Orphan Data "Data Integrity"

    well, you say you have foreign keys in place, so I'd start with any contraints that are disabled or not trusted:

    SELECT

    name,

    is_disabled,

    is_not_trusted

    FROM sys.foreign_keys

    WHERE...

    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 17, 2012 at 5:46 am

    #1513524

  • RE: Why does the syntax work for insert and not insert into?

    ok i think i see it.

    if you run my previous sample code, including the DROP DATABASE,a dn THEN run the code snippets below, you get a misleading message:

    it's not maintaining...

    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 16, 2012 at 2:01 pm

    #1513299

  • RE: Why does the syntax work for insert and not insert into?

    Lynn Pettis (7/16/2012)

    Lowell (7/16/2012)

    both commands will work perfectly in SSMS;

    are you running this through an ODBC driver, and the driver might be mis-translating the object names?

    where is this code being...

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

    #1513280

  • RE: Why does the syntax work for insert and not insert into?

    both commands will work perfectly in SSMS;

    are you running this through an ODBC driver, and the driver might be mis-translating the object names?

    where is this code being executed?

    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 16, 2012 at 1:21 pm

    #1513271

  • RE: Grouping and Sorting sequential data by street address

    something like this?

    With MyCTE (#ID,RouteID,Seq,BuildingID,StreetName,StreetNr,StreetAddInfo)

    AS

    (

    SELECT '01','D903010','0000','8912200','John Smith','103','13A' UNION ALL

    SELECT '02','D321989','0000','7893738','Mary Clarkson','24','11A' UNION ALL

    SELECT '03','D327298','0000','9436432','Cleveland','1134','72A' UNION ALL

    SELECT '04','D327298','0000','9436432','Cleveland','1134','73A' UNION ALL

    SELECT '05','D674748','0001','6355454','Christina Tyler','67','21B' UNION ALL

    SELECT...

    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 16, 2012 at 1:06 pm

    #1513262

  • RE: Super Simple SQL Front End

    web page with a simple aspx grid, i would think.

    easy to implement, no software to install.

    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 16, 2012 at 11:29 am

    #1513224

  • RE: Optimisation Help Requested

    but if soundex finds any number, or any non a-z,A-Z character, it returns something like "B000" (all zeros), so soundexing on addresses gets meaningless, since most addresses have numbers in...

    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 16, 2012 at 9:51 am

    #1513171

  • RE: What is Code Drop? As a Prod DBA How to work on the Crop Drop in SQL Server

    it sounds like the promotion of a specific set of both database changes and application changes that would occur together, like when an application upgrades from version 1 to version...

    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 16, 2012 at 8:10 am

    #1513092

  • RE: Name the things that were supposed to cause the End Of The World

    Brandie Tarvin (7/16/2012)

    Lowell (7/16/2012)

    And Whatever ever happened to the killer bees that were supposed to kill everyone along the US border as they migrated north?

    I thought that was Bird Flu...

    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 16, 2012 at 8:08 am

    #1513089

  • RE: Name the things that were supposed to cause the End Of The World

    And Whatever ever happened to the killer bees that were supposed to kill everyone along the US border as they migrated north?

    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 16, 2012 at 6:53 am

    #1513034

  • RE: Preventing and Logging DROP DATABASE

    all my DDL triggers are designed as putting the EVENTDATA() into an xml variable, and then querying the xml variable; not a single one of my sample triggers seem to...

    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 16, 2012 at 6:14 am

    #1513022

  • RE: Documentation

    there's a nice anonymous Script submission someone put together to help document a database by generating an html document here on SQL Server Central

    Comprehensive HTML Database Documentation [/url]

    i enhanced...

    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 13, 2012 at 1:21 pm

    #1512699

  • RE: Send Mail to different domain address not working in Database Mail

    that's going to be something you have to get with your exchange administrator to help with. it's not an issue with db_mail; you'll see the same behavior if you sent...

    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 13, 2012 at 11:03 am

    #1512658

  • RE: SQL Server Query

    tinausa (7/13/2012)

    Thanks. I did not think this was necessary info, so I did not mention it earlier.

    But this query is an ASP.NET app where the user will enter from 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!

    July 13, 2012 at 10:54 am

    #1512654

  • RE: collation

    eboucicaut (7/13/2012)

    Server: Msg 468, Level 16, State 9, Procedure SP_TRANS_DECAISSEMENT_EFFECTIF, Line 26

    Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

    somehwere inside your procedure, you are...

    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 13, 2012 at 9:38 am

    #1512624

Viewing 15 posts - 5,176 through 5,190 (of 13,460 total)