Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 13,460 total)

  • RE: How to prevent user login to SQL Management Studio ?

    but the logon trigger only works if the person doesn't know how to change their connection string to explicitly say an application name:

    so the logon trigger is not 100% realiable,...

    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, 2012 at 2:31 pm

    #1434294

  • RE: Someone / thing changed password for user?

    snomad (1/16/2012)

    so I guess there are 2 issues:

    1. What changed the password (if indeed it changed?) Or what else could have caused this?

    There's nothing 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!

    January 16, 2012 at 8:40 am

    #1434108

  • RE: Make New Table Daily

    i'd avoid this at all costs.

    functionally, I see you want to put the data into separate ytables because it makes "sense"...you want to compartimentalize the data the way you...

    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, 2012 at 7:31 am

    #1434068

  • RE: will it work?

    niha.736 (1/16/2012)

    :Wow: i got my clarification, many thanks mr.Lowell

    No problem, glad i could help;

    If you are coming from a programming background, Functions and Subs are interchangable, and the only difference...

    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, 2012 at 6:42 am

    #1434045

  • RE: Foreign Key Constraint

    a foreign key can only be created against a column (or group of columns) which are either the Primary Key of the table, or has a Unique Constraint against it.

    Based...

    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, 2012 at 6:36 am

    #1434040

  • RE: will it work?

    niha.736 (1/16/2012)

    Hi all,

    If a table contain no records and if I write the statement as insert in functions and I also written it in the stored procedure, so, what will...

    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, 2012 at 6:32 am

    #1434038

  • RE: Corrupt T-Sql Script

    without any auditing already in place, all you can do is prepare for it to happen again in the future.

    http://www.ssmstoolspack.com/ has the free SSMS toolpack, and its "SQL History" feature...

    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, 2012 at 5:37 am

    #1434011

  • RE: Looking for query to show who has data_reader in a database

    Markus this will get you started; this does a first level who's in which role; it does not handle nested roles, where eventually someone in a role, which is assigned...

    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, 2012 at 5:40 pm

    #1433767

  • RE: Anybody uses ULTRAEDIT ? Do you have the macro for formatting SQL code

    glad I could help!

    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, 2012 at 2:32 pm

    #1433534

  • RE: Anybody uses ULTRAEDIT ? Do you have the macro for formatting SQL code

    i played with making my own macro, but there are just so many variations/things to consider, you really need to do it in a programming language;

    what's good for a 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!

    January 13, 2012 at 2:22 pm

    #1433526

  • RE: What is the safest less risky way to move System Databases to another Server?

    azdzn (1/13/2012)

    Lowell (1/13/2012)

    I wouldn't even try to restore a different server's system databases.

    instead, i'd do the following:.

    1. script out your jobs in the msdb database,

    2. script out the logins...

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

    #1433481

  • RE: What is the safest less risky way to move System Databases to another Server?

    I wouldn't even try to restore a different server's system databases.

    instead, i'd do the following:.

    1. script out your jobs in the msdb database,

    2. script out the logins with sp_helprevlogin

    3....

    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, 2012 at 12:28 pm

    #1433476

  • RE: search query as per selected checkboxes

    @Bedrooms is an integer...you have to explicitly convert it when building the string:

    '...Bedrooms='+ CONVERT(NVARCHAR,@Bedrooms) + '...'

    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, 2012 at 7:24 am

    #1433239

  • RE: OPENQUERY Query :p

    the openquery says the table starts with an underscore.

    MarshAD.dbo._UserSummary works, but MarshAD.dbo.UserSummary fails;

    looks like a simple issue to fix then.

    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, 2012 at 2:20 am

    #1433079

  • RE: Personal Accomplishments: 8000 posts, 20K+ visits.

    i always assumed a visit was the typical web session; 20 minutes of inactivity closes your session (or switching browsers, or closing and reopening?)

    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 12, 2012 at 5:54 pm

    #1432968

Viewing 15 posts - 6,076 through 6,090 (of 13,460 total)