Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 13,459 total)

  • RE: update script

    well, you are mixing up DML and DDL, and they should be completely seperate steps...first alter the tables if needed, then do your transaction.

    something like this, and note i explicitly...

    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!

    July 23, 2013 at 8:55 am

    #1634991

  • RE: update script

    well, i don't have a products table, to alter, and it was not included in your sample script, so here's mny best guesses:

    you don't have GO statements after 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!

    July 23, 2013 at 8:01 am

    #1634960

  • RE: update script

    TYPE is a keyword, so you'll need to put it in brackets:

    ALTER TABLE product

    ALTER COLUMN [TYPE] VARCHAR(25) NOT NULL

    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!

    July 23, 2013 at 7:52 am

    #1634954

  • RE: Any issues with installing .NET 4.5 on SSRS / SQL 2008R2?

    all of the DotNet versions install side by side in the %windir%\Microsoft.NET folders, they never overwrite each hooter, so you won't have an issue.

    you'll just end up seeing a...

    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!

    July 23, 2013 at 6:27 am

    #1634912

  • RE: Can we Create sql server instance through script?

    via TSQL, the best answer is no, you cannot install a new SQL instance via TSQL.

    it has to be done from the operating system side, with the example parameters supplied...

    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!

    July 23, 2013 at 5:19 am

    #1634881

  • RE: exclude specific tables during the database restore

    i think i'd export the tables out to a different database, restore, and then delete and insert back into the original table...but if you've got foreign keys involved, that 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!

    July 23, 2013 at 5:08 am

    #1634876

  • RE: Error converting data type varchar to numeric

    i would guess it's due to the joins:

    bd.SORTUSER_EMPID = ed.[Employee ID]

    i think maybe one column is an integer or numeric column, and the other is varchar?

    due to data type precedence,...

    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!

    July 22, 2013 at 12:15 pm

    #1634617

  • RE: Accessing MSSQL using a web browser

    my concerns mirror steve's;

    If this was a suite of web pages i dropped into a virtual folder on my own IIS server, yeah it would probably be a good idea.

    If...

    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!

    July 22, 2013 at 9:41 am

    #1634535

  • RE: Do you allow Entity Framework? / Database Security Permissions

    for me, it doesn't matter if it's entity framework or an ADO connection or anything else. it doesn't make a real difference in what it's going to do.

    in our shop,...

    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!

    July 22, 2013 at 6:30 am

    #1634439

  • RE: Securty Trigger stroed procedure

    srimkumarp-720356 (7/22/2013)

    Thanks for the information.

    We are using only Server level audit trigger.

    For example :- I created the login on one server and later drop the same login. Now I want...

    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!

    July 22, 2013 at 6:19 am

    #1634435

  • RE: Securty Trigger stroed procedure

    srimkumarp-720356 (7/22/2013)

    Hi ,

    I want to capturethe Audit Server Security Events , like if any one doing Create / Alter / Drop logins on server level ,...

    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!

    July 22, 2013 at 5:30 am

    #1634412

  • RE: Truncate permission only on specified tables

    truncate is not granular like that; it's inherent in db_owner and db_ddladmin, i believe.

    just make sure noone has those rights.

    what difference is there if the user is allowed to delete...

    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!

    July 19, 2013 at 10:27 am

    #1634112

  • RE: Help on finding the total space used by a database schema

    Guras (7/19/2013)

    I need to find the disk space estimation to create a new database with all the objects of the current databases ( without the data copied) ..for e.g. 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!

    July 19, 2013 at 10:19 am

    #1634108

  • RE: Disable database user

    fraggle i just tested this myself;

    i was hoping i could alter a user and remove their mapping to the existing login, but i found i had to crop and recreate...

    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!

    July 18, 2013 at 12:25 pm

    #1633754

  • RE: Force SQL jobs to run serially, not in parallel

    I'd say if you have 14 separate jobs, they should not be scheduled to execute at all. i'd actually remove them to avoid confusion.

    instead,

    shouldn't you create one single...

    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!

    July 18, 2013 at 5:36 am

    #1633599

Viewing 15 posts - 3,076 through 3,090 (of 13,459 total)