Viewing 15 posts - 736 through 750 (of 1,161 total)
Navigate to SQL Server Agent --> Alerts. Right Click and select New Alert. In the new alert enter the Error Number and in response select "Notify Operators"
August 23, 2010 at 9:30 am
PAGE HEADER: Page @0x00000001EDAD6000 m_objId (AllocUnitId.idObj) 17836
17836 is the object ID and select object_name(17836) would give you the object name
August 23, 2010 at 9:25 am
Change the "user connections" value in sp_configure
sp_configure 'user connections', Value
Value is the number of users that you want to restrict to
August 23, 2010 at 8:54 am
Agree with Ray. The device was not ready when you received this message. Try running xp_cmdshell 'dir T:\' when you receive this error message. This will confirm if SQL Server...
August 22, 2010 at 9:35 pm
With increase in the database size, all the house-keeping jobs will run longer. You may want to schedule a differential backup on daily basis, since the FULL database backup will...
August 22, 2010 at 9:20 pm
Not sure why you would backup a log shipped database. Insetad you can backup the Primary database in log shipping. If the secondary database is in standby mode, then you...
August 22, 2010 at 9:14 pm
How can I strongly confirm that this is an issue with AD & DNS to Windows team?
Please go through the System Event Log at the time this message appears in...
August 22, 2010 at 10:18 am
* Warning 0x80049304: Data Flow Task 1: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this...
August 22, 2010 at 10:16 am
August 21, 2010 at 11:39 am
Right click on the database and select "Import/Export". In the export window, select Acces (.mdb) as destination
August 21, 2010 at 11:32 am
LutzM (8/21/2010)
It depends.When was the last transaction log backup? Is there any schedule for log backups? If so, how often?
LutzM looks like this is a typo, since the database in...
August 21, 2010 at 5:51 am
Please script out the job and paste the content here
August 21, 2010 at 5:45 am
You can issue ALTER DATABASE... with COLLATE option but that will apply to only new objects. You can try using Collation Changer.
You may find this article useful
August 21, 2010 at 12:50 am
Viewing 15 posts - 736 through 750 (of 1,161 total)