Viewing 15 posts - 181 through 195 (of 860 total)
klnsuddu (4/18/2009)
Hi,can we go back to comatibility 80?
Wouldn't be a good idea though. Lot of hassle later on. Its better to stick to 90 and change your code as...
April 18, 2009 at 11:19 am
durga.misra (4/18/2009)
ALTER DATABASE build_system
SET COMPATIBILITY_LEVEL = 90
and
SELECT @@Version return
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 ...
April 18, 2009 at 11:12 am
Sam Shiell (4/18/2009)
we don't need a full-time dba".
OWssssss... You are going to hurt your SQL servers, which is your data, which is your business.:-D
April 18, 2009 at 11:08 am
What SP level you are on? I am sure this is one of the known errors to me that I have encountered, will let you know. Could you please verify...
April 17, 2009 at 6:29 pm
Not aware of what you are asking of. Can you elaborate a bit on this one please? I haven't heard of this before. Well my experience is not much but...
April 17, 2009 at 6:24 pm
Thanks Jack,
I have checked the SQL Server error log. Nothing unusual is recorded in it.
Any jobs that is causing it? Whats happening just before the restart? can you see anything?
April 16, 2009 at 12:12 pm
I agree with Glenn. It really depends on your data growth. I advise you to monitor the rate at which your data grows on each database and sit at a...
April 15, 2009 at 6:32 pm
Hi,
You can set it up against AdventureWorks and also as long as the backup, copy and restore jobs are running fine which means any DML's or DDL's will be copied...
April 15, 2009 at 6:20 pm
And also check the agent jobs that are running prior to the restart if you have any?
April 15, 2009 at 5:39 pm
It is actually, Why you want to limit the number of users anyway? Is there any performance problem on your server, there are different approaches to that but limiting the...
April 15, 2009 at 5:31 pm
Hi,
14420 and 14421 are known errors in Log shipping. Rather than me explaining check this out :
April 15, 2009 at 5:05 pm
loren.saunders (4/15/2009)
getting the same problem from activity manager.running 64 bit, sp 2 installed, msdtc is running already...
any thoughts?
and have you checked the questions we asked? Is your agent running and...
April 15, 2009 at 4:51 pm
manohar (4/14/2009)
I am using that table frequently... Is there anyway to retrieve it quickly.. Will...
April 14, 2009 at 4:39 pm
Is your SQL Agent enabled? and also did you check registry keys, just my two cents.
April 14, 2009 at 4:36 pm
I doubt its something related to network error. As advised could you please post your backup command and also where you are backing up this to ? Local/network/tape?
April 14, 2009 at 4:22 pm
Viewing 15 posts - 181 through 195 (of 860 total)