Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 13,460 total)

  • RE: check constraint

    integers,decimals, numerics and floats data types don't have preceding zeros, so no preceeding zero would be correct for those data types.

    you said numeric, but are you SURE they are numerics?...

    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!

    October 26, 2012 at 2:32 pm

    #1553402

  • RE: SQL Error The server principal '' is not able to access the database '' under the current security context

    when you restore a database on a different server, the users in the database become Orphaned, because the SID inside the database is not the SID that exists 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!

    October 26, 2012 at 1:26 pm

    #1553366

  • RE: Connot connect to server via name but IP works, not a SQL Browser service issue :)

    not sure if this helps yet, but i think the issue is a WINS issue when you cannot resolve by name;

    For example if you enter SERVER04 instead of a FQDN...

    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!

    October 26, 2012 at 12:57 pm

    #1553353

  • RE: Parsing out email address in FROM field

    well, if your data is split with semicolons or some known string,, then you could split it with the DelimitedSplit8K function.

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    With tblDoc([FROM])

    AS

    (

    SELECT 'John Doe1 <John.Doe1@abcd.com>' UNION ALL

    SELECT 'John Doe2 <John.Doe2@abcd.com>'...

    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!

    October 26, 2012 at 10:51 am

    #1553309

  • RE: exec @sql

    put the variable string in parenthesis:

    exec (@sql)

    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!

    October 26, 2012 at 9:39 am

    #1553264

  • RE: I would like to be able to trace who or what process made a change to a stored procedure

    the default trace keeps a short list of recent changes;

    if not too much time has passed, you can find out who did any changes and when:

    easiest way is directly...

    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!

    October 26, 2012 at 9:36 am

    #1553262

  • RE: WOSYST database to a SQLserver db

    just the raw MYSQL database file all by itself, no.

    you need a mysql instance running so you can connect to the database.

    you might need to install MYSQL and attach that...

    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!

    October 26, 2012 at 9:33 am

    #1553258

  • RE: SQL query needed for locating specific text criteria

    an example of what we need to try and help you:

    --REQUIRED DDL

    --DROP TABLE [dbo].[SAMPLETABLE]

    CREATE TABLE [dbo].[SAMPLETABLE] (

    [NO] ...

    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!

    October 26, 2012 at 9:30 am

    #1553252

  • RE: Corrupt table in master

    depending on the results of this command, we might be able to tell you if you can do anything; whether it's a repair or a re-install/rebuild of master:

    post teh entire...

    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!

    October 26, 2012 at 9:04 am

    #1553235

  • RE: != NOT EQUAL TO Query

    jbulldog (10/26/2012)

    When I INNER JOIN all my tables (6) I pull all the records for a specific region which already have the field data I am querying to see...

    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!

    October 26, 2012 at 7:30 am

    #1553164

  • RE: Id of most recent login?

    blacklabellover2003 (10/26/2012)

    Hi all,

    I have an orphaned .mdf + .ldf fileset on our production box, I know how to attach them.

    But I also need to find out who the last user...

    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!

    October 26, 2012 at 7:28 am

    #1553162

  • RE: How to copy a System Stored Procedure to another server

    can the two servers see each other, like on the same network or anything like that?

    you could set up replication for preocedures, but i'm not sure the master database can...

    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!

    October 26, 2012 at 7:23 am

    #1553160

  • RE: How to copy a System Stored Procedure to another server

    if you've created your own procedures, and then marked them as system procs, it's easy.

    1.you still script them like always (sp_helptext procname, or script them in the GUI.

    2.Create them 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!

    October 26, 2012 at 6:51 am

    #1553138

  • RE: SQL Schema Foreign key Relationships Diagram

    exec sp_fkeys TableName will list all the relations for a single table, if you want to use that as a basis for a script.

    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!

    October 26, 2012 at 6:27 am

    #1553131

  • RE: != NOT EQUAL TO Query

    I think the core issue is parenthesis.

    Because of the other two conditions the results still have the values he was trying to filter out.

    and/and/or needs to be handled ,

    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!

    October 26, 2012 at 3:39 am

    #1553076

Viewing 15 posts - 4,486 through 4,500 (of 13,460 total)