Viewing 15 posts - 31 through 45 (of 213 total)
ask the obvious question first you installed the tools
have you tried to reinstall the tools
May 2, 2011 at 2:50 pm
limited by 16 tb filegroups so you would have to divide it up
the row are limited by diskspace
http://msdn.microsoft.com/en-us/library/ms186981.aspx
bigger issue is 8060 by row size
March 3, 2011 at 12:54 pm
http://msdn.microsoft.com/en-us/library/ms143432.aspx
here is limits of sql2008
March 3, 2011 at 12:49 pm
in enterprise manager
right click on sql server group and choose new server registration
you can enter it there
March 3, 2011 at 9:15 am
mail on sql2000 is a external task and sometimes you have to reboot to fix it
before you reboot try this
login to the machine with the username of the outlook client
send...
March 3, 2011 at 8:53 am
use xp_cmdshell to run from dos prompt
March 2, 2011 at 1:21 pm
my company we have a running joke
That people that are good at there jobs tend to find better jobs and leave. So the people that tend to stay...
March 2, 2011 at 9:52 am
wow someone that actually uses navision
my company use 3.61 navision itself is capable of flatlining the server
March 2, 2011 at 9:45 am
depending on your version of sql2008 there is a audit function available to do that
there is also a trigger that will do that too
March 2, 2011 at 9:43 am
A little more information would help
how many columns to compare
1 or 2 just join the to tables using database_name.dbo.table
if it is a lot redgate has a couple of tools...
March 2, 2011 at 9:37 am
in a perfect world
os c drive mirrored
sql d drive mirrored
tempdb e drive mirrored
logs f drive mirrored
data h drive raid 10
the h drive could have file groups for indexes or archives...
March 1, 2011 at 9:22 am
right click on the publication
then choose validate subscription which will show if there is missing data
if there is then choose reinit subcriptions which should fix it
March 1, 2011 at 9:15 am
--here is a query i use in my daily report this may be what your are
--looking for
select null
,sdb.name as sql_dbname
,bs.database_name
,@@servername
,backup_size
,backup_Start_date
,abs(datediff(mi,bs.backup_finish_date,bs.backup_start_date)) as Duration
,bs.name
,user_name
,first_lsn
,last_lsn
,checkpoint_lsn
,collation_name
,abs(datediff(mi,bs.backup_finish_date,getdate())) as age
,BMF.physical_device_name
from master.dbo.sysdatabases sdb with (nolock)
left...
March 1, 2011 at 8:51 am
Viewing 15 posts - 31 through 45 (of 213 total)