Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 13,460 total)

  • RE: Problem with a copy of db file on the desktop

    by "damaged" or "corrupt", maybe it's permissions.

    files under /user , like [my documents] and your desktop, are not typically accessible to OTHER users, unless they are admins/domain admins.

    so if 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!

    February 24, 2015 at 8:06 am

    #1779600

  • RE: How are these unique keys generated ?

    mar.ko (2/24/2015)

    Thanks.....

    How does the newid() function work ?

    How does it know to create a unique value for a particular table ?

    Why use a GUID vs. Autonumber/Sequence ?

    well GUID is Globally...

    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!

    February 24, 2015 at 7:21 am

    #1779580

  • RE: How are these unique keys generated ?

    they look like guid/NEWID to me, that have dashes stripped and then lowercased. exactly 32 characters, same as a GUID without dashes.

    /*--results

    PlainOldGuid ...

    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!

    February 24, 2015 at 7:06 am

    #1779574

  • RE: Extract pdf file from a sql db

    certainly possible, but you probably need a bit more information.

    this example here, you could adapt, and is assuming there is an identity/primary key to the table.

    http://stackoverflow.com/questions/26541068/how-can-i-bcp-queryout-with-filename-from-table

    If you can install CLR...

    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!

    February 23, 2015 at 12:31 pm

    #1779385

  • RE: replacing string

    do you want to get just whatever is to the right of the last slash, or just remove /user/?

    /*--results

    Samp1(No column name)

    advisoryadvisory

    Peter/ParkerParker

    Harry/OsbornOsborn

    Mary/Jane WatsonJane Watson

    John/Jonah/Jameson Jr.Jameson Jr.

    */

    create table #MyData

    (

    id int identity(1,1),

    webpage varchar(max)

    )

    insert...

    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!

    February 23, 2015 at 12:06 pm

    #1779376

  • RE: Remove the double quote

    kennyhuang0108 (2/23/2015)

    Thank you Lowell.

    Is there anyway i can eliminate the double quotes from my script?

    thank you.

    there are no double quotes generated in the SELECT statement you posted. there 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!

    February 23, 2015 at 11:58 am

    #1779371

  • RE: Remove the double quote

    whatever you are exporting with has got the text qualifier turned on; just turn it off./ set it to a blank string.

    if you were exporting from SSMS via the export...

    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!

    February 23, 2015 at 11:48 am

    #1779364

  • RE: Resolving Data Drift

    To a degree, it probably depends on the requirements;are the other data centers also gathering data, or are they read only? that kind of decides what methodology to consider. 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!

    February 23, 2015 at 11:42 am

    #1779363

  • RE: SQL Server 2008 - Stored Procedure that triggers another stored procedure

    you can call a procedure within a procedure.

    you have a logical error in your RETURN statmenets; there can be onyl one return:

    CREATE PROCEDURE Adjust_Salary @EmpID INT = NULL, @LatestSalary INT...

    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!

    February 23, 2015 at 10:46 am

    #1779339

  • RE: SQL Agent job not failing when Powershell script errors

    i use powershell + robocopy to copy files, and the format i use will return an error when it occurs; this ight help:

    $SourceLocation = "D:\SQLBackups\";

    $DestinationLocation = "\\gdc-bak-p01\SHARE\CRITICALBACKUPS\HOL\SQL-BACKUPS\HOL-SQL-CL01" ;

    #/E copy directories...

    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!

    February 23, 2015 at 8:40 am

    #1779284

  • RE: How do I get the column type and length. SQL help needed

    SELECT TOP 100 a.name,

    b.name,

    ...

    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!

    February 23, 2015 at 8:34 am

    #1779282

  • RE: Lost access to database

    the full error message would help; my first google for SQL server error 17 seems to imply

    SQL Server does not exist or access denied.

    i'd just assume it's time 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!

    February 23, 2015 at 8:06 am

    #1779269

  • RE: SPLIT A FILE DYNAMICALLY

    why wouldn't a ForEach loop, that dynamically created a folder based on the FileID work?

    then whether it's 10 or 100 FileId's processed, they all go in the logical folder/bucket?

    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!

    February 23, 2015 at 7:14 am

    #1779251

  • RE: Reset all SQL Native passwords across an enterprise

    i don't think you'll find an existing product that does EXACTLY what you are after, but it's a trivial request to do via TSQL.

    there's a zillion examples of random strings...

    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!

    February 23, 2015 at 5:40 am

    #1779230

  • RE: Importing excel file stored in sharepoint into SQL

    can you use a script task to grab a COPY of the file to stick in %temp%, and toggle it's attributes to not be readonly? i had to do something...

    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!

    February 23, 2015 at 5:28 am

    #1779227

Viewing 15 posts - 1,951 through 1,965 (of 13,460 total)