Forum Replies Created

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

  • 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

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

    mail.baberkhan (2/28/2012)

    BULKADMIN

    BULK INSERT administrators. Can load data into tables using BULK INSERT statement.

    Database administrators responsible only for loading data through BULK INSERT. Data import specialists.

    So With Bulk Admin rights...

    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:03 am

    #1452537

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