Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 13,460 total)

  • RE: finding what table a user-created statistics is located

    as Sean alluded to , there's several ways to get the name; you could join to sys.objects, or use the built in functions like object_name:

    SELECT OBJECT_SCHEMA_NAME(OBJECT_ID) AS SchemaName,

    ...

    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!

    February 21, 2014 at 8:06 am

    #1691134

  • RE: The SQLCLR Impact

    my old shop used it for two reasons; regular expressions for doing ETL on staging tables(no SSIS in that shop...everything is TSQL), and a custom implementation of AES encryption; 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!

    February 21, 2014 at 7:28 am

    #1691096

  • RE: Hybrid Permission

    I don't believe the permissions are that granular; as i understand it, once you grant ALTER, that's ALTER any object.

    I believe you can only do by granting ALTER, and 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!

    February 20, 2014 at 1:54 pm

    #1690885

  • RE: Using Wildcards to locate middle only results

    performance will ALWAYS suck on this: it requires a table scan due to the LIKE operator, which would have to check every value for values that contain or end with...

    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!

    February 20, 2014 at 5:42 am

    #1690630

  • RE: rowset trace - Anyone knows where it hides?

    now if you want to view the trace results, i like to create a view for each trace: unfortunately, i think it has to have a path variable to 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!

    February 19, 2014 at 1:46 pm

    #1690449

  • RE: rowset trace - Anyone knows where it hides?

    paulaalkz 9229 (2/19/2014)

    Hello. querying sys.traces I found out today that Spotlight Quest is running two rowset traces. I can view the events and columns it is capturing but I wonder...

    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!

    February 19, 2014 at 1:44 pm

    #1690447

  • RE: How is my user getting update permissions through stored procedure?

    ownership chaining, and it's the default behavior.

    if you grant EXECUTE on a procedure to a user with no other permissions, as long as the stored procedure only touches objects 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!

    February 19, 2014 at 9:22 am

    #1690351

  • RE: Query all schemas.

    use the metadata to build a query;

    probably featuring a UNION ALL if you want them in a single resutl set

    SELECT

    'SELECT ' + schema_name(schema_id)+ ' AS SchemaName,* 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!

    February 18, 2014 at 11:12 am

    #1690005

  • RE: Disconnect from SQL Server 2012 when I open a new Query window

    do you have any plugins like SSMS Tools installed? I can't prove it, but it seems to me that my connections get disconnected when not used for x minutes, and...

    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!

    February 18, 2014 at 10:49 am

    #1689994

  • RE: Reset password for user with no login?

    if you have users explicitly created without logins, then there's is no password. users don't have passwords, only logins;

    I've create users to run EXECUTE AS on occasion, and of...

    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!

    February 18, 2014 at 7:51 am

    #1689913

  • RE: How to define a server role that can see all that a sysadmin can see but cannot alter anything?

    If you want thenlogin to see data then youd have to add a user for the login and grant it either specific select permissions or db_datareader.

    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!

    February 18, 2014 at 3:13 am

    #1689787

  • RE: How to auto refresh the existing job using stored procedure

    sram24_mca (2/16/2014)

    We need to restart the job execution If there is any data changes or deletion.

    Regards,

    Ram

    sounds like there's a problem with the logic in your process.

    a job should change...

    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!

    February 17, 2014 at 6:16 am

    #1689469

  • RE: Schema

    mike 57299 (2/14/2014)

    Can someone please give me example SQL code to do the following:

    * Create Scheme xyz

    * Add views to schema xyz

    the above are not necessary to make other objects...

    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!

    February 14, 2014 at 2:32 pm

    #1689239

  • RE: Schema

    take a look at this post i made a few years ago, it's got a nice example of a couple of schemas you can fiddle with.

    http://www.sqlservercentral.com/Forums/Topic1216364-1550-1.aspx#bm1216431

    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!

    February 14, 2014 at 2:18 pm

    #1689230

  • RE: USER PERMISSIONS/SECUIRTY ISSUE

    sysadmin overrules all; any restrictions that you add on a sysadmin are ignored/cancelled out by that ring of power.

    normal users, then yes, the most restrictive wins, but you can't add...

    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!

    February 14, 2014 at 1:54 pm

    #1689218

Viewing 15 posts - 2,491 through 2,505 (of 13,460 total)