Forum Replies Created

Viewing 15 posts - 5,941 through 5,955 (of 13,460 total)

  • RE: Using @ in User or groups

    looks like a GUI data input tweak;

    if you go straight to TSQL, you cannot create a ulogin or user that starts with @

    you can create either for a login which...

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

    #1446870

  • RE: Script Login with Permissions to User Databases

    this was my first google hit for "Script Login with Permissions to User Databases":

    looks like exactly what you want, right?

    http://www.sql-server-performance.com/2002/object-permission-scripts/

    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 13, 2012 at 10:26 am

    #1446358

  • RE: Remove Orphan Users from DB / POSH DROP

    I think you need to simply drop the users.

    something like this would generate the commands to either fix orphans or drop teh users, would this help?

    /*--Results:

    DROP USER [GMS];

    DROP USER [CCFD01\Jack.Campbell];

    */

    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!

    February 13, 2012 at 7:44 am

    #1446242

  • RE: SQL-RD? - Anyone used it?

    Rob I'm a developer, so the do-it-yourself options for me are much more palatable.

    it's very very easy to do it all yourself you can use CLR.

    I've got prototype CLR'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!

    February 13, 2012 at 5:45 am

    #1446179

  • RE: Why remotely connecting to SQL 2005 express failed?

    going back to the questions on the first page...we never got a definitive answer.

    did you disable windows firewall and attempt to connect?

    what was the results or specific error when 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!

    February 10, 2012 at 2:44 pm

    #1445798

  • RE: Can the following dbo.DelimitedSplit8k be done in one query?

    here's the equivalent SELECT so you can see what would get updated...does it look correct?

    SELECT * FROM Profiles

    INNER JOIN AllJobCategories j

    ON j.Uniqueid = Profiles.id

    ...

    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 10, 2012 at 11:58 am

    #1445718

  • RE: Can the following dbo.DelimitedSplit8k be done in one query?

    = (SELECT must return one value per row;

    here's what i think is the equivalent , but since the subquery would return more than one industry id per profile, you don't...

    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 10, 2012 at 11:44 am

    #1445716

  • RE: Script to identify fixed database roles for a Login in all Databases

    well the aliased table a in your query is sys.database_principals , and that does not have a column named [authentication_type ],

    the only dmv i could find with that exact...

    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 10, 2012 at 9:07 am

    #1445641

  • RE: Trace stops in 1 sec

    ok i ran your command, and i have a trace up and running...it is not stopped for me.

    i had to change the path from c:\MyTrace\ to a folder for me...

    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 10, 2012 at 8:52 am

    #1445633

  • RE: Trace stops in 1 sec

    i think that last command is missing the variable:

    exec sp_trace_setstatus TRACEID, 1 --start trace

    --should be

    exec sp_trace_setstatus @TraceID, 1 --start trace

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

    #1445349

  • RE: DB Users Prefixed With Domain

    ok, i think i see what you mean.

    correct me if I'm misunderstanding the question please.

    The default behavior is to create a user witht eh same name as a login.

    so 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!

    February 9, 2012 at 8:16 am

    #1445106

  • RE: Add Date Specific MSRP to Orders Table

    Lowell (2/8/2012)

    if you can provide sample tables and data that truly emulates the situation, we can help further.

    the key there was emulates what you are trying to do, not necessarily...

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

    #1444757

  • RE: Remove HTML from varchar field?

    this is where regular expressions will help out;

    can you install a CLR on your server to let you do regular expressions?

    converting a string is a two part process, I...

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

    #1444716

  • RE: Add Date Specific MSRP to Orders Table

    you probably need to partition by customer number + upc or invoice_number + upc instead...it completely depends on your specific data. based on what i was able to derive,...

    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 8, 2012 at 11:30 am

    #1444690

  • RE: Policy Based Management: Public Not Granted Server Permissions

    you cannot remove the public role, it's built in and required. everyone is part of the public role.

    http://www.databasejournal.com/features/mssql/article.php/1478701/SQL-Permissions-The-Public-Role.htm

    what you can do is never grant any permissions to that role. so...

    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 8, 2012 at 10:09 am

    #1444647

Viewing 15 posts - 5,941 through 5,955 (of 13,460 total)