Forum Replies Created

Viewing 15 posts - 676 through 690 (of 13,460 total)

  • RE: Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

    if the referenced table has a specific column name (in the example [StatisticsName]), this will find all objects that are referencing the object(ie table) in question.

    ...

    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!

    January 19, 2017 at 10:20 am

    #1923783

  • RE: Need help with deleting/updating duplicates in two tables

    using row number is how i would find the dupes.
    the query i'm using here can be switced to a delete by simply swapping the commenting the --DELETE and commenting...

    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!

    January 18, 2017 at 11:56 am

    #1923515

  • RE: ToolBox missing for Maintenance task

    you can end up getting the empty  "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
    there's always a shortcut for the SSIS toolbox and SSIS variables...

    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!

    January 17, 2017 at 1:26 pm

    #1923267

  • RE: Really Bizzare Flat File Destination issue

    Additionally, shouldn't it say that it wrote 0 rows if it could not write to the file?

    I think the Flat File Connection Manager will create 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!

    January 17, 2017 at 8:32 am

    #1923189

  • RE: Really Bizzare Flat File Destination issue

    you said it occurs when the package is run on the server, by the proxy or service account, right? or by another, specific user.....

    check the permissions on 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!

    January 17, 2017 at 7:18 am

    #1923164

  • RE: Data Masking in SQL Server 2014

    you'll need to use good old fashioned strings or REPLACE functions.
    and you need to take into account the data types....you said number, but is it a string representing 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!

    January 16, 2017 at 1:08 pm

    #1923047

  • RE: MSSQLSERVER service terminated unexpectedly

    look in the windows event logs;
    you might see something like the network guys installing patches, which required a reboot;
    look deeper into the sql server log, specifically at...

    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!

    January 16, 2017 at 12:38 pm

    #1923046

  • RE: Changing object owner

    ifilter - Monday, January 16, 2017 11:06 AM

    Hello SSC,

    Does changing ownership of an object require an instance reset, or can it be done...

    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!

    January 16, 2017 at 12:15 pm

    #1923041

  • RE: Changing object owner

    changing the owner for object or jobs are just  object level schema lock; no instance wide affects. if someone is connecting or updating , you might have to wait for...

    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!

    January 16, 2017 at 12:12 pm

    #1923040

  • RE: Data Archive

    i was thinking of recovering table space, typically tied up in indexes or in heaps.
     and not reserved space for the whole database.

    AS Jeff mentioned,you have to shrink...

    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!

    January 16, 2017 at 10:40 am

    #1923027

  • RE: Removing Databases

    if you run the query below in a given database, it will check the index statistics and tell you the last time a table was read/updated since the last time...

    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!

    January 16, 2017 at 7:49 am

    #1922983

  • RE: SSC Forum Updates

    minor annoyance: the email link for old vs new forum posts: new posts have a direct link to unsubscripbe.
    old posts have the generic link to all the items you've...

    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!

    January 16, 2017 at 7:39 am

    #1922982

  • RE: SSC Forum Updates

    Over the weekend, I saw a huge flood of the same kind of spam we were getting in the old forum software; mostly links to current events like football games...

    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!

    January 16, 2017 at 6:56 am

    #1922969

  • RE: List users that belong to a specific database role

    Senchi - Sunday, January 15, 2017 8:24 PM

    This, unfortunately,this  works only if I run it on the server. If I run it from...

    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!

    January 15, 2017 at 8:39 pm

    #1922856

  • RE: List users that belong to a specific database role

    each database has a system view named sys.database_role_members, which is just ID's associated ot roles; you have to join that against database_principals to get what you are after.
    you'll need...

    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!

    January 15, 2017 at 7:50 pm

    #1922850

Viewing 15 posts - 676 through 690 (of 13,460 total)