Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 13,460 total)

  • RE: db_creator permission not working on SQL Server 2008 r2

    dbadude78 (8/31/2012)

    Yes I have got a DDL trigger, I have disabled it and it works now. Thankyou for your help 🙂

    The reason i put the triggers was to monitor when...

    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 31, 2012 at 9:38 am

    #1532487

  • RE: db_creator permission not working on SQL Server 2008 r2

    dbadude78 (8/31/2012)

    Yes I did, not sure what to do

    the error message:

    "Msg 297, Level 16, State 1, Procedure Audit_Server, Line 13

    The user does not have permission to perform this action"

    i think...

    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 31, 2012 at 9:17 am

    #1532466

  • RE: I can't figure out what's wrong with this syntax

    you could use the linked server instead of open query, or switch the whole openquery command to be dynamic SQL;

    that's all i can think of.

    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 31, 2012 at 9:00 am

    #1532446

  • RE: I can't figure out what's wrong with this syntax

    I think the issue is related to OPENQUERY (linky to BOL) ;

    OPENQUERY does not accept variables for its arguments.

    it requires a static string as the second parameter, so you cannot...

    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 31, 2012 at 8:50 am

    #1532440

  • RE: Find specific text from database with stored procedure

    this question comes up a lot; I've had to do this when a web page name changed, for example, and who knows what content exists out there with the old...

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

    #1532429

  • RE: db_creator permission not working on SQL Server 2008 r2

    did you create the matching USER devtest in the database where the procedure was created?

    did you grant execute to the user devtest ont eh procedure?

    CREATE USER devtest FOR LOGIN=devtest

    GRANT 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!

    August 31, 2012 at 7:51 am

    #1532395

  • RE: db_creator permission not working on SQL Server 2008 r2

    dbadude78 (8/31/2012)

    Hi

    Thanks for the quick reply. As a test i executed the whole script on my local instance. But got a the following message "Msg 297, Level 16, State...

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

    #1532375

  • RE: Unable to zip the backup data

    here's another model for you to use as well:

    --http://www.7-zip.org/download.html

    --http://downloads.sourceforge.net/sevenzip/7za920.zip

    --xp_cmdshell is limited to ONE set of double quotes.

    --one of the paths needs to not contain spaces!

    --see 2003 MS KB http://support.microsoft.com/kb/266224

    DECLARE @results...

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

    #1532337

  • RE: Creating a global temp table in a stored procedure

    glad I could help!

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

    #1532336

  • RE: db_creator permission not working on SQL Server 2008 r2

    not sure what the specific issue is; this works perfectly fine, whcih is just the scripting of what you said you did;

    note i'm using EXECUTE AS to directly test 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 31, 2012 at 6:09 am

    #1532335

  • RE: Creating a global temp table in a stored procedure

    you are just missing the AS keyword...and global tables have double # marks (##GlbalTemp):

    it's probably a good idea to put explicit BEGIN-END markers as well.

    do you want to create 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!

    August 31, 2012 at 6:02 am

    #1532331

  • RE: suppose the currnet drive of backup is removed and assigned with same drive letter is the scheduled backup in the drive executes???

    you are probably in good shape.

    if the expected directory structure is there, like if you were backing up to N:\SQLServer\Backups, no problem.

    if the folders are missing, it will fail. in...

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

    #1532328

  • RE: Problem:Stored Procedure in crystal report

    there's a decent thread on stack overflow that gives examples and links; note the first answer about REF CURSOR is for oracle...ignore that.

    http://stackoverflow.com/questions/552613/how-to-call-storedprocedure-from-crystalreport

    probably relevant for you:

    Try Database Expert -> (left...

    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 30, 2012 at 12:17 pm

    #1532055

  • RE: Select table names from queries

    I love the peer review here; i didn't think of spaces in table names at all...

    makes me think it's better to grab the execution plans instead, and parse the XML,...

    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 30, 2012 at 7:18 am

    #1531872

  • RE: Decimal Hours Duration to HH:MM

    Here's my first guess at it; i left lots of stuff in there to look at to help understand it.

    With PayRollHours (TheTime)

    As

    (

    SELECT 1.5 UNION ALL

    SELECT 30.75 UNION ALL

    SELECT 40.00 UNION...

    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 30, 2012 at 7:15 am

    #1531862

Viewing 15 posts - 4,816 through 4,830 (of 13,460 total)