Hi Melvinlusk, Apologies, I have not idea about application level because it is supported by third party hence no involvement from our side. I had...
Many Thanks melvinlusk for assistance, I have found that full text catalog is configured on database and I have also checked in Sql Server Logs that...
Hello Friends, Currently, I'm facing the problem about SQLDMO_1 process which comes regular interval when execute the full backup of particular...
Hello Friends, Recently, I have done the following below things no able to rollback the SP3 to SP2. Copied Myssqlsystemresource database file before...
Many Thanks Satya for reply. Basically, I'm to trying to fetch the all database files details of all SQL Servers by single query. I have created the...
Hi Friends, If I execute this script EXEC sp_MSForEachDB 'SELECT ''?'', * FROM [?]..sysfiles' individual so it is executed successfully however I...
Many Thanks FrankKalis I can’t achieve this without insert the records into variable table .It would be highly appreciated if you provide any...
Hi Friends, I have table "AuditLog" which has many records (e.g. 2000000) so I need to move these record batch wise (e.g. 10000 single batch) this...
Hi Mohaamedu/Rohit, If you provide the scrip sp_compared procedure so it would be appreciated.
Hello Friends, I have found this below article which helps to compare the SQL two databases by sp_compared stored procedure however I am not able to...
Thanks Rohit, the issue has been resolve after change the database owner.
Thanks for reply, Basically I need to change the "dbo" user login as current login is "user1" but I need to change the "dbo" user login by "sa". I...
Hi Friends, I am restoring the Tes1 database by backup of another database Test2 and the "dbo" user is not mapped with any login on Test2 database....
Hi Friends, I have user and that user has add some database rolemember as like (Datareader and Datawriter). When I am genreating the script of user...
Many Thanks FrankKalis.
Hi FrankKalis, Thanks for response. My query is different as I need the month should effect dynamically and I believe the below example will help you...
Hi Friends, I have 12 columns in table and these columns I have to rename by month. For Example: Table Name : Test Column Name: L1 to L12 Output: L1...
Many thanks
Hi Friends, I have to export all the data on the AuditLog table older than 4 months (using AuditDate). Please can you provide the example of where...
Hi Friend, I have the following things however I am not able to find out the Object ID and Object Id Name by Page ID in SQL 2005. Database ID...
Separate names with a comma.
