Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 13,460 total)

  • RE: cast or convert to use "sys.fn_sqlvarbasetostr()"

    Sean Lange (11/16/2012)

    That is an interesting script. The easiest way to avoid the collision is to stop using the deprecated text datatype. Use (n)varchar(max) instead.

    i was trying a simple code...

    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 16, 2012 at 8:56 am

    #1559843

  • RE: Undocumented Routines: Forbidden fruit.

    jbayliss i'm not sure what the end results were from sp_MakeWebTask; i would assume it was a simple grid like results of the table?

    if that's true, I tossed a CLR...

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

    #1559476

  • RE: Scripting out permission for database?

    Georges link again for clarity:

    http://www.sqlservercentral.com/scripts/Permissions/76450/

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

    #1559427

  • RE: CSV file import using ssis

    can't you change it so that the ending delimiter is comma-Carriage-Return instead of just CarriageReturn?

    that would fix it 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!

    November 15, 2012 at 8:59 am

    #1559415

  • RE: Getting variable name from cursor as part of query results

    go ahead and throw your cursor away.

    the data you are looking for is already materialized for you;

    the indexes maintain a count of the number of rows for every table.

    try 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 15, 2012 at 6:33 am

    #1559327

  • RE: combining result in stored procedure ??

    another , better possibility os to create temp tables to hold the results of the two procs, and then use multiple temp tables:

    the only issue with that is knowing...

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

    #1559320

  • RE: combining result in stored procedure ??

    sumith1andonly1 (11/15/2012)

    i have the following:

    Stored Procedure 1 calls Query 1

    Stored Procedure 2 calls Query 2

    i would like to have:

    Stored Procedure 3 calling Query 1 and Query 2 and then combine...

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

    #1559317

  • RE: xp_cmdshell access denied to desktop file when logged as administrator - why ?

    ntingab (11/15/2012)

    Thank you Lowell

    glad this post helped you, ntingab!

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

    #1559307

  • RE: Use Custom Color in a Central Management Server Doesn't Share

    pretty sure those settings are stored on the machine you set it up on.

    for my SQL2012, it actually in %appdata%\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin,

    and similar folders for 2008 or R2.

    you'd 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!

    November 14, 2012 at 2:51 pm

    #1559142

  • RE: fresh install of SQL Server 2008 and 'Cannot connect to (local)'

    also, an express edition usually installs a named instance (.\SQLEXPRESS for example) and not a default instance that will answer to (local)

    look in Control Panel/Administrative Tools>>Services and see if it's...

    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 14, 2012 at 2:39 pm

    #1559137

  • RE: automate t-sql

    with what you've shown so far, you can certainly do them all at once; so you've left some important details out of the question at hand.

    it's probably more a question...

    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 14, 2012 at 2:19 pm

    #1559122

  • RE: Finding set dates given a single date

    from my notes, which i swear i use daily when fiddling with dates:

    --another midnight

    CAST(DATEDIFF(dd,0,somedatetime) AS DATETIME).

    this is one of the coolest things to use once you get your head...

    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 14, 2012 at 11:51 am

    #1559062

  • RE: Why does this query use up 70G in tempdb

    ok, i see starting from right to left, when it gets to the right merge join, it's dealing with 14 trillion rows of data... a couple of those operations...

    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 14, 2012 at 11:45 am

    #1559058

  • RE: Can anyone help with GROUP BY error message??

    i've had that happen to me before;

    you can change the database compatibility level (to 80?), and that will suppress the error.

    alternatively, the error says what the issue is.

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

    November 14, 2012 at 9:56 am

    #1559029

  • RE: Scripting out permission for database?

    you'll need to get a copy of sp_help_revlogin from microsoft; there are different versions, depending on 2000/2005, maybe even for 2008 and above, i don't quite remember.

    assuming you are going...

    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 14, 2012 at 9:43 am

    #1559019

Viewing 15 posts - 4,381 through 4,395 (of 13,460 total)