Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 13,460 total)

  • RE: Symmetrically encrypt a single node in XML field

    i found this interesting, and am about 90% there with an example solution.

    my problem is if there is a text representation of a binary string in the xml, how do...

    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 1, 2014 at 6:21 am

    #1710077

  • RE: Finding Position Plain text inside html markup using SQL

    there's probably more to the question, but the charindex function finds the starting position of a string within another string.

    DECLARE @FindPharase varchar(max) =' I would like to thank whomever<span style=\""font-family:courier\">...

    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 1, 2014 at 5:30 am

    #1710067

  • RE: XML is 17GB on disk... 4MB when cast as varchar(max)

    my first guess: the table is a heap, and does not have a clustered index.

    in the case of a heap, if you update data, or delete and reinsert individual rows...

    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!

    April 30, 2014 at 11:17 am

    #1709938

  • RE: Backup .bak to My PC Local drive?

    there's an exisitng option for the COPYTO='\\jons-laptop\SharedFolder\SQLBackups\' that is already a part of Native Sql backups,as well as litespeed and redgate backups.

    can't you just add that to your backup command,...

    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!

    April 30, 2014 at 10:43 am

    #1709925

  • RE: Insert triggers updating an audit table

    as long as you bullet proofed the code to make sure all tables already exist, your trigger is pretty close to working, but it must be a FOR TRIGGER, not...

    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!

    April 29, 2014 at 12:28 pm

    #1709595

  • RE: SSMA to migrate data from oracle to sqlserver

    in the SSMS grid, in order to force visibility of the data , for display purposes only,Carriage Returns and Line Feeds are turned into spaces; however the data truly still...

    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!

    April 29, 2014 at 11:12 am

    #1709568

  • RE: Am using Windows Server 2008R2,In this C:/ Drive Space getting increase

    without more details, all we can do is guess.

    the most likely culprit is you have databases that have the recovery model set to FULL, but are failing to take regular...

    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!

    April 29, 2014 at 6:28 am

    #1709411

  • RE: BCP Command, Error - Login failed for user

    you'd probably be much better off using BULK INSERT over bcp + xp_cmdshell anyway:

    --in via bulk insert

    BULK INSERT INV_StageTable FROM 'c:\Test\Aut_2014-04-22.csv'

    ...

    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!

    April 29, 2014 at 6:14 am

    #1709403

  • RE: BCP Command, Error - Login failed for user

    you cannot pass a windows username and password. it's just not allowed.

    you can pass a SQL username and password, or use the -T for trusted connection, which uses...

    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!

    April 29, 2014 at 6:10 am

    #1709400

  • RE: General Script or Method to Query/Report Permissons for a SQL Server Instance

    there are quite a few script contributions here on SSC; some are detailed, some script out as commands, some are more overview/report like, so it really depends on what 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!

    April 28, 2014 at 9:55 am

    #1709219

  • RE: Syntax error

    a4apple nailed it: your inner quote needs to be double single quoted to work, or remove the single quotes to allow comparison to an integer.

    :

    use msdb

    if exists

    (select sysjobs.name as...

    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!

    April 28, 2014 at 8:24 am

    #1709189

  • RE: Need set based method to insert missing records into table - right join doesn't work

    well, as you can see from my example code, i generated my best guess from the existing data.

    you can do the same, obviously; i would assume that somewhere, someone has...

    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!

    April 28, 2014 at 8:17 am

    #1709184

  • RE: how to add Aggregated Transform as a new column

    the best way is to create a view, which would calculate that information on demand.

    Best practice is to never add a column containing agregates in a table row, since...

    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!

    April 28, 2014 at 7:22 am

    #1709156

  • RE: Where do I find Microsoft.SqlServer.Management.IntegrationServices.dll?

    my screenshot is from a Win7 machine that had the SQL 2012 Developer Edition, with the full suite of SQL + SSAS/SSIS/SSRS installed.

    no extra SDK's or anything, AFAIK.

    i'd think 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!

    April 28, 2014 at 7:09 am

    #1709150

  • RE: Database collation Change

    changing the collation of the database is only a tiny 1% piece of the puzzle.

    every varchar/char/nvarchar/nchar/text column in the database has it's own collation, that is not affected just because...

    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!

    April 28, 2014 at 6:44 am

    #1709141

Viewing 15 posts - 2,341 through 2,355 (of 13,460 total)