Forum Replies Created

Viewing 15 posts - 5,866 through 5,880 (of 13,460 total)

  • RE: quick question on securables

    Ben you can grant that special user like this:

    GRANT EXECUTE ON sprocRefresh TO SPECIALUSER

    do not grant anything else.

    as long as sprocClear or sprocPopulate are owned by the same schema(ie they...

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

    #1453203

  • RE: Create Role for Developers on Database Server

    checkai (2/29/2012)

    Thanks, will this allow them to read SP definitions?

    yep, the grant here does it:

    --allow the users to see view proc and function definitions

    Grant View Definition ON SCHEMA::[dbo] To [MyDevelopers]

    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 29, 2012 at 7:48 am

    #1453176

  • RE: Create Role for Developers on Database Server

    checkai (2/29/2012)

    I want to create a "Developer" role within SQL 2008. The role should be allowed to read anything, and view the definitions of SPs/Functions, etc. I do not want...

    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 29, 2012 at 7:35 am

    #1453165

  • RE: Generate Full Script from server to my local system automatic

    look in the powershell forum here on SSC;

    there's a large number of posts showing how to script out a whole database; then with powershell you can schedule it 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!

    February 29, 2012 at 7:32 am

    #1453161

  • RE: Query

    i have this saved in my snippets; not interview questions, but dba responsibilities that you should be intimitely familiar with to make it thru an interview unscathed:

    I especially like some...

    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 29, 2012 at 6:12 am

    #1453114

  • RE: how to get the data week wise in sql server

    Cadavre (2/29/2012)

    Lowell (2/29/2012)

    Cadavre my friend how do you script your clr to be the binary string like that?

    what's the trick?

    i've only done it manually so far, nd it's 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!

    February 29, 2012 at 5:55 am

    #1453102

  • RE: how to get the data week wise in sql server

    Cadavre (2/29/2012)

    {snip}

    IF EXISTS (SELECT *FROM sys.assemblies asms WHERE asms.NAME = N'dateWeekValidation' AND is_user_defined = 1)

    DROP ASSEMBLY [dateWeekValidation];

    CREATE ASSEMBLY [dateWeekValidation] AUTHORIZATION [dbo]

    FROM

    0x4D5A90000300000004000000FFFF0000B{snip}

    Cadavre my friend how do you script your...

    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 29, 2012 at 5:29 am

    #1453087

  • RE: select statement takes long time

    Vahid.Ch (2/29/2012)

    yes.

    that query is selecting everything from the WebProxyLog table, no WHERE statement to tune;

    it takes any network time to return 630 meg of data.

    do you need to return all...

    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 29, 2012 at 4:57 am

    #1453066

  • RE: Trigger or Insert issue: Not generating the correct data

    Gianluca Sartori (2/28/2012)

    ram_kamboz2k7 (2/28/2012)

    if bigint is an issue, can nvarchar be used for the telephone number?

    Thanks

    varchar would be a better choice. I highly doubt you will ever need 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!

    February 28, 2012 at 11:42 am

    #1452757

  • RE: Get DDL for any SQL 2005 table

    Thanks for the input guys!

    Updated yet again...same old links but new code.

    sp_GetDDLa_Latest.txt (Returns Table)

    sp_GetDDL_Latest.txt (Returns varchar(max) )

    [/quote]

    this version is greatly enhanced;

    --scripts any object(table,proc, function,trigger)

    --has the nvarchar fix so they...

    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 28, 2012 at 9:51 am

    #1452704

  • RE: Without linked servers

    openrowset or openquery, which is a kind of temporary linked server...

    is the question how to do that, or is this a question more along the lines of connectivitiy options?

    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 28, 2012 at 7:42 am

    #1452604

  • RE: Difference between two datetime fields taking account of weekends (at least!)

    Rob-350472 (2/28/2012)

    That's a very comprehensive calendar table! Thanks for the linkage. The calendar table isn't so much the issue, how I use it is the issue!... I could knock up...

    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 28, 2012 at 6:31 am

    #1452549

  • RE: Login to provide with Database creation and Import rights

    Import rights = which database?

    you have to define that a lot better;

    if this is for one existing database, you need to add the login as a user 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!

    February 28, 2012 at 6:26 am

    #1452547

  • RE: Difference between two datetime fields taking account of weekends (at least!)

    for your specific quesiton, i'd add one more calculated column to make life easy:

    --IsWorkDay?

    ALTER TABLE TallyCalendar

    ADD IsWorkDay AS CASE WHEN IsWorkHoliday = 1 OR DayOfWeek IN('Saturday','Sunday') THEN 0...

    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 28, 2012 at 6:19 am

    #1452545

  • RE: Difference between two datetime fields taking account of weekends (at least!)

    yeah a Calendar table is definitely the way to go.

    I've posted one here that is one of the better versions out there...it features all the funcitons to generate US Holidays,...

    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 28, 2012 at 6:10 am

    #1452540

Viewing 15 posts - 5,866 through 5,880 (of 13,460 total)