Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 13,460 total)

  • RE: Granting Select On The Sys Schema

    I believe the permission GRANT VIEW DEFINITION TO [MyDomain\LOWELL] is what you are after.

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

    #1850273

  • RE: Dynamic Backup Script

    Agreeing with Hugo here; certainly possible,it would just take a naming convention to do this.

    I would think it would be a LOT easier just to name each backup by 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 7, 2016 at 5:47 am

    #1850153

  • RE: xp_logoninfo #nt invalid object error code 0x6ba

    i think you are right about hardening/permissions being the issue.

    When i run xp_logininfo against non-existing domain\group

    or exisitngdomain\fakegroup, i get blank results, no error.

    That makes me think it's permissions

    exec master..xp_logininfo...

    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 7, 2016 at 5:43 am

    #1850148

  • RE: Join to pull mismatch data in tables

    welcome aboardSSC!

    i converted your post into an easily consumable format...now anyone can copy/paste/test.

    the intersect and except operators are an easy way to compar esomething like this, if you are expecting...

    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 6, 2016 at 1:05 pm

    #1850004

  • RE: SQL Server Management Studio

    I believe Registered Servers are SQL only, so are you looking in the "Local Server Groups", or did you actually create a central management server to store the info?

    Central Management...

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

    #1849641

  • RE: Store "Dynamic" results from a stored procedure into a table

    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 5, 2016 at 9:04 am

    #1849560

  • RE: Convert row into column and generate dynamic columns

    your test data wasn't readily consumable, you inserted into the temp table without a definition for it.

    here's the data as my best guess for the setup portion: the dynamic pivot...

    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 5, 2016 at 5:38 am

    #1849489

  • RE: Store "Dynamic" results from a stored procedure into a table

    Can you modify the procedure, since you cannot use openquery?

    sounds like a one procedure to rule them all situation, not the best way to do things.

    I would modify the proc...

    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 4, 2016 at 2:20 pm

    #1849368

  • RE: Report Server (where does it stores the reports)

    river1 (1/3/2016)

    Thank you lowell.

    Just two more questions.

    1) You say that shared connections are also deployed. What about it the connections are not shared (if they belong just to that...

    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 3, 2016 at 10:29 am

    #1849099

  • RE: Report Server (where does it stores the reports)

    your project deploys SSRS reports and other objects(shared data sources, etc) and it stores the reports as xml in the ReportServer.dbo.Catalog table in [Content] column, which is a varbinary column...

    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 2, 2016 at 8:44 pm

    #1849085

  • RE: Send email from T-SQL

    Jeff Moden (12/28/2015)

    mw112009 (12/28/2015)

    (:-P I will run it and findout whether our server is configured correctly to send email)

    If it turns out to not be setup and no one...

    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!

    December 29, 2015 at 6:03 am

    #1848447

  • RE: Syntax Help please - how to drop a foreign key

    sp_help ENROLLMENT_IN is one way, you can scroll down to the foreign leys.

    another way, you can use the metadata to find out the information;

    select * from sys.foreign_keys WHERE object_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!

    December 23, 2015 at 12:23 pm

    #1847830

  • RE: How to convert DOB to age using DateDiff function

    another version, which takes into consideration if the birthday has passed or not:

    DECLARE @DOB datetime

    SET @DOB='1962-12-11'

    SELECT CASE

    WHEN DATEPART(DY,GETDATE()) >= DATEPART(DY,@DOB)

    ...

    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!

    December 22, 2015 at 11:30 am

    #1847534

  • RE: DBA Tasks - To automate or use my own eyes

    to a high degree, every snippet of code is written with automation in mind. i think that's probably a best practice where possible.

    today might be six servers, but tomorrow, what...

    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!

    December 21, 2015 at 12:45 pm

    #1847241

  • RE: Differential Backup size

    it would really depend on the database. you'd want to keep track of the sizes some diff packups of the db over time for a while.

    if the database just...

    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!

    December 15, 2015 at 2:45 pm

    #1846202

Viewing 15 posts - 1,321 through 1,335 (of 13,460 total)