Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 13,460 total)

  • RE: DDL Trigger on newly created database

    from another post very similar to yours, i created this trigger to create a role if it doesn't exist;

    it SEEMS to work in my limited testing then and now:

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

    February 15, 2013 at 1:21 pm

    #1588474

  • RE: Copying Databases - Error - TempDB - Error: 823 Severity: 24 State: 7

    ok, in that case, it might be that the tempdb is running out of space or something for the import wizards process?

    i'd still recommend backup and resotre over the copy...

    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!

    February 15, 2013 at 12:07 pm

    #1588467

  • RE: Copying Databases - Error - TempDB - Error: 823 Severity: 24 State: 7

    you cannot copy the mdf/ldf data files themselves unless the sql server is actually stopped; otherwise you get corrupted files.

    you cannot replace a server's existing databases if the server is...

    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!

    February 15, 2013 at 12:04 pm

    #1588463

  • RE: create a function to remove vowels from a given string

    and a simple cross apply example:

    with myCTE(val)

    AS

    (

    SELECT 'Heavy rains that fell across the Upper Mississipp' UNION ALL

    SELECT 'i River Basin in the summer of 2007 were responsi' UNION ALL

    SELECT 'ble...

    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!

    February 15, 2013 at 9:40 am

    #1588387

  • RE: Does .Net framework 2.0 is compulsory for sql server express 2005

    there are multiple .NET frameworks, and they are side by side installations, not upgrades from previous; so you need each version to support various functionality that use each framework.

    my developer...

    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!

    February 15, 2013 at 9:31 am

    #1588382

  • RE: Please help= Guest account in system databases

    this book has a few pages on renaming both the sa/administrator login and the guest account:

    http://books.google.com/books?id=MsZWztjVbMcC&pg=PA162&lpg=PA162&dq=sql+server+rename+the+guest+account&source=bl&ots=60hO6CtY5a&sig=-_fsIZ9dfCMRyeuU-lQ8xVEf7q0&hl=en&sa=X&ei=ZF4eUZirA5Ho9gSah4GgDg&ved=0CFQQ6AEwBQ#v=onepage&q=sql%20server%20rename%20the%20guest%20account&f=false

    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!

    February 15, 2013 at 9:15 am

    #1588376

  • RE: Unseen characters

    take a look at this thread; it can help you find the ascii code of the unseen character(s)

    ;

    from there, you can decide whether you want to replace it or whatever:

    there's...

    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!

    February 15, 2013 at 6:11 am

    #1588278

  • RE: Shrink Database

    take a look at this thread; it can help you find the ascii code of the unseen character(s)

    ;

    from there, you can decide whether you want to replace it or whatever:

    there's...

    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!

    February 15, 2013 at 6:09 am

    #1588277

  • RE: How to find size of records in a single table grouped by certain criteria?

    another possibility that seems fast and easy would be to select one days data into a new table, do sp_spaceused , and then drop that table.

    then you could get 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!

    February 14, 2013 at 10:49 am

    #1588040

  • RE: Named Instance and specified port not connecting

    Kwisatz78 (2/14/2013)

    Hi - I have got the networks guys to monitor blocked traffic on the firewalls and there is none for the defined port from my workstation. I know...

    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!

    February 14, 2013 at 8:12 am

    #1587953

  • RE: Named Instance and specified port not connecting

    what does your connection string look like?

    are you putting servername-comma-port in the connection string? i know it's common for people to use a semicolon by mistake.

    for example

    Private Const...

    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!

    February 14, 2013 at 7:03 am

    #1587899

  • RE: Trigger issue

    uggh; looks like you are doing something in a trigger(inserting/updating into another server?) that should be done in a service broker, or a schedule job that would 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!

    February 14, 2013 at 6:30 am

    #1587884

  • RE: int column gets value of 0 by default

    I'd blame the application that might be inserting rows into the table; chances are the code is inserting a default of zero from the application, which is outside of 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!

    February 13, 2013 at 8:22 am

    #1587494

  • RE: Character '*' in float column

    not sure about the trigger being what you want to do or not...

    it should be an instead of trigger and not a FOR/AFTER trigger, i think

    a float cannot have an...

    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!

    February 13, 2013 at 7:40 am

    #1587463

  • RE: Permissions Tool

    jpomfret7 (2/13/2013)

    Good Morning all,

    I'm looking for a tool that would allow me to group objects together and assign permissions based on those groups. Such as Joe gets rights to all...

    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!

    February 13, 2013 at 7:35 am

    #1587456

Viewing 15 posts - 3,991 through 4,005 (of 13,460 total)