Viewing 15 posts - 346 through 360 (of 1,079 total)
Please don't cross post.
al replies here: http://www.sqlservercentral.com/Forums/Topic1275562-1633-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 30, 2012 at 1:30 am
Can we apply one licence key for more than one SQLServer2008 R2 developer installation?
or
Can we apply one licence key for only one SQLServer2008 R2 developer installation?
I am not a licensing...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 30, 2012 at 1:14 am
Does SQLServer 2008 R2 Developer edition Supports the SSRS?
Yes it does.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 30, 2012 at 12:01 am
Does SQLServer2008 R2 Supports the SSRS?
Can we update SQLServer 2005 Reporting Services to SQL 2008?
1. Yes
2. Yes - Links below on help
http://technet.microsoft.com/en-us/library/ms143724.aspx
http://technet.microsoft.com/en-us/library/ms143747(v=sql.105).aspx
http://www.sqlservercentral.com/Forums/Topic708977-147-2.aspx#bm1173228
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 29, 2012 at 11:40 pm
Not happy that it worked, that was the worst advise I've ever given.
But, I have had to use it on non-production systems once or twice as well.
Never, ever, ever, use...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 6:20 am
Quick, dirty and ugly way (if you are desperate).
Stop SQL Service, drop the mdf and ldf files manually.
Start SQL, note the corrupt DB, right click delete.
OR:
sp_who2
Check who/what is connected to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 6:03 am
Already tried different media for RTM...no difference.
I'm also surprised that RC0 works, but RTM fails on same setup......
Not sure if it's worth sending to MS ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 5:12 am
Update:
RC0 installed without any issues. RTM still failing.
Now I'm confused :hehe:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 4:35 am
Do you understand Data Warehousing concepts?
Does the Kimball Methodology ring a bell?
What's the difference between MDX/DMX/DAX?
Differences between MOLAP/ROLAP
How do you schedule an automatic cube processing task?
Can you define time...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 4:31 am
Sqlchicken (3/27/2012)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 4:06 am
And the excel ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 3:32 am
Which platforms are your SQL and Excel, 32 or 64 bit or mixture?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 3:24 am
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test\test.xls;',
'SELECT FirstName, LastName FROM [Sheet1$]')
SELECT FirstName,LastName FROM Users
GO
Your reference to 'Excel 8.0' indicates Excel 1997, not 2007, which is 12.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 3:08 am
I assume you run sql 2008 and Excel 97?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 3:03 am
Run the query from Excel to extract the data, rather than pushing it into xls.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2012 at 2:55 am
Viewing 15 posts - 346 through 360 (of 1,079 total)