Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 13,460 total)

  • RE: Options to pass encrypted creds from SQL 2012 to Oracle on Unix?

    not sure if this helps at all, but i have a similar situation.

    would mapping a network drive featuring specific username/password help?

    exec master.dbo.xp_cmdshell 'NET USE J: \\DEV223\c$\Data /user:mydomain\lowell NotMyRealPassword /persistent:yes'

    i've got...

    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!

    June 4, 2014 at 6:07 am

    #1718787

  • RE: Create a table name from 2 or more strings

    not directly like that.

    you have to switch to dynamic SQL to convert value s(ie a column value) to the metadata of an object name

    your query qould create this code, is...

    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!

    June 3, 2014 at 8:48 am

    #1718568

  • RE: set page verify for all databases

    i still have my SQL 2000 scripts saved, although i don't play with 2000 any more.

    there's some server functions DATABASEPROPERTY and DATABASEPROPERTYEX that can pull the values you want ,...

    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!

    June 2, 2014 at 5:43 am

    #1718160

  • RE: Script To Specify The Date Field To Use For "Activity Date"

    Matt J (6/2/2014)

    Hi,

    I'm writing a view to check record counts in a table that has numerous datasets and therefore various "Activity Dates". Is it possible as part of the 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!

    June 2, 2014 at 5:24 am

    #1718152

  • RE: DB concurrency how to....

    change your thought process: the end user never tells YOU what the purchase order number is.

    a user requests a new purchase order number, and you assign it.

    that purchase order number...

    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!

    May 31, 2014 at 8:14 pm

    #1718051

  • RE: Reset password to unknown password

    what is the actual reason you cannot simply use the new password, or set the password yet again?

    it seems kind of strange you think you need to restore it, maybe...

    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!

    May 30, 2014 at 1:33 pm

    #1717935

  • RE: Reset password to unknown password

    yes i believe that's about all you can do.

    the password is stored in a credential, which you can partially review in master.sys.credentials.

    It is not possible to script(even in a hashed...

    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!

    May 30, 2014 at 1:32 pm

    #1717934

  • RE: Script Out Database Mail Settings?

    Thanks for the feedback Charles! It still gives me that warm feeling of a job well done when someone says i helped them.

    I think this one has been 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!

    May 30, 2014 at 1:24 pm

    #1717932

  • RE: Specific table update

    where did the 1449 come from? is it just your arbitrary starting point?

    it doesn't exist or seem to be calculate-able from what you posted.

    is the 2008/ portion going to come...

    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!

    May 27, 2014 at 3:01 pm

    #1716864

  • RE: collation issues

    yeah the last time i had to fiddle with that situation, I had to edit any procedures which happen to also use temp tables;

    i reviewed any joins and WHERE statements...

    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!

    May 27, 2014 at 1:51 pm

    #1716846

  • RE: collation issues

    yes it will work.

    you might run into some issues in cross database queries , and maybe some queries that spool to tempdb, but you can easily keep your old databases...

    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!

    May 27, 2014 at 1:40 pm

    #1716841

  • RE: collation issues

    collation is saved on a per-column basis...if you copy a database, the collation of individual columns stays at whatever it was, regardless of whether you change the Server or database...

    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!

    May 27, 2014 at 1:20 pm

    #1716834

  • RE: Order by desc for specific date

    something like this help a little?

    ORDER BY

    CASE

    WHEN datepart(mm,startdate) = 7

    AND datepart(dd,startdate) = 1

    THEN 1

    ELSE 99

    END

    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!

    May 27, 2014 at 12:24 pm

    #1716795

  • RE: Importing multiple .txt files into one table - no SSIS

    koyyatrouser (5/26/2014)

    Hi ..

    I have tried the code. But the whichfile column doesnt populate the file name. Its showing access denied.

    Can you please help ?

    Access denied is typically because the account...

    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!

    May 26, 2014 at 7:44 pm

    #1716564

  • RE: Advice sought....populating a DEV copy of the database

    RedBirdOBX (5/23/2014)

    That sounds like a plan! Could you please explain how you "i script out the DDL differences between the developers' version, and production"?

    Thanks a million!

    There's lots of tools 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!

    May 23, 2014 at 8:30 pm

    #1716295

Viewing 15 posts - 2,296 through 2,310 (of 13,460 total)