Forum Replies Created

Viewing 15 posts - 16,096 through 16,110 (of 39,970 total)

  • RE: Lock Escalation

    I've searched a dozen links and I don't find "partition lock" as a term in BOL. The idea is there, and even in the ALTER TABLE options, it does say...

  • RE: Local administrators

    By default, they have rights on the machine, but you can set up folders that don't allow the administrator access. An admin can take access, but that is noted and...

  • RE: Treat People Like People

    Thanks for the notes, and glad you liked it.

    I know that Millenials is a generalization, and certainly people feel differently with that group. It encompasses people of a variety of...

  • RE: Content Missing

    I think that's a IE issue. I don't see that at all in Firefox. I'll have someone look at it

  • RE: Nominations open for Exceptional DBA of 2011

    LOL, maybe ask your boss and see what he/she thinks.

    I'll have enough apps to review for Exceptional. I'd hate to think how many I'd get for acceptable :w00t:

  • RE: Content Missing

    I don't see anything weird there. Is there something I'm missing? Can someone post a screen shot.

  • RE: From Great Idea to End Result

    Peter Maloof (5/24/2011)


    EdVassie (5/24/2011)


    The agile methodology using Scrum (and its variations) is by far the most effective way I have seen for delivering useable value to the business.

    I'm not a...

  • RE: trace?

    create table UserTracking

    ( trackid int identity(1,1)

    , userlogin varchar(200)

    , logintime datetime

    )

    go

    grant insert on UserTracking to Public

    Change your trigger:

    CREATE TRIGGER connection_info_trigger

    ON ALL SERVER

    FOR LOGON

    AS

    BEGIN

    insert UserTracking (userlogin, logintime)

    ...

  • RE: A couple of questions about SQL 2008 Express

    Amazing amount of stuff in RTF. The Word files are XML storage, AFAIK, so you can even store those, but you need an interpreter to render them back.

    The transformation to...

  • RE: SQL Server replication withoout Internet

    Search encryption programs, or check for your OS. Win 7 has some built in options, including the ability to encrypt flash drives. Same for some of the Norton/Symmantec products.

  • RE: trace?

    I like using a logon trigger to track this, grab the IP and go from there. Best to just get the info you can, and then handle it offline by...

  • RE: A couple of questions about SQL 2008 Express

    Rich text, AFAIK, isn't unicode. It's markup inside the text that is interpreted by the editor. So if I make a set of bold text and a regular text like...

  • RE: Identity Reseed

    Code to show duplicate values, without constraint (SS2K8R2)

    DROP TABLE dbo.MyTable

    CREATE TABLE mytable

    ( id INT IDENTITY(1,1)

    , mychar VARCHAR(10)

    )

    GO

    INSERT mytable SELECT 'A'

    INSERT mytable SELECT 'B'

    INSERT mytable SELECT 'C'

    SELECT * FROM dbo.MyTable

    SET IDENTITY_INSERT...

  • RE: A couple of questions about SQL 2008 Express

    No idea on relationships, but nvarchar(max) and varchar(max) for Latin data are the same. Only if you are storing data requiring Unicode does this matter.

  • RE: Retrieve PDF data from database into a file.

    This might help: http://geekswithblogs.net/pakistan/archive/2005/04/19/36884.aspx

    You need to SELECT the data from the table, but the client has to deal with the stream.

Viewing 15 posts - 16,096 through 16,110 (of 39,970 total)