Viewing 15 posts - 46 through 60 (of 109 total)
Have you tried following steps:
Fix/WorkAround/Solution: Try all the suggestions one by one.
Suggestion 1: Make sure that on Mirror Server the database is restored with NO RECOVERY option (This is...
June 11, 2012 at 7:18 pm
I think the SSIS only check file once, however you could use process monitor to check.
June 8, 2012 at 12:09 am
You may need to setspn for these two instances.
http://msdn.microsoft.com/en-us/library/ms191153.aspx
June 8, 2012 at 12:06 am
Here is one example, you could modify this script accordingly.
Create TRIGGER [dbo].[Tr_Test_Table_Audit]
ON [dbo].[Test_table] FOR INSERT, UPDATE, DELETE NOT FOR REPLICATION
AS
-- SET NOCOUNT ON added to prevent extra result...
June 7, 2012 at 11:59 pm
error: "Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied)
It seems your SQL Service account couldn't access your file. Make sure you...
June 4, 2012 at 7:46 pm
Thanks, i will try later. Have a nice day!
May 30, 2012 at 7:14 pm
Is the database registry changed? can you show me which registry?
I have the same problem and not figure out what happened. Thanks!
May 30, 2012 at 1:00 am
Thanks for the reply. Can you show me how to enable .NET tracing. Our application is not a Web application, it is a client application published with Citrix.
May 29, 2012 at 7:52 pm
1) create a new table with the correct datatype (BIGINT) for the column in question;
(2) load the new table with the data from the original table in chunks; that will...
May 29, 2012 at 7:45 pm
You can try this:
When you first print something you are asked to download and install RSClientPrint.dll. This library resides in c:\windows\Downloaded Program Files. For some unknown reason this file...
May 29, 2012 at 7:41 pm
You should incease the column, such as from varchar(10) to varchar(50), sorry to make you confused. 🙂
May 29, 2012 at 1:32 am
Found this: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB
Becuase repair_allow_data_loss could make data lost, so it is better to restore from an...
May 29, 2012 at 1:05 am
check this out:Col002" (30)" failed because truncation occurred, you meed need add more space for this column.
May 29, 2012 at 1:00 am
It seems metedata issue and i got the same problem before and finally restore to the same version the export data to higer version.
May 29, 2012 at 12:58 am
I got the same problem before and finally restore to the same version then export data to the higer version.
May 29, 2012 at 12:51 am
Viewing 15 posts - 46 through 60 (of 109 total)