Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 13,460 total)

  • RE: SQL server restoration with limited user rights

    you can create a SQL job or a stored procedure with Execute As Owner.

    the SQL job or procedure would contain the restore command in it,and you grant 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!

    August 24, 2015 at 7:16 am

    #1821944

  • RE: Deny Alter and Deny Drop permissions on ONLY Stored Procedures

    you'll probably need to investigate a bit more ; could their reasons for it be simply institutional inertial(we always needed db_owner just in case)

    if an application is using this login,...

    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!

    August 24, 2015 at 6:01 am

    #1821923

  • RE: Deny Alter and Deny Drop permissions on ONLY Stored Procedures

    coolchaitu (8/24/2015)

    Dear Jonas

    We want our app login(prduser) to have ONLY execute permission to procedures.It must NOT be able to ALTER or DROP stored procedure. It is allowed to do everything...

    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!

    August 24, 2015 at 5:43 am

    #1821917

  • RE: can any one please let me know a stored procedure logic for getting a total left count and right count for a particaulr Id. e.g. if i pass Id 2 the procedure should give its total number of left nodes =3 total number of riht nodes = 1

    There is a neat technique where you sum a case with a counter to get this kind of information.

    SELECT SUM(CASE WHEN placement = 'L' THEN 1 ELSE 0 END)...

    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!

    August 23, 2015 at 4:55 am

    #1821860

  • RE: Locating the mdf,log,and back up files?

    mufadalhaiderster (8/21/2015)

    I am looking at my personal machine, so the path below it is pointing to be has to be the server.

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf

    I know this might sound...

    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!

    August 21, 2015 at 11:21 am

    #1821767

  • RE: What are your five most common T-SQL commands

    for me, its keyboard shortcuts that point to procedures i marked as system procedures, that dig into the current database context of various system views;

    they help me find objects, script...

    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!

    August 21, 2015 at 8:14 am

    #1821703

  • RE: Knowing the expiry of service account

    service accounts don't expire, right? i know "regular user accounts", can have a domain expire date and a separate password expire date.

    with Powershell, i've queries active directory 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!

    August 21, 2015 at 7:21 am

    #1821682

  • RE: Linkserver issue

    the [IN]/[NOT IN] (SELECT SOMECOLUMN FROM SECRETTABLE) has to explicitly exclude nulls.

    NOT IN(SELECT SOMECOLUMN FROM SECRETTABLE WHERE SOMECOLUMN IS NOT NULL)

    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!

    August 21, 2015 at 6:52 am

    #1821663

  • RE: Suppress SSDT database reference error

    you have to create synonyms for anything that points to objects outside of the database.

    the synonym will have deferred resolution,and your project will compile correctly, as you replace each three...

    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!

    August 21, 2015 at 6:32 am

    #1821654

  • RE: How to access loopback linked server?

    Not with a loopback.

    using a linked server/loopback is going to require four part naming conventions. leaving out the database name would default to the default database of the user...

    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!

    August 21, 2015 at 6:15 am

    #1821649

  • RE: adventure works sample database from microsoft

    the biggest difference for me is that Developer comes with the SQL Agent, and thus the ability to create jobs. jobs are an important part of the DBA's toolkit.

    Its important...

    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!

    August 20, 2015 at 7:42 am

    #1821392

  • RE: adventure works sample database from microsoft

    download SQL Express With Advanced Services. it's free.

    http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

    that is the most complete version, and includes SQL Server Management Studio and more;

    the "normal" express download does not include any tools, 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!

    August 19, 2015 at 2:01 pm

    #1821186

  • RE: Can this be done without temp tables

    since you only want tasks that are not on hold, i'd look to get the data via the EXCEPT operator,a dn join it with the other items on hold.

    nice job...

    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!

    August 19, 2015 at 1:00 pm

    #1821166

  • RE: Account Number Transformation

    Scots solution requires a mapping, mine is just assigning new values.

    here's my version, the core is this part at the end:

    ;With

    TheData

    AS

    (

    SELECT

    [dbo].[DelAlphaChar](vm.AccountNum) As CleanedNumber,

    row_number() OVER...

    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!

    August 19, 2015 at 11:25 am

    #1821139

  • RE: Quick Gui to run script on database

    i would lean towards a web page that accepts the user input, and performs the work behind the scenes.

    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!

    August 19, 2015 at 10:37 am

    #1821121

Viewing 15 posts - 1,546 through 1,560 (of 13,460 total)