Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 13,460 total)

  • RE: query between 2 servers

    this is creating a table dynamically, i think; or what access might call a query?

    I'm weak on Access formatting:

    this is what i'm talking about:

    INTO

    CAMS_Snapshot

    this is your query reformatted...

    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!

    August 17, 2012 at 12:58 pm

    #1527225

  • RE: Rights for

    to use the GUI, you need dbo rights.

    to do the same via script, you only need db_ddladmin.

    sb_dataReader and db_dataWriter are for data only, not for DDL changes.

    the GUI requires more...

    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!

    August 17, 2012 at 11:20 am

    #1527191

  • RE: disk space Report by email

    if you have the query, we can help you html-ize it.

    what have you put together so far?

    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!

    August 17, 2012 at 7:52 am

    #1527087

  • RE: Database removed from instance by automatically

    rebuilding the database creates a fresh master, and would not retain the links to teh databases that were there previously.

    fortunately for you, the MDF/LDF's will still be in place onthe...

    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!

    August 17, 2012 at 7:13 am

    #1527068

  • RE: Why doesn’t the last record win?

    A database is not like an excel spreadsheet; the data is not stored, nor returned in any specific order .

    if you want the data in order, you MUSt supply 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!

    August 16, 2012 at 2:25 pm

    #1526823

  • RE: Maximum Disk Space needed for SQL Server 2012 Enterprise and All Features

    this page has it broken down by application:

    http://msdn.microsoft.com/en-us/library/ms143506.aspx

    Database Engine and data files, Replication, Full-Text Search, and Data Quality Services

    811 MB

    Analysis Services and data files

    345 MB

    Reporting Services...

    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!

    August 16, 2012 at 12:32 pm

    #1526773

  • RE: Odd table format

    I had speed-read your question, and assumed the problem was the GUI scripting out ALTER commands.

    i completely misread your question, sorry about that. that's why i scratched it out, but...

    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!

    August 16, 2012 at 11:42 am

    #1526751

  • RE: sql logics1

    asranantha (8/16/2012)

    why isbbelle gets erroe

    and williams inserts 2 rows +julianna insert 12 rows are not lodead in in toy table how u say thatone

    that's EXACTLY why you need to follow...

    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!

    August 16, 2012 at 11:38 am

    #1526749

  • RE: sql logics1

    asranantha (8/16/2012)

    why isbbelle gets erroe

    and williams inserts 2 rows +julianna insert 12 rows are not lodead in in toy table how u say thatone

    that's EXACTLY why you need to follow...

    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!

    August 16, 2012 at 11:35 am

    #1526745

  • RE: Changing schema for tables

    no, i don't believe it will work.

    if no schema is provided in SELECT columnList From Tablename, the default schema is assumed

    ...customschema in your example.

    if you explicitly states teh schemanmae,...

    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!

    August 16, 2012 at 11:03 am

    #1526730

  • RE: “OBJECT_NAME” function no longer returns objects' names

    if you run this command, are the results null for the ObjectName? I've never heard of the built in function not working correctly, it's usually because of the issues Gsqared...

    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!

    August 16, 2012 at 10:52 am

    #1526721

  • RE: Odd table format

    Edit: What i thought below doesn't hold true; I just tested it, and I don't think it's doing what I thought it did.

    Tools>>Options>>SQL Server Object Explorer>>Scripting.

    I think It's the Scripting...

    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!

    August 16, 2012 at 10:36 am

    #1526718

  • RE: Find Usage of Column in Related Views

    well this uses soon to be deleted oldstyle syobjects, sysdepends,etc, but it works correctly;

    i'll look into updating it to use new metadata instead.

    SELECT

    OBJECT_NAME(sd.id) Referencing_Object,

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

    August 15, 2012 at 1:52 pm

    #1526207

  • RE: Find Usage of Column in Related Views

    ok the query i gave works for objects created WITH SCHEMABINDING... in that case, the referencing_minor_id is not zero, which is how i get some results for column names on...

    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!

    August 15, 2012 at 1:43 pm

    #1526204

  • RE: Find Usage of Column in Related Views

    SELECT

    OBJECT_NAME(depz.referencing_id), *

    FROM sys.sql_expression_dependencies depz

    INNER JOIN sys.objects objz ON depz.referenced_id=objz.object_id

    LEFT OUTER JOIN sys.columns colz ON objz.object_id = colz.object_id

    ...

    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!

    August 15, 2012 at 1:36 pm

    #1526201

Viewing 15 posts - 4,921 through 4,935 (of 13,460 total)