Forum Replies Created

Viewing 15 posts - 9,256 through 9,270 (of 13,460 total)

  • RE: sp_OACreate and Application Roles

    what i was getting at is the procedure you menthioned, dbo.xpPutPalletOnQueue

    if the procedure features EXECUTE AS in it, It runs with different priviledges, and your application role wouldn't need...

    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!

    June 11, 2010 at 6:44 am

    #1179126

  • RE: sp_OACreate and Application Roles

    by normal scripts to fix this problem do you mean the EXECUTE AS clause?

    I'm not sure what you mean; you should be able to create a procedure with the EXECUTE...

    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!

    June 11, 2010 at 5:50 am

    #1179108

  • RE: How to use sqlcmd to run my create database/tables/sp's script

    here's a question looking at your issue sideways:

    if you are running a script to create a database and all it's objects, why not just include a backup of 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!

    June 11, 2010 at 5:43 am

    #1179106

  • RE: SQL Server and UNIX

    No, MS sql server is locked into the MS windows operating systems, with no plans for multi-platform.

    so while the SQL Engine itself must run in a windows environment, 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!

    June 11, 2010 at 5:39 am

    #1179102

  • RE: a question about trigger

    while there is an event for CREATE_DATABASE you can use for a server trigger, stewartc's questions are right on track....it depends on what you want to do;

    he hinted at auto-creating...

    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!

    June 11, 2010 at 5:36 am

    #1179101

  • RE: Compare 2 tables

    SQL validations typically are CONSTRAINTs, whether a UNIQUE constraint, or a CHECK constraint. you can also use triggers or even functions as a CHECK constraint...so the tools are there...but...

    As...

    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!

    June 11, 2010 at 5:25 am

    #1179094

  • RE: Programming an installation script

    good question actually.

    at some point, the connection to the database that is going to be upgraded has to be input...

    Like me, I'm sure you've noticed that you've never seen an...

    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!

    June 10, 2010 at 7:40 pm

    #1178995

  • RE: Executing a stored procedure issue

    if the stored proc is doing ALTER TABLE and then anything else, i think you have to switch to dynamic sql for the ALTER commands.....that fixes the GO statement, since...

    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!

    June 10, 2010 at 2:30 pm

    #1178922

  • RE: Limiting connections

    sunny.tjk (6/10/2010)

    Fantastic Lowell....but I'm not sure what this "ON ALL SERVER FOR LOGON" does.

    ahh, that's our point...if you don't have a handle on LOGON triggers, read up on them,...

    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!

    June 10, 2010 at 1:44 pm

    #1178898

  • RE: Executing a stored procedure issue

    here's a proc i have laying around for that situation with dyn named FK's: drops all the FK's on a specific column in a table

    usage is simply EXEC DROP_FK_FROM_SPECIFIC_COLUMN TableName,ColumnName

    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!

    June 10, 2010 at 1:38 pm

    #1178894

  • RE: Executing a stored procedure issue

    could it be possible that ANOTHER foreign key, a duplicate the specific FK you are looking for, but with a different, dyamically create name exists?

    it's possible, unfortunately, to have duplicate...

    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!

    June 10, 2010 at 1:31 pm

    #1178891

  • RE: Limiting connections

    yes you can, but you have to use a logon trigger to do it.

    I'm sure there's more to it than the # of connections that you need to figure out...

    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!

    June 10, 2010 at 12:59 pm

    #1178864

  • RE: checking to see if I can change from 8.0 to 9.0 compatibility

    yes you can change compatibility mode without a problem;

    compatibility mode only tells SQL to filter the commands coming in against a set of version-specific-syntax; it does not change how 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!

    June 10, 2010 at 12:45 pm

    #1178855

  • RE: User able to connect even when not assigned to the database using Windows Authentication

    if the windows user has been explicitly assigned a login withthe server roles sysusers,

    or belongs to a windows gorup that has been assigned sysadmin rights (like BuiltIn\Administrators),

    then that 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!

    June 10, 2010 at 12:34 pm

    #1178846

  • RE: Passing a executed t-sql line to a trigger...

    yes it is; as a matter of fact, here's something at codeproject that has a screenshot-by-screenshot, step by step example:

    http://www.codeproject.com/KB/database/MergeReplication.aspx

    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!

    June 10, 2010 at 11:13 am

    #1178787

Viewing 15 posts - 9,256 through 9,270 (of 13,460 total)