Forum Replies Created

Viewing 15 posts - 6,526 through 6,540 (of 13,460 total)

  • RE: Logon Trigger to restrict a program, but allow for specific users?

    Doesn't the login takes place BEFORE any session is created, and thus before any rows could exist in sys.dm_exec_sessions?

    I think you need something testing ORIGINAL_LOGIN() and

    APP_NAME() is...

    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!

    October 18, 2011 at 7:26 am

    #1395911

  • RE: How to generate all Possible Alphabit pattern in a sequence?

    nice Mark! ,because my Tally Table starts at 1 and not Zero, for me it's missing the group that starts with 'A', but it was trivial to change 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!

    October 18, 2011 at 7:08 am

    #1395894

  • RE: Get DDL for any SQL 2005 table

    wierd, gotta be an issue i have not seen;

    when i scripted your table and index, i get good, clean results.

    can you try the latest sp_GetDDLa to be sure, this is...

    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!

    October 18, 2011 at 7:01 am

    #1395887

  • RE: Tracing the output.

    What i tend to do a lot is to create a view that will allow me to access the trace you created;

    then i can simply do something as simple as...

    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!

    October 18, 2011 at 6:34 am

    #1395861

  • RE: Generate Scripts for SQL Agent Jobs

    there are a few script contributions here on SSC that folks have done, that will do what you are asking:

    http://www.sqlservercentral.com/search/?q=script+jobs&t=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!

    October 18, 2011 at 6:25 am

    #1395856

  • RE: Get DDL for any SQL 2005 table

    CREATE INDEX [ CODE ] ...

    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!

    October 18, 2011 at 6:10 am

    #1395844

  • RE: Query: Want to see "most active users" over the last year in minute incriments

    you'll have to group by the incremental that you want to track.

    here's a rough example, where i'm just guessing at your table structure, but assuming all times have millisecodns in...

    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!

    October 17, 2011 at 6:25 pm

    #1395655

  • RE: Count Number of Rows per Employee

    Looks a lot like homework, so I'll offere a hint to help you get along.

    you need to use GROUP BY employee along with a count(); i think that will get...

    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!

    October 17, 2011 at 2:00 pm

    #1395569

  • RE: Get DDL for any SQL 2005 table

    Elliott Whitlow (10/17/2011)

    Are you the Lowell who wrote the docs for it from the discussion on there? I just added a tweaked up version as a docx file last week.

    CEWII

    yes,...

    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!

    October 17, 2011 at 1:29 pm

    #1395555

  • RE: Get DDL for any SQL 2005 table

    Elliott Whitlow (10/17/2011)

    Ah, you know whats funny Lowell, I mentioned releasing my monitoring and logging project to codeplex way up in the chain, I am only now about ready 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!

    October 17, 2011 at 12:28 pm

    #1395524

  • RE: Get DDL for any SQL 2005 table

    kbleeker (10/17/2011)

    Hey Lowell,

    I'm sure you're not expecting a reply so long since you last updated, but here it is. This SP is absolutely fantastic - a work of art -...

    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!

    October 17, 2011 at 11:31 am

    #1395503

  • RE: Changing Collation of Database

    i went down this rabbit hole once or twice;

    I started building a catch all script that changed everything i could think of...so if a column changed from [SQL_Latin1_General_CP1_CI_AS] 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!

    October 17, 2011 at 11:02 am

    #1395484

  • RE: What should be in Temp DB for Temp tables?

    perfectly normal;

    the SQL server may create temp tables all on it's own to handle things like sorting operations for a dataset to be returned; they don't have to be 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!

    October 17, 2011 at 10:39 am

    #1395461

  • RE: How to compile the stored procedure while creating

    based ont he exact example Eddie posted above, his example worked and compiled just fine on my machine.

    NO EXEC didn't raise any errors at all;

    Waht was your exact error?...

    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!

    October 17, 2011 at 9:50 am

    #1395419

  • RE: how to check the index creation or modified datetime?

    i don't believe the index_creation_date / modify date exists(or at least is exposed); i posed a similar question ofn when is a server side trace Creation_date...it's not available eaither...jsut 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!

    October 17, 2011 at 6:21 am

    #1395263

Viewing 15 posts - 6,526 through 6,540 (of 13,460 total)