Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 13,460 total)

  • RE: xp_cmdshell - Procedure expects parameter 'command_string' of type 'varchar'

    riswana (11/1/2012)

    Hi,

    I am having the same problem. My query string is greater than 8000 characters. I am using varchar(max).

    Can someone assist urgently with a result, please.

    On computers running...

    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!

    November 1, 2012 at 7:32 am

    #1554997

  • RE: 100 Most famous interview Questions and Answers

    here's a link to a copy of the pdf that doesn't require his damn password.

    boy that pissed me off for some reason.

    oh, and some of his code example references 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!

    November 1, 2012 at 7:25 am

    #1554994

  • RE: Sending remote attachments using sp_send_dbmail

    opc.three (11/1/2012)

    Lowell, do you have any definitive info on whether the Server Proxy extends to other external operations besides xp_cmdshell? I would be interested in a reference to 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!

    November 1, 2012 at 6:56 am

    #1554984

  • RE: Sending Mail

    kapil_kk (11/1/2012)

    How to send a mail through Storedprocedures with out using system stored procedures

    What? without system stored procedures? like msdb.dbo.sp_send_dbmail?

    so you are saying instead of using the built 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!

    November 1, 2012 at 6:49 am

    #1554979

  • RE: quickly parse the query for the problem

    these issues are notoriously hard to dig for...there's a connect item out there stating why not add the column name of the violating size issue to the error message.

    because this...

    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!

    November 1, 2012 at 5:52 am

    #1554962

  • RE: create sql server login to allow the user to change when he first logins

    note that the end user may have troulbe if they don't use SSMS for connecting;

    as an example, i created this login:

    USE [master]

    GO

    CREATE LOGIN [ExampleLogin]

    WITH PASSWORD=N'NotTheRealPassword'

    ...

    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!

    October 31, 2012 at 1:42 pm

    #1554762

  • RE: Kill process or user

    I have this procedure to help me kill users in a specific database:

    usage is this easy:

    sp_kill DatabaseName

    and the code:

    CREATE PROCEDURE sp_Kill ...

    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!

    October 31, 2012 at 1:15 pm

    #1554755

  • RE: BCP text file is adding an extra line at the end of the file

    if you are selecting a row that is full of nulls, it would appear as an "extra" line in your file when BCP is finished.

    here's a working example, assuming...

    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!

    October 31, 2012 at 12:04 pm

    #1554738

  • RE: How to find Procs/Views/Functions using particular database?

    something that might help a little bit:

    if you create a procedure that references a non-sys object in another database, you can find it via the sys.dm_sql_referenced_entities() function

    here's an example...the server/database/table...

    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!

    October 31, 2012 at 9:16 am

    #1554653

  • RE: Sending remote attachments using sp_send_dbmail

    It sounds like the account used in Services has access to the shares(because that's what sa /sysadmin's would use for credentials outside of SQL server, but that the proxy_account 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!

    October 31, 2012 at 8:43 am

    #1554642

  • RE: need documentation steps to upgrade sql2005 workgroup editon to sql2005 standard editon

    naga.rohitkumar (10/31/2012)

    Hi to every one need reply soon

    1. what are the all possible ways to upgrade sqlserver 2005 work group edition into sql server standard edition.

    If you 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!

    October 31, 2012 at 7:09 am

    #1554582

  • RE: finding char based on ascii value in Ireport

    anandhaksc (10/30/2012)

    Yes..But i need in Ireport expression..How to do it..please help me...

    i had not heard of iReport before your post, i was expecting a SQL related question, of course.

    i guess...

    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!

    October 31, 2012 at 5:31 am

    #1554548

  • RE: Passing servername as parameter in sqlserver.

    ok weird requirement, this won't work if ad Hoc is disabled, obviously.

    this works for me on my dev machine, which does allow adhoc:

    --DROP PROC pr_Processes

    CREATE PROCEDURE pr_Processes

    @SERVERNAME varchar(128)

    AS

    BEGIN --PROC

    DECLARE @sql...

    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!

    October 30, 2012 at 2:53 pm

    #1554392

  • RE: BCP Command

    justin_post (10/30/2012)

    On the front end, new students get added regularly. If I used the view I created today, on Friday, it wouldn't contain any new students that had been added...

    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!

    October 30, 2012 at 1:17 pm

    #1554349

  • RE: BCP Command

    justin_post (10/30/2012)

    One more thing, with the data constantly changing, will I need to create a view each day or how would I make sure that the data stays up 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!

    October 30, 2012 at 12:31 pm

    #1554324

Viewing 15 posts - 4,456 through 4,470 (of 13,460 total)