Viewing 15 posts - 6,406 through 6,420 (of 9,241 total)
Minnesota - Viking (10/11/2011)
Looking at the object IDs say that they are:DEFAULT_CONSTRAINT and
PRIMARY_KEY_CONSTRAINT
cant i get away by recreating these ?
The default constraint shouldn't be to much of an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 4:59 pm
kevinsql7 (10/10/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 10:46 am
can you provide more details of the move from 2000 to 2008.
Did you run DBCC CHECKDB after the upgrade and did it run successfully?
Did you run DBCC UPDATEUSAGE after the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 10:31 am
the dbcreator server role will grant create drop and restore permissions to any database. Securables at the database level are used to grant the BACKUP permissions or just grant the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 10:13 am
sql server 2008 central management server??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:58 am
do you have antivirus software on the server, if so have you perfomed a system scan?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:57 am
So nothing at all then. No stop errors or application errors, etc.
Almost sounds like some ones pulling the plug out!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:43 am
Perry Whittle (10/11/2011)
have you checked the Windows event logs?
?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 8:20 am
mohammed moinudheen (10/11/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 7:42 am
mohammed moinudheen (10/11/2011)
VMNet1 Public 172.168.10.0 255.255.255.0
VMNet2 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 7:40 am
have you checked the Windows event logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 7:10 am
Dev @ +91 973 913 6683 (10/11/2011)
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well.
Oracle uses it too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 6:27 am
derekr 43208 (10/11/2011)
does running the "add node" install SQL Server.Thanks
That's exactly what it does. As i mentioned previously, ensure the node is added to the Windows cluster first and any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 5:13 am
please post the results of the following query, executed against the primary server
exec sp_help_log_shipping_primary_database @database = 'your primarydb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 4:51 am
mohammed moinudheen (10/11/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 4:25 am
Viewing 15 posts - 6,406 through 6,420 (of 9,241 total)