Viewing 15 posts - 391 through 405 (of 1,079 total)
Please read through this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
The above guidelines will enable us to assist you better and faster.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 20, 2012 at 1:47 am
But none of this helped.I dont see the oraoledb.oracle driver in the Linked servers providers list.I am able to connect the Oracle client with the Oracle DB.
Please advice what could...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 20, 2012 at 1:43 am
To agree and add to what Koen said.
Build a solution, and write down any error you can think of, from Data Source, Data Source View, Data Flow Source, Destination,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 20, 2012 at 1:26 am
Nice one, thanks. No room for error there.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2012 at 11:26 pm
http://www.connectionstrings.com/
This should guide you.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2012 at 11:24 pm
Confirm the following checks from your side:
1. Reportserver & ReportServerTempDB databases are present in the instance
2. All configurations have been done and error free in Reporting Services Configuration Manager
3. Open...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2012 at 12:18 pm
You can do the same SQL CAST/CONVERT to the desired datetime in the DSV, but instead of using a table or view, a SQL Query.
In the DSV, right Click, "New...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2012 at 11:49 am
Artoo22 (3/19/2012)
I don't need assistance today, but I have a comment. Why doesn't Microsoft use T-SQL coding standards?
Whenever I script a system stored proc the code looks like a dogs...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2012 at 6:26 am
Do they belong to different Roles? Sounds like the 2 users have explicit permissions in the cube to access certain data....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2012 at 11:01 pm
GilaMonster (3/16/2012)
Henrico Bekker (3/16/2012)
RESTORE HEADERONLYFROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'
WITH NOUNLOAD;
GO
Why use NoUnload? It's an option only valid if the backup is on tape. For backups on disk that option...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2012 at 2:38 am
There are some templates installed by default with the Development Studio (Data Tools).
Yep, here is some info on AlwaysOn and HA:
http://www.infotechguyz.com/SQLServer2012/NewFeaturesinSQLServer2012.html
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2012 at 1:13 am
RESTORE HEADERONLY
FROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'
WITH NOUNLOAD;
GO
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2012 at 12:45 am
Where would I even start?
Have you downloaded and installed SQL2012 RTM/RC0 yet? with it, SQL Data Tools (development studio) will install as well if chosen.
There are templates for Windows 7...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2012 at 12:44 am
We saw the same demo up here in JHB.
try searching for 2012 samples, MS, codeplex etc..
here are a few:
http://msftdbprodsamples.codeplex.com/releases/view/55330
Try creating your own application?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2012 at 12:23 am
Start here: http://www.microsoft.com/en-us/bi/default.aspx
Also keep an eye on the SSC Forums under Business Intelligence.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 13, 2012 at 7:35 am
Viewing 15 posts - 391 through 405 (of 1,079 total)