Viewing 15 posts - 121 through 135 (of 392 total)
The free edition of Sharepoint called Foundation is crap for BI, you need the enterprise version:
http://msdn.microsoft.com/en-us/library/hh231680.aspx#bkmk_vers
Powerview is the way to go, self service BI but unfortunately requires the licenced edition....
December 23, 2013 at 6:04 pm
It could be something to do with declaring the VB variable "dt" as a string and not a date, causing a bad conversion of the dt string to a datetime...
December 23, 2013 at 5:46 pm
Are you upgrading the SQL database engine/instance or just SQL Management Studio (the client tools)?
If you are upgrading the instance, you can perform an edition upgrade via the install media...
December 23, 2013 at 4:29 pm
The app is probably specifying a port number (eg. 1434 is the default DAC port) in the connection.
December 23, 2013 at 3:58 pm
It's fine as long as log backups are not being taken by the maintenance plan or anything other than the log shipping job.
http://technet.microsoft.com/en-us/library/ms175480%28v=sql.105%29.aspx
Make sure that the backup retention of the...
December 23, 2013 at 3:50 pm
By default, windows admins do not get access to the SQL instance. You need to specifically grant access during installation. If you used the default during installation, you...
December 23, 2013 at 3:05 pm
There is a slightly better explanation of Error 18056 and why pooled connections raise those messages here: http://blogs.msdn.com/b/psssql/archive/2013/02/13/breaking-down-18065.aspx
State 28 'RedoLoginSessLang' suggests that the session was attempting to change the Language...
December 23, 2013 at 6:18 am
What permissions do you have on the SQL instance and database?
Connect to the instance using SSMS and confirm you can navigate the database objects, confirm your level of...
December 23, 2013 at 5:58 am
Does it fail if you run it again at a different time?
It might be a table that is dropped / recreated frequently or during the maintenance period. ...
December 23, 2013 at 5:50 am
Are you on SQL2008R2 SP2? http://support.microsoft.com/kb/2634571
http://blogs.msdn.com/b/psssql/archive/2012/02/23/a-faster-checkdb-part-ii.aspx
Try DBCC CHECKDB WITH PHYSICAL_ONLY
December 23, 2013 at 5:26 am
You need to completely uninstall the express edition - you might need to go via control panel, change installed program and uninstall that way.
Reboot.
Install SSMS from the standard edition media.
December 23, 2013 at 5:12 am
Not easily. It is the same question for a client modifying a row in SQL, how do you know what has changed?
You would need to enable Change Tracking or...
December 17, 2013 at 10:31 pm
Whats in the Datawarehouse_Reporting.dbo.GeometricLinking function?
What is the datatype of IndexValue?
Does the query plan change very much after removing the order by?
December 17, 2013 at 8:10 pm
The PDFs would need to be uploaded to a web server then linked, or stored in a shared folder with the correct permissions. To create the link on the...
December 16, 2013 at 11:34 pm
As I understand it, Always On Availability groups required SQL2012 enterprise edition, 'Always On' Failover Clustering is supported in SQL2012 standard edition.
December 16, 2013 at 9:18 pm
Viewing 15 posts - 121 through 135 (of 392 total)