Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 13,460 total)

  • RE: deny view master database

    and to recap, all users, since they are in the public role, have access to master and tempdb;

    however what they see in the master database is limited by permissions, 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!

    January 15, 2014 at 11:34 am

    #1680386

  • RE: desensitize data after a restore

    Perry Whittle (1/15/2014)

    PearlJammer1 (1/15/2014)

    looks like a complicated process to implement. I'm going to have to give this some serious thought.

    :-):-)

    What?

    Identitfy the Live tables that require obfuscating (there's likely only a...

    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, 2014 at 5:36 am

    #1680220

  • RE: Management Studio consistently hangs after accessing Object Explorer

    also, can you tell us if you are sysadmin in the connection that SSMS/ object explorer is using ?

    there's a lot of code in SSMS that assumes that you are...

    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, 2014 at 2:42 pm

    #1680073

  • RE: General ETL question - ETL from unknown number of tables ?

    this is sort of similar to a question i asked the other day:

    http://www.sqlservercentral.com/Forums/Topic1530825-363-1.aspx

    i wanted to grab 1-N queries and use SSIS to send them to a multi sheet excel document;

    because...

    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, 2014 at 12:40 pm

    #1680039

  • RE: SQLservr.EXE?

    sqlserver.exe is the name of the executable that is running under the SQL service; it is the absolute core and is critical to SQL server...heck it IS sql server.

    if 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 14, 2014 at 12:29 pm

    #1680034

  • RE: Grant user "drop table" permission?

    for a specific table, it's the ALTER permission; that obviously means they can add/drop columns as part of the table as well.

    GRANT ALTER TABLE on dbo.TableName to MyUser

    i belive if...

    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, 2014 at 12:03 pm

    #1680021

  • RE: SQLservr.EXE?

    New Born DBA (1/14/2014)

    I have been asked from users about SQLSERVR.EXE. What is SQLSERVR.EXE?

    Someone emailed me about "why SQLSERVR.EXE process is limited to about 128MB of RAM and it...

    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, 2014 at 12:00 pm

    #1680020

  • RE: Predict the output

    can't really predict the output, since this poll has all incorrect answers.

    kudos for the easily copy-and-pasteable code, it produces results that basically looks like a christmas tree, i guess.

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

    January 14, 2014 at 9:51 am

    #1679971

  • RE: Select 4 Distinct Suppliers for each stock number in Single Query

    probably the easiest way is to stick the query into a subquery, featuring row number, and then filter the results.

    SELECT

    *

    FROM (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 14, 2014 at 9:42 am

    #1679968

  • RE: Slow running query

    not really;

    the actual SQL plan allows us to review deep details of the plan, and tell if stats are out of date, which columns were used, which indexes, and 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!

    January 14, 2014 at 7:29 am

    #1679896

  • RE: Slow running query

    for this query, i think we'd need to see the actual execution plan on this, as well as a list of all indexes on the fctAssetFulfillment and the FulfillmentPartnerInstall...

    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, 2014 at 7:19 am

    #1679887

  • RE: set default parameter for function parameter

    Luis pointed it out i think; the assignment must be a static value or constant;

    a convert cannot be used, even if it was a static date, nore getdate,

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

    January 13, 2014 at 2:11 pm

    #1679716

  • RE: Relationship information between tables situated at different databases

    it's not possible for a foreign key to reference a different database.

    foreign keys can only be created within the same database as the two tables exist in.

    it's possible 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 13, 2014 at 6:08 am

    #1679554

  • RE: Relationship information between tables situated at different databases

    well, if there is a view or stored procedure that references a different database or a linked server, you can query for that.

    take a look at the view sys.sql_expression_dependencies,...

    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, 2014 at 5:25 am

    #1679544

  • RE: SSIS Any-Query-to-Excel Worksheet?

    Thanks for looking Phil!

    pretty sure the office is using vs2008 for ssis and ssrs, so that's probably 2008; i couldn't seem to find a 2008 SSIS forum.

    Ironically, i had done...

    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, 2014 at 6:02 am

    #1679363

Viewing 15 posts - 2,656 through 2,670 (of 13,460 total)