registeringerror3yx.blogspot.com
Registering Error: release database unused space
http://registeringerror3yx.blogspot.com/2012/03/release-database-unused-space.html
Friday, March 30, 2012. Release database unused space. I have deleted 100K records from a table in a database. I ran the DBCC shrin. Kfile and DBCC shrinkdatabase to have the database release the space. I see no. Reduction in the database size. I have run the following;. DBCC SHRINKFILE (Virten1 dat, 100) - Data File Name. DBCC SHRINKFILE (Virten3 dat, 100) - Log File Name. BACKUP LOG VIRTEN WITH TRUNCATE ONLY. DBCC SHRICKDATABASE (VIRTEN, 20). Nother method to release the space. I have run the following;.
registeringerror3yx.blogspot.com
Registering Error: Relay Error Using Database Mail
http://registeringerror3yx.blogspot.com/2012/03/relay-error-using-database-mail_3100.html
Friday, March 30, 2012. Relay Error Using Database Mail. Windows Server 2003 SP1. I am getting this error sending a Maintenance Plans report to an email. Recipient. It only happens sending to an external email address. The mail could not be sent to the recipients because of the mail server. Failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception. Message: Cannot send mails to mail server. (Mailbox unavailable. The server. That you could use instead). Windows Server 2003 SP1. Details, if y...
registeringerror3yx.blogspot.com
Registering Error: Relative paths
http://registeringerror3yx.blogspot.com/2012/03/relative-paths.html
Friday, March 30, 2012. For example: Our absolute config path is "D: Program Files Microsoft SQL Server 90 DTS Packages ETLProject ETLBase config Default.dtsconfig" but using: "config/Default.dtsconfig" for xml file value works. However, sometimes we will get an error stating that this file cannot be found, and when we just try to delete (without saving and closing) and immediatelly try to put "config/Default.dtsconfig" again and hit next, we get an error and the path is now:. Relative paths cannot be us...
registeringerror3yx.blogspot.com
Registering Error: Relative path for child packages
http://registeringerror3yx.blogspot.com/2012/03/relative-path-for-child-packages.html
Friday, March 30, 2012. Relative path for child packages. This time I'm trying to run a Master Package from the SQL Server Agent but I can't set relative paths to the connections for all the child packages that the master package contains. It only finishes execution when I set absolute paths for all connections in the connection manager within the SSIS Project. Is there any property in the SQL Server Agent or mayby a workaround to solve this? Use absolute paths. Any reason you need relative paths? You ca...
registeringerror3yx.blogspot.com
Registering Error: Relative paths
http://registeringerror3yx.blogspot.com/2012/03/relative-paths_30.html
Friday, March 30, 2012. For example: Our absolute config path is "D: Program Files Microsoft SQL Server 90 DTS Packages ETLProject ETLBase config Default.dtsconfig" but using: "config/Default.dtsconfig" for xml file value works. However, sometimes we will get an error stating that this file cannot be found, and when we just try to delete (without saving and closing) and immediatelly try to put "config/Default.dtsconfig" again and hit next, we get an error and the path is now:. Relative paths cannot be us...
registeringerror3yx.blogspot.com
Registering Error: Release database lock
http://registeringerror3yx.blogspot.com/2012/03/release-database-lock.html
Friday, March 30, 2012. Actually I'd like to know how I got the lock and then you can tell me how to release it. Here's the problem (this is sql server 2000 with visual studio 2005). If a connection is open from the client it will maintain an S lock on the database. This is true even if the client is doing no work. The purpose of the lock is to prevent certain operations that might change the state of the database (like say dropping it) while there are connections relying on the current state. Release A ...
clearinglogfiles.blogspot.com
Clearing LOG Files: March 2012
http://clearinglogfiles.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. Is there a reliable white paper for clustering sql2k on win2k3. Ive already. Got the OS clustered. TIA, ChrisRChrisR wrote:. Is there a reliable white paper for clustering sql2k on win2k3. Ive. Already got the OS clustered. Some of these might help:. Http:/ www.microsoft.com/resources/.r /. Http:/ support.microsoft.com/defaul.blurb101802.asp. Http:/ msdn.microsoft.com/library/d. Wwwimceda.com This is great information. Does anyone have any updated information on. I suppose we co...
remoteconnectionfailedxk2.blogspot.com
Remote connection failed: Remove hyperlinks when exporting
http://remoteconnectionfailedxk2.blogspot.com/2012/03/remove-hyperlinks-when-exporting.html
Friday, March 30, 2012. Remove hyperlinks when exporting. Is there any way to remove any hyperlinks in a report when they are exported. To another format like Excel. Based on my scope, there is no built in method in Excel rendering extension. To achieve this goal. The possible solution is writing your own Excel. Rendering extension though it is time-consuming. Microsoft offers several ways for you to send comments or suggestions about. You would like to see in future versions of Microsoft products, please.
replicatingmirroreddbss66.blogspot.com
Replicating mirrored dbs: March 2012
http://replicatingmirroreddbss66.blogspot.com/2012_03_01_archive.html
Friday, March 30, 2012. Replication failed after restart. I've 3 pc that have MS SQL 2000 database installed in it and connected to main server through merge replication. At first it run fine all the time. But now, it doesn't. It's happen when the pc have to restart every night. When i come to the office and check resplication status it return failed. I try to manually start synchronize but it failed too. I've to restart the pc all over again untill it ok. It would be helpful to know the error messages.
registeringerror3yx.blogspot.com
Registering Error: Relay Error Using Database Mail
http://registeringerror3yx.blogspot.com/2012/03/relay-error-using-database-mail_30.html
Friday, March 30, 2012. Relay Error Using Database Mail. Windows Server 2003 SP1. I am getting this error sending a Maintenance Plans report to an email. Recipient. It only happens sending to an external email address. The mail could not be sent to the recipients because of the mail server. Failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception. Message: Cannot send mails to mail server. (Mailbox unavailable. The server. That you could use instead). Windows Server 2003 SP1. Details, if y...