Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 13,460 total)

  • RE: SSMS 2012 Configuration Settings Are All Gone / Reset

    I'm pretty sure the settings are stored in the

    %appdata%\Microsoft\SQL Server Management Studio\11.0 folder in the SQLStudio.bin file.

    If you use any applications that clear out temporary files to recover some...

    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!

    September 28, 2012 at 2:50 pm

    #1543634

  • RE: Open EDI file in SQL Server

    ramadesai108 (9/28/2012)

    We do not have the layout file, how do I create one or where do I get one?

    Thanks.

    ouch, there is seriously no "easy" way on this then.

    to the best...

    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!

    September 28, 2012 at 11:50 am

    #1543571

  • RE: how to add indexes in all tables in a database

    blindly adding an index on all the columns that foreign keys are involved with might not help much;

    it's the selectivity of the data that is what the SQL engine uses...

    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!

    September 28, 2012 at 11:26 am

    #1543560

  • RE: Open EDI file in SQL Server

    well, like Ron/bitbucket said; there's many formats to an EDI file; somewhere someone on your side should have put together a document mapping out each element;

    once you have that...

    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!

    September 28, 2012 at 10:44 am

    #1543542

  • RE: Output string to text file?

    why to a text file, and not a table in say, the msdb database, which can contain a suite of commands for you to run during you rmaintenance window?

    why must...

    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!

    September 28, 2012 at 9:10 am

    #1543477

  • RE: Code suddenly stopped working and Im stumped!

    wedgemail (9/28/2012)

    I dont think Im being clear

    I know how to get it to run(add a linked server) but my question is how can

    this code run successfully:

    SELECT 1

    FROM EWH_Staging.dbo.STAGE_REMP_VCC_Distinct vcc

    It...

    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!

    September 28, 2012 at 9:08 am

    #1543474

  • RE: Open EDI file in SQL Server

    formatted a bit for readability;

    similar to some EDI files I handle, it looks like the tilde(~) is the delimiter for message segments;

    the ISA segment is a control header for "who...

    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!

    September 28, 2012 at 8:55 am

    #1543461

  • RE: SQL Server side trigger

    tauseef.jan (9/28/2012)

    Thanks guys, especially Lowell for the code snippet.

    Actually I need, when a user creates/restores a database on the server

    he should be automatically be assigned to db_owner role.

    ...

    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!

    September 28, 2012 at 7:15 am

    #1543400

  • RE: Code suddenly stopped working and Im stumped!

    wedgemail (9/28/2012)

    It does but its on a remote server not local?

    in that case, being on a remote server, you need a linked server so you can get to it.

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

    September 28, 2012 at 6:16 am

    #1543377

  • RE: SQL Server side trigger

    tauseef.jan (9/27/2012)

    hi friends,

    I need to create a server trigger to automatically map a login to a new database and make it a member of the db_owner database role.

    I was 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!

    September 27, 2012 at 9:50 am

    #1542981

  • RE: Show Right Column to Right User

    Well. Remember that the sql security model is deny by default;

    Its easy to forget that as a developer since you test as sa/sysadmin.

    That means you can create a view and...

    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!

    September 27, 2012 at 4:08 am

    #1542779

  • RE: Preventing from "create database" with data and log file on C: drive.

    i think in addition to a DDL trigger, you want to change the default paths as well;

    a simple CREATE DATABASE SANDBOX' command doesn't specify the path, so unless you changed...

    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!

    September 26, 2012 at 9:26 am

    #1542497

  • RE: Case in where clause doesn't get validated

    a case can't due logic...it must return a single value; you are trying to use it more like an If statement to get NextReviewDate < getDate() for example.

    i think it'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!

    September 26, 2012 at 9:05 am

    #1542479

  • RE: Scripting - BCP out certain columns in table?

    chrisph (9/25/2012)

    I changed the names for the example but I tried the command with exactly the same database and table name that reside on the server. The user I...

    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!

    September 25, 2012 at 3:26 pm

    #1542102

  • RE: Scripting - BCP out certain columns in table?

    chrisph (9/25/2012)

    I've tried several different ways to run the script example you showed and I constantly get a syntax error of "invalid object name" in regards to the database. schema.table....

    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!

    September 25, 2012 at 1:45 pm

    #1542068

Viewing 15 posts - 4,666 through 4,680 (of 13,460 total)