This did the trick for me. http://thecodeattic.wordpress.com/category/ssrs/. Go down to step 35 to see the error you are getting. Paraphrasing: Once you’re able to log in to YourServer/Reports as an administrator, click Home in the top-right corner, then Folder Settings and New Role Assignment. Enter your user name and check a box for each role … Read more
I understand this post is old but if anybody is still searching and has not found a solution to the intellisense issue even after re-installing, applying the cumulative updates, or other methods, then I hope I may be of assistance. I have Applied SQL 2008 R2 Service Pack 1 which you can download here http://www.microsoft.com/download/en/details.aspx?id=26727 … Read more
You can create a new db then use the “Restore Wizard” enabling the Overwrite option or: View the contents of the backup file: RESTORE FILELISTONLY FROM DISK=’c:\your.bak’ note the logical names of the .mdf & .ldf from the results, then: RESTORE DATABASE MyTempCopy FROM DISK=’c:\your.bak’ WITH MOVE ‘LogicalNameForTheMDF’ TO ‘c:\MyTempCopy.mdf’, MOVE ‘LogicalNameForTheLDF’ TO ‘c:\MyTempCopy_log.ldf’ This … Read more
Although it’s good to wonder about how it might be explained that you often see the same order, I’d like to point out that it never a good idea to rely on implicit order caused by the particular implementation of the underlying database engine. In other words, its nice to know why, but you should … Read more
The usual way to store password, is to use a hash function on the password, but to salt it beforehand. It is important to “salt” the password, to defend oneself against rainbow table attacks. So your table should look something like that ._______._________________.______________. |user_id|hash |salt | |——-|—————–|————–| |12 |adsgasdg@g4wea…|13%!#tQ!#3t…| | |… |… | When checking … Read more
Best method in SQL Server 2016 Example: SELECT FORMAT(GETDATE(), ‘yyyy/MM/dd-HH:mm:ss’, ‘fa’) Answer: 1398/10/08-05:37:59
Yes, SSIS can perform the requirements that you have specified in the question. Following example should give you an idea of how it can be done. Example uses SQL Server as the back-end. Some of the basic test scenarios performed on the package are provided below. Sorry for the lengthy answer. Step-by-step process: In the … Read more
The database connection is closed by the database server. The connection remains valid in the connection pool of your app; as a result, when you pickup the shared connection string and try to execute it’s not able to reach the database. If you are developing Visual Studio, simply close the temporary web server on your … Read more
Try using the STR() function. SELECT STR(float_field, 25, 5) STR() Function Another note: this pads on the left with spaces. If this is a problem combine with LTRIM: SELECT LTRIM(STR(float_field, 25, 5))
You can use a ranking function and a common table expression. WITH e AS ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY ApplicationId ORDER BY CONVERT(datetime, [Date], 101) DESC, [Time] DESC ) AS Recency FROM [Event] ) SELECT * FROM e WHERE Recency = 1