tag:blogger.com,1999:blog-2029072262337060983.comments2023-07-31T15:28:40.130+05:30The SQL IdeasParesh Prajapatihttp://www.blogger.com/profile/01031181680771363872noreply@blogger.comBlogger122125tag:blogger.com,1999:blog-2029072262337060983.post-33337714095171085692019-11-01T18:42:22.623+05:302019-11-01T18:42:22.623+05:30Nice, I prefer the second method. However, TQSL is...Nice, I prefer the second method. However, TQSL is also ok.Petehttps://www.nakivo.com/industry/vsphere-replication/noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-51584597992190126202019-10-22T16:58:17.495+05:302019-10-22T16:58:17.495+05:30Awesome solution! Thanks you...Awesome solution! Thanks you...Basscrazihttps://www.blogger.com/profile/01455673753711785573noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-61828376511206401652019-10-20T17:05:15.194+05:302019-10-20T17:05:15.194+05:30Thanks so muchThanks so muchdanhttps://www.blogger.com/profile/05551677434921194155noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-14866649167725244502019-10-11T11:36:11.824+05:302019-10-11T11:36:11.824+05:30It will reset to default setting for import export...It will reset to default setting for import export only, how can i reset all settings?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-13918873836931352662019-09-10T01:03:42.357+05:302019-09-10T01:03:42.357+05:30Thanks! This helped, didn't notice the databa...Thanks! This helped, didn't notice the database dropdown.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-60428803300742303782019-04-19T01:36:00.745+05:302019-04-19T01:36:00.745+05:30Excellent ans with sampleExcellent ans with sampleAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-5911623088070468912019-03-19T23:52:19.786+05:302019-03-19T23:52:19.786+05:30The double quotes work just fine in SQL Server too...The double quotes work just fine in SQL Server too :) I've never understood why SQL Server doesn't recommend using standard double quotes.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-60009305637246236702019-03-14T10:59:38.235+05:302019-03-14T10:59:38.235+05:30Thanks for the post. This helped me with a differ...Thanks for the post. This helped me with a different permissions error. <br /><br />Using SQL Profiler and the "grant execute on" command, I was able to resolve my permissions issues.Will Chunghttps://www.blogger.com/profile/13757431779405285382noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-60807012088581895332015-01-01T02:41:13.377+05:302015-01-01T02:41:13.377+05:302 percent processed.
4 percent processed.
6 percen...2 percent processed.<br />4 percent processed.<br />6 percent processed.<br />8 percent processed.<br />Msg 3634, Level 16, State 1, Line 1<br /><br />The operating system returned the error '32(The process cannot access the file because it is being used by another <br />while attempting 'OpenFile' on 'E:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\TEST_ONLINE_2_new.filestreamdata\16af32a0-74f5-4513-a8b2-27301072939d\c2ed4313-2da4-420d-8dcf-a8c5b02da324\00008ecd-0000d988-000a'.<br />Msg 3013, Level 16, State 1, Line 1<br />RESTORE DATABASE is terminating abnormally.<br /> <br /><br />Regards,<br />www.dineshvishe.wordpress.comDinesh Dattatray Vishehttps://www.blogger.com/profile/13868059157409060698noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-10288452220295441582014-04-09T15:26:17.448+05:302014-04-09T15:26:17.448+05:30Above described method is helpful to restore full ...Above described method is helpful to restore full database from multiple backup files without having any trouble. U can check another method here to restore multiple sql server bak files.<br />restoresqlbakfiles.blog.fc2.com/Anonymoushttps://www.blogger.com/profile/08973554795967252099noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-18030689304424627172014-03-17T12:36:23.254+05:302014-03-17T12:36:23.254+05:30Can I installed the same versions of SQL server 20...Can I installed the same versions of SQL server 2008 R2 on same server ?Anonymoushttps://www.blogger.com/profile/12747940070544848185noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-32056054623515830122014-02-28T06:39:21.682+05:302014-02-28T06:39:21.682+05:30so to the point! Thank you !!!!!!1so to the point! Thank you !!!!!!1Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-68802297735057405342013-09-13T14:47:50.752+05:302013-09-13T14:47:50.752+05:30Thanks Paresh, I liked this article very much! I ...Thanks Paresh, I liked this article very much! I like the flow and the screenshots helped a lot too. Also wanted to share this one right here that's good:<br /><br /><a href="http://www.programmerinterview.com/index.php/database-sql/database-roles/" rel="nofollow">Roles in Database</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-78986043689633569462013-07-29T19:09:14.450+05:302013-07-29T19:09:14.450+05:30thanks for your post... how about using this to ba...thanks for your post... how about using this to backup multiple database, having the same multiple files output. is it possible, or there's another approach/way to do it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-88857103329433401352013-06-29T22:03:33.661+05:302013-06-29T22:03:33.661+05:30Thank you for this unique article. You guided me w...Thank you for this unique article. You guided me well.best gadget reviewshttp://bestgadgetreviewsn.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-32253137394078091872013-04-27T18:25:14.865+05:302013-04-27T18:25:14.865+05:30Dear friend. I truly just like your posting and yo...Dear friend. I truly just like your posting and your current web page all in all! That write-up is really plainly composed and without difficulty understandable. Your Wordpress style is awesome as well! Would be awesome to discover exactly where My partner and i are able obtain this. Please hold up the very good work. We all need much more this kind of website owners just like you on the web and much less spammers. Wonderful man!<br />http://www.mindqonline.com/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-16739911993163177442013-04-15T17:52:39.575+05:302013-04-15T17:52:39.575+05:30Paresh is known to be a reputed consulting firm fo...Paresh is known to be a reputed consulting firm for SQL SERVER related<br />Courses with top talented database professionals and software engineers <br />coming from some of the most established and most successful software developmentand<br />technology consulting firms around the globe for providing a tailored-made solutions to<br />their clients at the very best of their knowledge and liable time.<br />http://www.sqlservermasters.com/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-8277300329077889012013-04-15T17:51:41.773+05:302013-04-15T17:51:41.773+05:30Paresh Provides Online Training by Real Time Profe...Paresh Provides Online Training by Real Time Professionals from Hyderabad,India ,For Testing Tools|SQL Server 2012 DBA Online Training|MSBI|.net 4.0|DOT Net 4.0|Selenium Online Training|Mobile Testing|Database Testing|Sharepoint training Institute In India.<br />http://www.mindqonline.com/<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-46429224161898343462013-04-13T16:21:59.418+05:302013-04-13T16:21:59.418+05:30Thanks for sharing the recovery guide. I would lik...Thanks for sharing the recovery guide. I would like also to suggest you a third party utility, with the help of this software we can recover your data in few minutes. Website offering free version also. visit the urls to get more information.<br /><br /><a href="http://www.recoverydeletedfiles.com/sql-database-recovery-software.html" rel="nofollow">http://www.recoverydeletedfiles.com/sql-database-recovery-software.html</a><br /><br /><br />Thanks<br />Anonymoushttps://www.blogger.com/profile/08507247908134631233noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-71508083600627907782012-12-12T00:56:38.341+05:302012-12-12T00:56:38.341+05:30Dear Author,
The script runs fine but i am unable...Dear Author,<br /><br />The script runs fine but i am unable to get the database restore?Farrukhhttps://www.blogger.com/profile/14679959877595383065noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-64512352304553146202012-11-05T18:21:28.186+05:302012-11-05T18:21:28.186+05:30Yes. We can install different versions in the same...Yes. We can install different versions in the same server. I installed 2000.2005 and 2008 in the same machine with different instances. by my question is can we install 2008 and 2008 R2 in the same machine ? <br />Actually I developed a report in r2 with data bars in different machine. When I am copying that report to my machine its giving error. then I came to know SQL server 2008 not having data bars. <br />Anonymoushttps://www.blogger.com/profile/05507256615112313688noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-78536953152689243162012-08-20T17:22:42.374+05:302012-08-20T17:22:42.374+05:30i dont knowi dont knowAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-25300228121536035822012-06-14T23:12:46.635+05:302012-06-14T23:12:46.635+05:30So does this include the Express edition also?So does this include the Express edition also?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-69976646219294070012012-06-13T10:41:36.530+05:302012-06-13T10:41:36.530+05:30GReat explation............GReat explation............Dinesh Dattatray Vishehttps://www.blogger.com/profile/13868059157409060698noreply@blogger.comtag:blogger.com,1999:blog-2029072262337060983.post-49169722912406570772012-06-06T10:34:37.183+05:302012-06-06T10:34:37.183+05:30its very helpful information....nice work by autho...its very helpful information....nice work by author...<br />refer my site...<br />http://skyofkp.blogspot.in/Sky of KPhttp://skyofkp.blogspot.in/noreply@blogger.com