Lincoln Burrows
Forum Replies Created
-
Posts
-
I found an informative blog about this problem here that reference:http://www.sqlserverlogexplorer.com/fix-error-message-40/
Hi Kerry,
You can integrate the other’s account NSF file to your main account by using the software which I had already mentioned above.
You should go through and check the features of this product.Hi Andrew,
As far as I know, the tool is designed to remove the duplicate contents from within the folders, which I checked while going through its demo version.
There is a separate dialog box in the software where you can check “Remove Duplicate” option to merge the files without any duplicates included.Hi,
The solution to this problem can be successfully sorted by using a third party software tool, as there is hardly any manual trick which works in this case.
I found a useful utility that goes by the name of SysTools NSF Merge, which can easily combine multiple NSF Archive Database files to a single file.
I suggest you to first try its demo version and then decide whether it fulfills your needs or not.
Check the below link to know more.
http://www.systoolsgroup.com/nsf-merge/Make sure:
1.The site can communicate with the server
2.Remote connections are allowed.
3.Named pipes/TCP is enabled.
4.Enabled everything in SQL Server Configuration Manager.Use Generate SQL Server Scripts Wizard to help guide the creation of SQL script’s that can:
• copy the table schema
• any constraints (identity, default values, etc)
• data within the table
• and many other optionsYes you can delete it from the command prompt try this
EXEC xp_cmdshell 'SQLCMD -U <user> -P <password> -Q 'EXEC sp_MSforeachtable @command1 = "DROP TABLE ?" ' ,no_outputYou should try this too
SELECT 'USE Serv DROP TABLE [' + SCHEMA_NAME(schema_id) + '].[' + name + ']' FROM sys.tables SELECT ' USE Serv DROP PROCEDURE [' + SCHEMA_NAME(schema_id) + '].[' + name + ']' FROM sys.proceduresIf SQL Server hasn’t been restarted, then you may be able to find the query in the plan cache.
SELECT t.[text] FROM sys.dm_exec_cached_plans AS p CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t WHERE t.[text] LIKE N'%something unique about your query%';You can Monitor SQL queries by SQL Profiler if you need it
Rebuild all indexes on a table using SQL Server Management Studio
In Object Explorer, connect to Instance Services.. and then expand that instance
Expand Database that contains the table with the specified indexes, then expand Tables
Expand the table in which the indexes belong
Right click on the Indexes and then select Rebuild All and click OK
check, may the procedure is dropped or not exist
Try this Code:
chown www-data /database locationhave you run the DBCC CHECKDB on the database?
Connect to the Database Engine and execute the following query
USE master; GO ALTER DATABASE AdventureWorks2012 REMOVE FILE testfile; GOFunctions are computed values and cannot perform permanent environmental changes to SQL Server (i.e. no INSERT or UPDATE statements allowed).
A Function can be used inline in SQL Statements if it returns a scalar value or can be joined upon if it returns a result set.Open the registry and search for key LoginMode under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
Update the LoginMode value as 2.can i hide all user database for all logins?
Off course not, you will not get any compatibility issues while OST to PST conversion. Any version of your OST file is compatible with the tool. And the converted PST file, you can access in your Outlook 2007 without any doubt