|
|
|
|
|
|
| | Total Hits: 282 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| | 
With the release of SQL Server 2005, Microsoft also released SQL Server 2005 Express Edition. This is the free version of the SQL Server engine that existed in prior releases under the MSDE namesake. While there were several great enhancements with SQL Server 2005, one great change was the release of SQL Server Management Studio Express a GUI based management environment for this free version of the database engine. Although having a GUI to manage this version is great, one thing that is still... |
| | Total Hits: 198 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| |
With most, if not all organizations, when executing processes during non business hours it is imperative to know if and when the these processes fail. At a minimum, full backups are typically executed off hours, but many organizations execute resource intensive batch processes which are critical to the core business for the subsequent day. With staff members stretched to meet numerous needs, validating that the jobs have executed successfully on a daily basis can be time consuming, but it is o... |
| | Total Hits: 256 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| |
One of the things you can do with SQL Server 2000 is setup Operators to be notified when there is a job failure or an alert has been triggered that should notify your DBA team. The problem with setting up notifications for jobs is that you need to edit each and every job in order to turn on notifications. If you only have a few jobs this is not that much work, but if you have several jobs and have several servers making this change may take some time. In addition, if you are using Maintenance... |
| | Total Hits: 247 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One problem that people often have is a large number of SQL Agent jobs on their servers and they don't want to remove them because they are not exactly sure what the jobs are used for or why they were created. In most cases a lot of these jobs were created to run one time, but no one took the time to enter a description or better yet delete the job after it was run. So because of this you end up with a lot of extra scheduled jobs that you probably don't really need.... |
| | Total Hits: 206 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
SQL Server Agent is a useful tool to allow you to schedule reoccurring jobs to run on your server. Most of these jobs are usually maintenance type jobs or data loads, but this tool can be used to run any T-SQL code or even execute programs external to SQL Server. In addition to the ability to schedule jobs to run, SQL Server Agent also gives you the ability to see historical run information for the jobs as well as for each step within the jobs. This information is very helpful to have on hand... |
| | Total Hits: 196 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| |
I am making a number of SQL Server security changes at the server and database level all at once, which is a problem in and of itself. I will be changing SQL Server service accounts, removing rights to BUILTIN\Administrators group, limiting specific user rights, moving to group based security, changing SQL Server Agent Job owners, etc. Nevertheless, I want to prevent as many issues as possible with so many simultaneous changes. One issue (of many) that I am concerned about is related to SQL Se... |
| | Total Hits: 220 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
I have a set of SQL Server Jobs (transaction log backups, notification of business rules, etc.) that run every 5 minutes just about 24 hours a day. I seem to lose my SQL Server Job History in a few days and need this type of data to troubleshoot specific situations. It always seems like I lose this SQL Server Job related data when I need it most. I am trying to find the SQL Server Job that someone could have setup to delete from these tables and I only see the Jobs that my team created. I ha... |
| | Total Hits: 227 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
One big issue with scheduled jobs is that they are often batch type jobs that take a significant amount of resources when they run. Another problem is that these jobs usually run during off hours such as nights or weekends, so there is no one to monitor the jobs resource usage. Without being around to monitor the job activity it is difficult to determine whether the jobs are running efficiently or not. Also, when batch jobs are first implemented they are often done with less data, so the resou... |
| | Total Hits: 226 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
As a portion of our backup and recovery process I need to disabled (or enable) all of our SQL Server Agent Jobs depending on the situation and the SQL Server instance. I know I can use the GUI to click through and make the changes, but on a number of our SQL Server instances we have 50+ jobs, so this is a monotonous task. Do you have any scripts to enable or disable all SQL Server Jobs? What about enabling or disabling all SQL Server Jobs by Job name or Job Category name?... |
| | Total Hits: 750 | Today: 0 | | Rating: |
| |
When you run an UPDATE statement, and the connection's isolation level is set to READ UNCOMMITTED, you may receive the following error message:
Error: 644, Severity: 21, State: 6
Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.
RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencin... |
| | Total Hits: 584 | Today: 0 | | Rating: |
| |
If a message fails validation or routing in Microsoft BizTalk Server 2004, the BizTalk Adapter for SQL Server rolls back the transaction, and the failed message is still in the source SQL database. The SQL adapter will pick it up again, and then try to process it. The processing fails again, and the transaction rolls back again. This problem creates a continuous loop.
RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem t... |
| | Total Hits: 1912 | Today: 0 | Author: MSDN | Rating: |
| |
When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message:
System.Data.OleDb.OleDbException: Cannot start more transactions on this session... |
| | Total Hits: 905 | Today: 0 | Author: MSDN | Rating: |
| |
When you execute the SqlTransaction.ExecuteReader function within a repeatable read transaction, the transaction is blocked and then aborted due to a deadlock. When a repeatable read transaction is blocked by a deadlock, SqlTransaction.ExecuteReader may throw incorrect exceptions and, in some situations, may return with an empty reader.... |
| | Total Hits: 1221 | Today: 0 | Author: MSDN | Rating: |
| |
Microsoft SQL Server .NET data provider (SqlClient) is slower than OLE DB .NET data provider (OleDb) when you use connection pooling with integrated security.... |
| | Total Hits: 787 | Today: 0 | Author: MSDN | Rating: |
| |
Microsoft does not support the use of Microsoft Common Language Runtime (included with the .NET Framework 1.1) for any COM Callable Wrapper or Managed Extensions for C++ in either Microsoft SQL Server 7.0 or Microsoft SQL Server 2000. This limitation for support pertains directly to the use of extended stored procedures and the use of OLE Automation for any loading of the libraries that you must load to run in the SQL Server memory space.... |
| | Total Hits: 1750 | Today: 0 | | Rating: |
| |
When Microsoft Data Access Components (MDAC) version 2.6 is installed, each attempt to connect to a SQL Server 7.0 or SQL Server 2000 database using an IP address (rather than the server name) may take longer than anticipated. "In certain reported cases, a "Timeout expired" error is reported to the client application and the connection attempt fails.... |
| | Total Hits: 850 | Today: 0 | | Rating: |
| |
When you install SQL Server 2000 Desktop Engine (MSDE 2.0), the installation may fail and roll back.
NOTE: To determine why the failure occurred, you can generate a verbose log file by using /L*v (e.g., setup.exe /L*v c:\msde_install.log). Look for "Return Value 3" to determine the cause for the failure. In the log file, you may see error messages similar to the following:
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 1010
Action ended 21:39:40: InstallFinalize. Return value 3.
Read More.. |
| | Total Hits: 1278 | Today: 0 | | Rating: |
| |
If you run the Data Transformation Services (DTS) Wizard and you specify a database that contains a period in the name as either the source or destination, the following error message appear:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Unspecified Error
Could not find server ''%1%'' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.... |
| | Total Hits: 1172 | Today: 0 | | Rating: |
| |
When you apply the initial snapshot of a SQL Server 2000 replication publication, the distribution agent (for snapshot or transactional publications) or merge agent (for merge publications) may fail with the following error message:
Category:SQLSERVER
Source: server_name
Number: 208
Message: Invalid object name ''V2''.
Category:AGENT
Source: AGENT
Number: 00000
Message: Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber...Read More.. |
| | Total Hits: 820 | Today: 0 | | Rating: |
| |
When you attach database files, you can specify a different name for the database other than the original name. To specify a different name for the database, use the Attach Database dialog box in the SQL Enterprise Manager and specify the new name in the Attach As option.... |
|
|
|
|
|
|