Forum Replies Created

Viewing 15 posts - 691 through 705 (of 13,460 total)

  • RE: Data Archive

    After a large delete, you'll need to rebuild the indexes on the table.
    the deleted items still take up the pages they used to occupy, and reindexing rearranges and deletes...

    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 5:44 am

    #1922802

  • RE: stored procedure is only returning one letter

    Senchi - Saturday, January 14, 2017 9:01 AM

    I have a stored procedure like this :
    USE [MyDatabase]
    GO
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[sp_logvrnitev]
        @p1...

    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 14, 2017 at 9:42 am

    #1922748

  • RE: SSC Forum Updates

    I managed to break the javascript in a post, so I cannot edit the post, nor use the mini "Explore "menu in the upper right that typically has a link...

    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 13, 2017 at 12:43 pm

    #1922674

  • RE: DMV for index options (such as ONLINE)

    brett.walker - Friday, January 13, 2017 12:18 PM

    Hello,

    I have a script that returns lots of useful information about all the indexes in my...

    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 13, 2017 at 12:35 pm

    #1922673

  • RE: Help me with the query - Reporting Server related

    i have this saved from something i built off of an msdn, does this help?

    left join ReportSchedule rs on Sch.ScheduleID = rs.ScheduleID
      left join...

    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 13, 2017 at 11:26 am

    #1922658

  • RE: Migrating Subscriptions and Schedules from SSRS 2008

    agerard 65681 - Friday, January 13, 2017 9:10 AM

    Hi

    My company currently runs SSRS 2008 in production, and we've stood up an SSRS 2016...

    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 13, 2017 at 9:25 am

    #1922616

  • RE: Export data in fixed width with header row

    I tried slapping a full example together, but i find it pretty annoying that Format-Table is leaving extra whitespace.
    there a line in the  beginning where  a header would be...

    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 13, 2017 at 7:11 am

    #1922546

  • RE: Options for auditing SQL logins

    no problem with asking for another look, I'm glad to help.

    yeah you could potentially be seeing new logins being created after your delete, so they show up in your query;...

    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 11, 2017 at 2:03 pm

    #1922065

  • RE: Update Field to current logged in user ID with new record command button

    sumanth.pathuri (1/11/2017)

    How can we capture if someone edits a record without using a trigger. We need a column in the same table. Can you please help me with this.

    you should...

    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 11, 2017 at 11:37 am

    #1922032

  • RE: SQL SP's and Function's Encrypted

    very weird;

    since you got an SMO error, i might worry that you are using an older version of SQL Server Management Studio to connect to a higher version of SQL...

    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 10, 2017 at 2:20 pm

    #1921769

  • RE: SQL SP's and Function's Encrypted

    are you a sysadmin?

    are you connecting via a dedicated connection?

    does this return anything with the IsEncrypted column being 1?

    SELECT

    sm.object_id,

    OBJECT_SCHEMA_NAME(sm.object_id) AS SchemaName,

    OBJECT_NAME(sm.object_id) AS object_name,

    o.type, o.type_desc,

    sm.definition,

    CAST(CASE WHEN...

    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 10, 2017 at 1:56 pm

    #1921758

  • RE: foreign key w/o constraint

    you could create it WITH NO CHECK so it does not validate the existing data, and would be untrusted...but why would you want to do that?

    referential integrity is a good...

    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 10, 2017 at 1:40 pm

    #1921749

  • RE: SQL SP's and Function's Encrypted

    i just confirmed this still works on SQL2016, so you are good for all lower versions too.

    ok, try opening a dedicated admin connection,

    and in the database in question, add 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!

    January 10, 2017 at 1:30 pm

    #1921744

  • RE: SQL SP's and Function's Encrypted

    take a look at this thread, which explains you can use a combination of the Dedicated Admin Connection and a procedure to view the encrypted definition.

    http://jongurgul.com/blog/sql-object-decryption/

    if you happen to...

    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 10, 2017 at 1:09 pm

    #1921738

  • RE: Options for auditing SQL logins

    At least for me, i only want a last login if it's changed since yesterday. i don't need 50 updates to update to the latest second

    By adding a WHERE statement...

    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 10, 2017 at 9:17 am

    #1921647

Viewing 15 posts - 691 through 705 (of 13,460 total)