here's the article i have bookmarked from Paul Randal, as mentioned above.

http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/

you can manipulate the results in powershell

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

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,...

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...

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

...

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

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

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

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

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...

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...

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...

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...

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]

...

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...

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.

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...