Forum Replies Created

Viewing 15 posts - 7,021 through 7,035 (of 13,460 total)

  • RE: Insert multiple column data into Another table using Trigger

    also, your example tables are all in Oracle syntax....a trigger in Oracle looks and behaves differently than SQL.

    Oracle is all row based, where SQL is set based.

    show us what you've...

    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!

    August 2, 2011 at 1:17 pm

    #1362540

  • RE: Cell Level Encryption/Decryption

    Laura_SqlNovice (8/2/2011)

    when creating Symmetric key with Certification do I have to create certificate for every users who will access the data column?

    nope...typically you create one cert and use it everywhere....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!

    August 2, 2011 at 12:52 pm

    #1362508

  • RE: Problem Query

    well first that's not just one query...i count 15 queries, the one at the end is pretty huge.

    maybe you could pull a specific query out that is giving you an...

    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!

    August 2, 2011 at 9:38 am

    #1362270

  • RE: roles and responsibilities of sql dba

    http://www.sqlservercentral.com/articles/Administration/dbaroles/517/

    http://www.sqlservercentral.com/articles/Administering/thevalueofadba/1806/

    http://www.sqlservercentral.com/articles/State+of+the+Business/deathoftheproductiondba/432/

    http://www.sqlservercentral.com/articles/Certifications/3176/

    http://www.sqlservercentral.com/articles/Miscellaneous/2989/

    Daily Tasks

    The following tasks should be completed on a daily basis:

    Check to make sure the SQL Server is still online and that you still have connectivity.

    Check the NT and 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!

    August 2, 2011 at 9:15 am

    #1362242

  • RE: Cell Level Encryption/Decryption

    --supposed we have a table

    CREATE TABLE WebUsers (

    UserName varchar(100),

    UserEmail varchar(100),

    UserPass varchar(100)

    )

    --and some data

    Insert into WebUsers

    SELECT 'Lowell','lowell@somedomain.com','NotMyRealPassword' UNION ALL

    SELECT 'Calvin','Calvin@somedomain.com','G.R.O.S.S.' UNION ALL

    SELECT 'Hobbes','Hobbes@somedomain.com','Calvins Friend'

    --now we want to encrypt 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!

    August 2, 2011 at 7:55 am

    #1362162

  • RE: Database Mail - No Message-ID in Header?

    PaulSp (8/2/2011)

    Thanks very much for this.

    As I am new to Database Mail (as you can obviously tell) - can you suggest which settings I need to amend...

    As far...

    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!

    August 2, 2011 at 7:25 am

    #1362143

  • RE: Cell Level Encryption/Decryption

    Laura those articles go into some really good detail on how to use encryption, and do a better job than i can at explaining .

    As for database changes, it depends...

    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!

    August 2, 2011 at 5:59 am

    #1362066

  • RE: grant users with read access to 20 databases

    ashok.faridabad1984 (8/2/2011)

    add the add group to the db_reader role across all the servers.

    I find it the easiest way to do that.

    Hi Can you please let us know how 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!

    August 2, 2011 at 5:47 am

    #1362061

  • RE: Cell Level Encryption/Decryption

    these two links are my favorite introductions to 2005 and up encryption; i found the article very easy to follow:

    http://www.databasejournal.com/features/mssql/article.php/3714031/SQL-Server-2005-Encryption-types.htm

    http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

    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!

    August 1, 2011 at 9:18 pm

    #1361946

  • RE: Cell Level Encryption/Decryption

    Laura in SQL 2000, there was no built in encryption, you had to use extended procedures.

    When i was using SQL2000, i used the dba toolkit from SQL Server Central:

    http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/

    you could...

    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!

    August 1, 2011 at 8:43 pm

    #1361939

  • RE: find which query execuitng taking longer than 10 s

    i think you have to wait until something is executed first...it may have completed a second ago, but i don't think the dmv will return what is currently executing, just...

    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!

    August 1, 2011 at 7:52 pm

    #1361932

  • RE: Database Design for Storing Recipes

    I'd think GSquared prototype is right as far as the tables go, but I'd be concerned with data population after it was created.

    I'd think that based on the way I've...

    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!

    August 1, 2011 at 2:38 pm

    #1361847

  • RE: find which query execuitng taking longer than 10 s

    this will show you any queries that are in the DMV cache that ever had a elapsed time of more than 15 seconds.

    you could refine it from there, but this...

    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!

    August 1, 2011 at 2:17 pm

    #1361832

  • RE: Do not display "1900-01-01 00:00:00.000"

    will the column support NULLS? if it can, you could update the data to be null where the column is that value.

    it really depends on the table and the columns'...

    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!

    August 1, 2011 at 12:47 pm

    #1361778

  • RE: Do not display "1900-01-01 00:00:00.000"

    where is that displaying?

    zero (0) is SQL's starting date of 1900-01-01, so i suspect that either your query or your application is converting null to zero,a dn displaying that converted...

    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!

    August 1, 2011 at 12:37 pm

    #1361768

Viewing 15 posts - 7,021 through 7,035 (of 13,460 total)