Forum Replies Created

Viewing 15 posts - 1 through 15 (of 64 total)

  • RE: Hassle free parameters in dynamic sql.

    Jonathan AC Roberts (5/15/2014)


    ...but if the entry of the parameters is from an external input, e.g. a web page, then it could be vulnerable to SQL injection - something that...

  • RE: OPENROWSET with UNC works from server, not from client

    MG-148046 is right.

    ...but I can tell what the issue is. Kerberos multiple hops. You are starting from your client connecting to server 1 and then trying to connect to server...

  • RE: Symmetric Key Use

    I hate to be picky, but:

    if exists (select * from sys.openkeys where key_name={key_name})

    close symmetric key {key_name}

    If you try to close it twice by accident, you get an error:

    (The key {key_name}...

  • RE: Create batch file to selectively run SQL files

    This should work if you run it from the folder where your files are, quick and dirty:

    for %%R in (*.sql) do sqlcmd -i "%%R" -S {server_name} -U {user} -P {pwd}...

  • RE: Joining where values do not equal one another

    You can insert the value pairs in the temp table (or a permanent one, if you do this on a regular basis):

    declare @t table (t1 varchar(16),t2 varchar(16))

    insert @t values ('1001099548','1001099550')

    insert...

  • RE: Sql Server 2008 R2 data base sharing issue

    This might help you, I scripted it out. Run it through the other account where you can see the DB.

    USE [master]

    GO

    CREATE LOGIN [domain\your_domain_account] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    GO

    USE [your_DB]

    GO

    CREATE USER [domain\your_domain_account(or...

  • RE: checking database permissions from master

    I'm afraid, you need to be in 'sysadmin' role to do that. Check 'print user_name()' and see what permissions that login has.

  • RE: Problem with concurrent insert into a partitioned table

    mr_effe (4/23/2014)


    Hi,

    Yes perhaps it could work over the indirect way by a temp table and switch partition. But the problem exists not only for one process. There are many other...

  • RE: Problem with concurrent insert into a partitioned table

    Is there a reason why not do it like this (not that it'll make any difference in the locking)?

    INSERT INTO t_target

    SELECT 1 as pa_Attribut

    ,id

    ,SpalteA

    ,SpalteB

    ,SpalteC

    FROM

    t_quelle_1

    You might try to do the insert...

  • RE: Difference in variable definition

    I use select because I'm flat out lazy:

    declare @i int,@j int

    ------1------------

    set @i=1

    set @j-2=2

    ------2------------

    select @i=1,@j=2

    -------------------

    --and you can do:

    declare @i int,@j int

    select @i=1,@j=2,@i=@i+1,@j=@i+@j

    select @i,@j

    Which makes more sense if you're iterating...

  • RE: Syntax Validation

    Toreador (4/14/2014)


    I agree with Tom, that None of the Above is probably the best answer (though I went for running in dev).

    NOEXEC is definitely not correct though. Just try this

    SET...

  • RE: What does an ALTER COLUMN actually do at run time?

    You might want to check for blocking due to schema locks when modifying a column.

  • RE: 2008 r2 t-sql call stored procedure with 3 parameters

    The columns that I need from the stored procedure called StudentData will return the following data columns

    that I need for the report: StudnentName, StudentAddress, Studentbirthdate, StudentPhoneNumber,...

  • RE: read_only filegroup

    No it's not compressed. It was completely different issue. The particular FG was pointing to a non-existing file. I talked to MS and the solution they came up with was...

  • RE: Tried to remove filegroup

    nmederich (1/11/2011)


    I'm sharing the answer that i found in the hopes it helps someone else.

    Why did this occur? I could be wrong but my theory is this:

    I had been...

Viewing 15 posts - 1 through 15 (of 64 total)