have a look at this link

http://beyondrelational.com/modules/2/blogs/28/posts/10446/how-to-find-all-stored-procedures-used-by-report-server.aspx

You could use a case statement. this will bring back the investorname of fannie mae for all records with a lendername of bank of america.

you can try the syntax out...

try running EXEC sys.xp_readerrorlog on the instance in question. Looks like someone else had similar issue here

http://dba.stackexchange.com/questions/56860/sql-server-logs-error

does it happen for other users too?

try and come out of ssms and go back in first. on the server check the eventvwr logs for application and system. And verify the log files are on the...

has this only just started happening? have you come out of SSMS and gone back in to try it again? and is it affecting anyone else?

We're getting closer, you need to restore to a drive on the server, not a network path.

You could do with knowing what the logical filenames are. They are likely to be bcc and bcc_log rather than bbc.you should be able to find out by viewing the...

Yes that's the syntax. Good page here explaining it

https://technet.microsoft.com/en-us/library/ms190447%28v=sql.105%29.aspx

You either need to get rid bccrestore which is just any empty db, or use a different db name for the restored database.

Yes even though you have changed the db name, sql will try and use the same db filenames (mdf and ldf) as the db you are restoring. you need to...

Yes or get rid of bccrestore before you run the restore script

is the instance you are restoring to on your machine? If not the backup command will be looking on the c drive of the server the instance lives on, rather...

Probably easiest to use thedateadd function

select * from table where user='sam' and (testdate between dateadd(y,-1,[testdate]) and testdate)

I believe server/cal licensing is not available for Enterprise edition, just in case that's what you need to install.