Forum Replies Created

Viewing 15 posts - 9,151 through 9,165 (of 13,460 total)

  • RE: SQL Dependency or Change data capture

    why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?

    then the view will never be out of sync, and will have...

    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 30, 2010 at 6:23 am

    #1187003

  • RE: Non-logged table ?

    i thought table variables were exempt? i know if they are in a transaction, and the transaction is rolled back, the table variable is unaffected...does that mean it's not logged,...

    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 29, 2010 at 3:18 pm

    #1186733

  • RE: CMDexec job hanging in SQL server

    it's not access to the exe.

    once again, the point i'm making is the exe trying to use the security context nt authority\system for example to access files or file shares....

    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 29, 2010 at 12:15 pm

    #1186596

  • RE: Query LDAP server from SQL server

    kelvin this may or may not be much help;

    i have this saved in my snippets for creating a linked server to Active Directory, and then querying it...in my case, i...

    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 29, 2010 at 12:07 pm

    #1186592

  • RE: CMDexec job hanging in SQL server

    i guess you missed my point; take a look at this thread, where someone had a very similar issue to yours.

    http://www.sqlservercentral.com/Forums/Topic944084-392-1.aspx#bm944497

    my point is that even though local system can access...

    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 29, 2010 at 11:30 am

    #1186560

  • RE: Questions about permission via Stored Procedures

    the issue is the dynamic SQL; if that is used in a proc, the calling user needs to have the rights to the underlying object for whatever the proc is...

    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 29, 2010 at 11:16 am

    #1186551

  • RE: CMDexec job hanging in SQL server

    details? the account cmdexec/xp_cmdShell runs under is local system , you said, right? that account might not have rights to a local folder(ie C:\Documents and settings\SomeUser) or to a \\UNC...

    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 29, 2010 at 11:10 am

    #1186547

  • RE: CMDexec job hanging in SQL server

    could your application be raising a pop-up/error message window? so when it is run from cmdexec, maybe with a misspelled parameter or something, it seems to be running forever because...

    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 29, 2010 at 11:00 am

    #1186540

  • RE: user creation

    SYSTEM stored procedures? like sp_who? i think that is inherited with CONNECT permissions, but i'm not sure what you are refering to.

    can you script out the user you created and...

    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 29, 2010 at 8:15 am

    #1186412

  • RE: xp_cmdshell issue

    hmm...rereading your issue, you said it is"SQL query analyser it runs continuously, seemingly without end"...

    could your application be raising a pop-up/error message window? so when it is run from QA,...

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

    #1186280

  • RE: Is there a better way?

    wouldn't log shipping be an option? a zip of the log file of changes would be much smaller than the 9 gig backup, zipped or not, and your bandwidth would...

    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 28, 2010 at 12:43 pm

    #1185965

  • RE: 3 distinct columns

    dunne do you mean you want to show the existing DISTINCT combinations of the three values, or do you mean that you want to force three distinct lists, but put...

    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 28, 2010 at 12:01 pm

    #1185953

  • RE: xp_cmdshell issue

    Chris Hazeldene (6/28/2010)

    I've logged onto the server (Windows Server 2008 - MSSQL 2008) as the Admin in an attempt to rule out any permissions issue.

    xp_cmdShell does not use 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!

    June 28, 2010 at 10:54 am

    #1185932

  • RE: Filling a LIst table with Dates

    here's a simple and fast example: just add the insert into:

    --ten years before and after todays date:

    with TallyCalendar 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 28, 2010 at 10:46 am

    #1185926

  • RE: Enterprize manger not responding!!

    Remember one of the design annoyances in Enterprise Manager was that when it starts, it iterates thru and opens every database....so if your server has a lot of databases, it...

    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 28, 2010 at 6:32 am

    #1185677

Viewing 15 posts - 9,151 through 9,165 (of 13,460 total)