Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 13,460 total)

  • RE: servers list in a domain

    you can manipulate the results in powershell

    [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders

    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!

    December 1, 2015 at 11:47 am

    #1843290

  • RE: Report Manager URL insufficient permissions

    man that's a classic pain point i've tripped over myself.

    i'm very sure it has to do with permissions related to folders (virtual fodlers?) within SSRS.

    go to the SSRS web site,...

    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!

    December 1, 2015 at 8:47 am

    #1843226

  • RE: SQL Puzzle

    ok, this worked pretty well for me;

    you can expand this to use char/nchar if needed, but i left it as varchar/nvarchar, as that's all i'd ever use anyway.

    no need 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!

    December 1, 2015 at 6:41 am

    #1843175

  • RE: Invalid column name in variable

    you are missing the FROM clause. you can't select a column name without it's table.

    SpeedSkaterFan (11/30/2015)

    Hi all,

    I am trying to split (incorrect) cellcontents into smaller pieces.

    If I use:

    SELECT cdsDescription

    ...

    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 30, 2015 at 12:10 pm

    #1842977

  • RE: Using CROSS APPLY instead of sub queries.

    you'll need to add the NULLIF function, i think:

    ,ROUND(( CAST(AeSubCount AS FLOAT) / CAST(NULLIF(SubCnt,0) AS FLOAT) ), 2) AS Rate

    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 30, 2015 at 9:59 am

    #1842936

  • RE: I am trying to find the record that already exists, and I get the Msg 128, Level 15, State 1 error.

    your error is your print statement, you cannot print a column's value.

    PRINT 'Record already exists in mbrship table' + mbrs_id

    you have to print something static or a variable like @mbrs_id...

    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 30, 2015 at 9:38 am

    #1842931

  • RE: SQL Azure Latest v12 update error Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violate a uniqueness constraint imposed by the target table

    gurvinderg (11/30/2015)

    My SQL Azure database has a stored procedure that has the merge statement. When my database on Azure was updated to latest v12 update , this procedure started throwing...

    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 30, 2015 at 6:33 am

    #1842853

  • RE: sp_send_dbmail return Command(s) completed successfully. instead of mailsent id

    Chirag# (11/30/2015)

    Hello SSChampion

    thanks a for your answer , from your query i can get the id but mail was not received in my inbox

    also it is not...

    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 30, 2015 at 6:02 am

    #1842850

  • RE: How can I find the source of data for a DB

    Additionally I would also look at the scheduled jobs on the server itself; there's a good chance that Extract-Transform-Load(ETL) jobs that populate your databases exists on the same server...

    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 25, 2015 at 11:45 am

    #1842379

  • RE: ssrs export to print on both sides of same paper

    SSRS would not need any changes; it's not printer aware

    Duplex printing is an end user/client setting,the specific target printer, and whether it supports double sided printing. whether to print...

    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 25, 2015 at 9:16 am

    #1842341

  • RE: sp_send_dbmail return Command(s) completed successfully. instead of mailsent id

    sp_send_dbmail returns an int output parameter, which you can capture, but you have to do so explicitly.

    [highlight="#ffff11"]declare @TheMailID int[/highlight]

    ...

    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 25, 2015 at 7:03 am

    #1842301

  • RE: how to prove network is slow

    In my experience, the network low on my list of things to review for slow running queries.

    returning trivial information, like SELECT @@VERSION should come back instantly. that would quickly show...

    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 23, 2015 at 12:14 pm

    #1841821

  • RE: SQL permissions

    Perry Whittle has posted a nice script multiple times, for example in this link:

    http://www.sqlservercentral.com/Forums/Topic1560182-1550-1.aspx

    i've grabbed his version and made it my own with minor tweaks, it's very comprehensive.

    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 23, 2015 at 12:00 pm

    #1841817

  • RE: Attempted to move tempdb to a different drive and now SQL won't start

    Bryan.avergonzado (11/23/2015)

    This is from the log. I've tried to give full control to every account I can think of. The file path is correct.

    Error: 5123, Severity: 16, State: 1.

    2015-11-23...

    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 23, 2015 at 7:11 am

    #1841712

  • RE: Restore 500 databases from a share location

    it depends on the details, but regardless, you have to generate the list of commands from some place; the msdb backup history from production, or the folder full of files,...

    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 23, 2015 at 6:43 am

    #1841689

Viewing 15 posts - 1,351 through 1,365 (of 13,460 total)