Forum Replies Created

Viewing 15 posts - 3,451 through 3,465 (of 13,460 total)

  • RE: msdb database not REALLY in single user mode?

    couldn't ALTER DATABASE msdb SET SINGLE_USER fail if other processes are in it?

    does SQL2000 have WITH ROLLBACK IMMEDIATE?

    ALTER DATABASE msdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    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 16, 2013 at 10:20 am

    #1615894

  • RE: Selecting DISTINCT

    i think using the row number with a sub select will get you what you are after:

    SELECT

    Employee_ID,

    Employee_Title,

    Employee_Entry

    FROM (SELECT

    ...

    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 16, 2013 at 6:54 am

    #1615749

  • RE: Intelisense is not working !!! Even After trying everything mention on msdn website

    can you check the database compatibility of the database?

    i remember that SSMS disables Intellisense for SQL2005 (even though it's possible to enable it);

    maybe that functionality is based on checking the...

    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 16, 2013 at 6:51 am

    #1615746

  • RE: send me som sample type of tickets

    cheekatla.rakesh (5/16/2013)

    Really thanks man...

    I have one more question that is why we apply service packs on server

    Pretty much the same reason you upgrade FireFox, Google Chrome or any other...

    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 16, 2013 at 6:47 am

    #1615743

  • RE: send me som sample type of tickets

    rather than thinking of tickets you might encounter, think of the responsibilities the production DBA has, and evaluate yourself on which items you cna do, and which you want 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!

    May 16, 2013 at 6:18 am

    #1615733

  • RE: Incorrect Syntax near 'MAXSIZE'

    Missing a comma and also a closing parenthesis on the log:

    changing the layout for readability was what made me see it:

    Create database ToddTestDB On Primary

    ( Name = N'ToddTestDB',

    FILENAME...

    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 16, 2013 at 5:30 am

    #1615706

  • RE: Case with Wildcards

    the last selection should just be an ELSE;

    SELECT

    CASE

    WHEN CARS.Model LIKE '%Ford%' THEN 'Ford'

    WHEN CARS.Model LIKE '%Chev%' THEN 'Chev'

    WHEN CARS.Model LIKE '%Buick%' THEN 'Buick'

    ELSE 'All Cars'

    END AS 'Models'

    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 15, 2013 at 3:36 pm

    #1615577

  • RE: Default mdf/ldf directory at the server level

    BACKUP default directory

    http://www.sqlservercentral.com/Forums/Topic1319398-1550-1.aspx

    /*

    In case it was not clear in Jason's post, the @key parameter value remain consistent

    across all of your instances. The proc he is calling does proper registry...

    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 15, 2013 at 3:33 pm

    #1615576

  • RE: Are the posted questions getting worse?

    On a completely unrelated note, I started making a post asking someone for a working example of a linked server for Access using the ACE drivers; about halfway through creating...

    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 15, 2013 at 7:04 am

    #1615404

  • RE: How to copy .bak files on an external drive which is not part of domain but requires authentication?

    yeah this was from my SQL 2000 notes, so we are talking really old school code;

    It Used to be possible to map a drive by throwing a key in...

    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 14, 2013 at 2:31 pm

    #1615203

  • RE: How to copy .bak files on an external drive which is not part of domain but requires authentication?

    an example via xp_cmdshell from an old post;

    the obvious problem is the script contains a cleartext password.

    if the shared drive was already set up at the operating system level, the...

    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 14, 2013 at 1:18 pm

    #1615169

  • RE: Using the Generate Script

    AndrewSQLDBA (5/14/2013)

    I have not been able to every find that SSMS will do that. I was hoping that someone had found a way.

    I have the SSMS Tools. So how would...

    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 14, 2013 at 1:13 pm

    #1615167

  • RE: how to deny logins

    A couple of other ideas ,depending on who it is you want to keep out of the database restore the database with a name noone would connect to.

    and another...

    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 14, 2013 at 12:49 pm

    #1615155

  • RE: Word Doc in SQL Server!

    S_Kumar_S (5/14/2013)

    Hi All

    I wish to store a word document in SQL Server. I should be able to search on the content. e.g. Select Content from DocTable where content like '%this...

    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 14, 2013 at 9:02 am

    #1615050

  • RE: I need to create an XML file populated by fields data(eg: SQL Server DB table)

    well, the xml you posted is malformed; it is either missing two tags in the middle, or these two tags below need to be removed from the middle:

    </DataMarketsFeedMsg>

    </DataMarketsFeed>

    the...

    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 14, 2013 at 6:05 am

    #1614948

Viewing 15 posts - 3,451 through 3,465 (of 13,460 total)