Tag Info

New answers tagged

0

I'd have left this as a comment but I want to quote some code, so I'm doing it here instead. I'd start with trying to track down where the lock is happening. The next time you've got a lock, gather some data. On the MS SQL server run the following: USE master select text,wait_time,blocking_session_id AS "Block", percent_complete, * from ...


1

(Aside: I hope you're also running SQL Server backups. As in, from inside SQL Server. Moving right along....) This depends partly on the actual data types you use in your tables and they types of queries you more commonly run. For example, an integer column uses 4 bytes to store data no matter which integer you store there. A datetime uses 4 bytes to ...


0

Sql database are a bit like a big excel spreadsheet . There is column and line . When you remove data he don't shrink the database because he don't remove line and data , only the value (and he store in the log file the change if you are full log mode). You have to backup the database to reclaim space on log and storage file . (log and mdf) .


0

For these who still come across this type of issue. Check if the account your server is running on has not changed the password in the meantime. The server will continue to work untill the next restart, but it will fail to authenticate on remote share.


0

I don`t have any permissions yet to comment :( I searched for more people with the same issue. And the only difference I see is that they put the information inside ''. sp_dropserver 'old_server_name' GO sp_addserver 'current_server_name','local' GO …and then restart SQL Server for the changes to take effect.


3

There is no .NET 4.5 requirement for SQL Server 2008. SQL Server 2008 pre-dates .NET 4.5 by quite a few years. Additionally, I have many SQL Server 2008 R2 installations that do not have this requirement. I suspect you are not actually installing SQL Server 2008. Where did you get the installers from? What was their download links? The correct download link ...


0

I suspect that you need an earlier version of the software. Recent updates have likely added support for .NET 4.5, which you will not be able to use. Unfortunately, Microsoft may not provide a download for you.


0

Ultimately, this is a security related issue. If you have regulatory frameworks you must adhere to then that should be your guidepost. HIPAA PCI DSS SEC All of these require independence. Additionally, if you have a public server that is the front end for these servers they should not have domain account in your user domain. There should be a domain ...


1

I know this question is old, but in case anyone else stumbles here looking for the solution, you should check permissions on the Analysis Services Cube. Excel accesses the Cube in order to create the reports, so you must have access there as well as on the Tfs_Warehouse Db (same permissions required -- "TfsWarehouseDataReader"). In SSMS, click on "Connect" ...



Top 50 recent answers are included