Viewing 15 posts - 736 through 750 (of 1,157 total)
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 22, 2010 at 10:16 am
You may find DTUTIL useful. Here is an example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 11:32 am
Curious to know, what changed?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 5:57 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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 5:51 am
Please script out the job and paste the content here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 12:50 am
You may find this article useful
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 12:45 am
Is there any other step in the job?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 12:09 am
Viewing 15 posts - 736 through 750 (of 1,157 total)