Viewing 15 posts - 6,346 through 6,360 (of 11,676 total)
Regarding SSMS: you can install SSMS 2012 and still manage your 2005 server with it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:24 am
Not necessarily. The reporting databases don't have to be on the same server. They can be installed on another server then the one SSRS is installed one.
I would check the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:22 am
There's a 2010 version of SQL Server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:20 am
I alerted the author of the book (mr. Wharty) about this error a few weeks ago and he did in fact recognise it as an error. (hence the inclusion in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:17 am
Clicking Yes?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:14 am
emile.milne (10/30/2012)
Can reporting services service and the Reporting dbs reside on different servers. I'm hoping the answer is NO.
Why would you hope for the inflexible solution?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:11 am
Great question! Always good to have some 2012 questions.
For people who want to learn more about the subject, this is an amazing book:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 1:31 am
Brandie Tarvin (10/29/2012)
This is the first I've heard of ransomware. Thanks for the heads up on it.
They can be pretty nasty.
Most of them disable the task manager, regedit and your...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 29, 2012 at 4:49 am
ChrisM@home (10/28/2012)
L' Eomot Inversé (10/27/2012)
L' Eomot Inversé (10/26/2012)
WayneS (10/25/2012)
Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.
Some malware has reduced...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 29, 2012 at 4:33 am
Interesting question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 29, 2012 at 3:57 am
I saw a job advert a few months ago demending experience with PowerView. That piece of software was just released a few weeks on the market. So they probably wanted...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2012 at 6:32 am
You can use CHAR(10) + CHAR(13) to add a carriage return.
Example:
SELECT 'This is a ' + CHAR(10) + CHAR(13) + 'test!'
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2012 at 3:46 am
Check out this thread:
http://stackoverflow.com/questions/1195324/using-the-result-of-the-sql-messages-pane
It's not possible in SQL Server itself, but it might work in a client application.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2012 at 12:29 am
WayneS (10/25/2012)
Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.
I was already wondering why my inbox was so empty. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2012 at 12:08 am
The backslash is a special character, you need to escape it with another backslash.
substring([Column 0],findstring( [Column 0],"TH",1),findstring( [Column 0],"\\",1))
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 26, 2012 at 12:03 am
Viewing 15 posts - 6,346 through 6,360 (of 11,676 total)