Hello, I have time-out for reports that last more than 120 sec. I have tried all the steps explained here:...
Thanks for your quick reply. So if i understand, there is no way to store those files in several directories.
Hello, I have to implement Sql Server 2008 FileStream for a project with more than 14000000 files. Is it possible to store a filestream column of...
Hello, I am facing problem while accessing Report Manager by using the machine name with Internet Explorer (It works with FireFox). it prompts me...
Thanks a lot Mohammed.
Hi, I want to know if the mirroring session on the principal truncates log records after those logs have been committed on the mirror. Being the...
Thanks for your help!
Hello Everybody, I'm involved in a migration project and I need some help. I have to import data from 300 tables by using SSIS. I want to know if...
The database I'm trying to restore is about 40GB. I tried with a database of 150 MB, it's succeeded.
Here is the command: restore database mobileweb from disk='F:BACKUPmobileweb_backup_200705090200.bak' with move 'mobileweb_Data' to...
I used both, SSMS and the query editor, still i've got the same error. I reinstalled sql server on that server, but i have the same problem. Thanks...
Yes all the sql servers involved have the same sp (sp2 actually). Thanks
It's a sql server 2005 backup.I'm not using another program. I've tried on SSMS and on query editor, I have the same error. Thanks.
Hello, I'm having a problem during the restore process of a database of 80GB size. Here the error message, it's a sql server 2005 SP2:...
Hello, I have a storedProcedure that i execute via query-analyzer and i takes 40 minutes to complete.When i run it via a scheduled batch file (with...
Thanks a lot for help.
Hello, How can I know a drive total space using SQL-DMO or T-SQL (stored procedure or extended stored procedure). Thanks
I've checked with Index Tuning Wizard and the indexes are in place.
This query takes more than 20 seconds to execute. Anyone has an idea on what is wrong. Thanks....
How can I check if a Sql server is up and running using Transact-Sql.
Separate names with a comma.
