Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 13,460 total)

  • RE: Need to run several maintenance scripts

    scogeb (11/6/2012)

    Could you disable all logins except one, and use that login for this maintenance?

    maybe a create a logon trigger that prevents anyone from connecting unless from local connection?

    then 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!

    November 6, 2012 at 8:26 am

    #1556486

  • RE: Generate unique invoice number-very CRITICAL application.

    ok I've got this implementation in my snippets that does what you are asking.

    see if this works for you.

    you need a table and a procedure, shown below:

    CREATE TABLE [dbo].[InvoiceKeys] (...

    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!

    November 6, 2012 at 7:20 am

    #1556451

  • RE: database ownership issues

    you can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;

    the BOL Links are here for the explanation and the code:

    Changing the Database Owner

    ALTER AUTHORIZATION (Transact-SQL)

    and a basic...

    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!

    November 5, 2012 at 11:55 am

    #1556178

  • RE: Naming multiple results of one column different name.

    it's just a syntax issue;

    CASE for SQL has two forms :

    CASE ValuetoTest

    WHEN SomeValue

    THEN SomeOtherValue

    ELSE DefaultValue

    END

    --OR

    CASE

    WHEN {SomeExpression} (ie SomeColumn = SomeValue)

    THEN SomeOtherValue

    ELSE DefaultValue

    END

    you werejust...

    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!

    November 5, 2012 at 11:35 am

    #1556173

  • RE: Convert Existing Stored Procedure To CLR Stored Procedure

    azinyama (11/5/2012)

    Another question though...

    What would I then do about preventing people from using Windows Authentication to log in???

    just because you have a windows login, does not auto-magically mean the login...

    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!

    November 5, 2012 at 10:38 am

    #1556153

  • RE: Convert Existing Stored Procedure To CLR Stored Procedure

    azinyama (11/5/2012)

    I am developing an application that is going to be setup on a server that is in a public area, that anyone will have access to.

    If you are trying...

    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!

    November 5, 2012 at 7:51 am

    #1556057

  • RE: how to insert image in sql server 2005

    you would want to save the filename as well, don't forget....

    deepkt (11/5/2012)

    Try this,

    CREATE TABLE Img(Id INT, Filename varchar(255), Obj VARBINARY(MAX))

    INSERT INTO Img (Id ,FileName,Obj)

    VALUES (1,'Blue Lace 16.bmp',(SELECT * FROM OPENROWSET(BULK...

    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!

    November 5, 2012 at 6:52 am

    #1556027

  • RE: how to create a sql login and add to database user which already exists

    CREATE LOGIN [appp]

    WITH PASSWORD=N'NotTheRealPassword'

    MUST_CHANGE,

    DEFAULT_DATABASE=[master],

    ...

    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!

    November 5, 2012 at 6:24 am

    #1556016

  • RE: ATTACHING SQL SERVER_2000 DATABASE TO SQLSERVER 2008

    i see that error in other posts a lot because people place the mdf in their MyDocuments folder or on their desktop, which all have restricted access, and the service...

    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!

    November 5, 2012 at 5:23 am

    #1555990

  • RE: T-SQL to call the SQL Parse "function"

    SET PARSEONLY ON/OFF works as well.

    i'm having some fun trying to get a CLR to work as a proof of concept; i'll post it as soon as it returns results...

    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!

    November 2, 2012 at 9:56 am

    #1555567

  • RE: BCP text file is adding an extra line at the end of the file

    outsider32 (11/1/2012)

    It is on the next line after the data, there is only one return after the data.

    So i'm getting:

    Comments

    (cursor here)

    I am on version: 11.0.2100.60

    I appreciate the help!

    does the comments...

    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!

    November 1, 2012 at 3:15 pm

    #1555213

  • RE: T-SQL to call the SQL Parse "function"

    SELECT * FROM FROM sys.objects

    , yeah the parse assumes the second FROM is a table name, and so the alias 'sys.tables' is an error.

    a longer, better error message comes from...

    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!

    November 1, 2012 at 2:09 pm

    #1555188

  • RE: T-SQL to call the SQL Parse "function"

    I've played with this a couple of times, Jason; i've used it to chop a SQL statement into elements, so i could play with building my own formatter, and of...

    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!

    November 1, 2012 at 1:51 pm

    #1555175

  • RE: Why use scripts to apply changes vs restoring a database backup from vendor

    Data is the first thing that comes to mind.

    If you save any data of any kind in that database, it would of course be unique to you and your...

    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!

    November 1, 2012 at 8:43 am

    #1555045

  • RE: how to find ASCII characters in a table?

    mkarthikeyyan 89837 (11/1/2012)

    Please help me to find unpredictable special characters like ? , ? in fields.

    For example:

    It returns "?" only. Please help me how to display these special characters?

    Thanks!!!

    because 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!

    November 1, 2012 at 8:10 am

    #1555021

Viewing 15 posts - 4,441 through 4,455 (of 13,460 total)