Viewing 15 posts - 1 through 15 (of 21 total)
Because this post comes up in most searches for error 3013, I'd like to add that 3013 can also occur if you don't have enough drive space available to write...
May 10, 2018 at 7:38 pm
I've been on holidays, but here's connecting to a SQL Server 2014 RTM instance from SSMS 2014: http://imgur.com/V7IHi1Z (embedding didn't work)
I haven't been able to test the "Run As Administrator"...
March 28, 2016 at 11:30 pm
Using a schema per tenant seems to be a solution that is complicated for the sake of being complicated. As others have said: If you're unable to use Dynamic SQL...
March 2, 2016 at 11:12 pm
The option to do this via SSMS 2014 is disabled on system tables in system databases on any SQL Server (2005+ has been tested). User tables in system databases are...
March 2, 2016 at 7:23 pm
Just in case anyone arrives here from a search engine, the two places you're looking for are sys.sql_modules and information_schema.routines, although as Aaron Bertrand pointed out here (The case against...
August 31, 2015 at 10:48 pm
Just in case anyone arrives here from a search engine, the two places you're looking for are sys.sql_modules and information_schema.routines, although as Aaron Bertrand pointed out here (The case against...
August 31, 2015 at 10:23 pm
Do you want the logo to be controlled by the first row of the dataset, or by the users selecting the value from a dropdown?
This: =IIF(First(Fields!FirmID.Value, "dsDataset1") = 1, "Logo1",...
August 24, 2015 at 3:38 pm
Firstly - make sure the two images have been added to the report (they should appear in the Images folder of Report Builder). Then, put this into the "Use This...
August 24, 2015 at 12:45 am
exec master..xp_fixeddrives
select * from sys.database_files
backup database DatabaseName to disk = 'FileLocation' with init, compression, copy_only, stats = 10
restore database DatabaseName from disk = ''
with
...
August 24, 2015 at 12:37 am
It's not possible to restore a database from the actual data files.
There's only one option I can suggest without a good understanding of how everything is currently set up. I...
August 18, 2015 at 11:51 pm
kd11 (8/18/2015)
August 18, 2015 at 11:31 pm
Real time is a little tricky to do, but this will restore the database and tell you the average speed of the data transfer:
restore database DatabaseName
from disk = 'F:\backups\DatabaseName_backup_1234567890.bak'
with
...
August 18, 2015 at 11:08 pm
Unless the report returns a data source that doesn't change often (like a data warehouse that refreshes once a day), sending users the link doesn't guarantee that the report won't...
August 17, 2015 at 7:26 pm
If you can't change it, then there's no way to assure complete browser version compatibility and prevent the browser appearing. You either need to follow Andrew Ps advice, or you...
August 14, 2015 at 12:36 am
I think it would be easier to put the query you've created in Dataset2 for all the group names into Dataset1, and union those two result sets. For the result...
August 14, 2015 at 12:26 am
Viewing 15 posts - 1 through 15 (of 21 total)