Viewing 15 posts - 5,566 through 5,580 (of 7,499 total)
keep in mind if you start an instance manualy you need to start:
net start mssql$instancename
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2007 at 2:09 am
- Doublecheck the cluster account
- bring all resources online except for the sql-instance
- Then use 'net start yourinstance', and check the account has login rights (NO sysadmin auth needed !)
-...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2007 at 12:40 am
Normaly if you want separate rows, perform separate selects or take things in your own hands(meaning you perform positioning yourself at front end)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2007 at 12:33 am
Still I'd run SQLUpgradeAdvisor to check the db for possible issues with sql2005 compatibility and try to convice the customer to perform detailed testing with SQL2005 mode !
Keep in mind,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 8, 2007 at 12:11 am
- first of all you have to be sure you've got a valid backup.
maybe even create a new backup using the backup panels.
(tick "validate backup at the end of backup"...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 7, 2007 at 11:53 pm
use a query window in management studio
Check out Restore database in BOL.
restore database yourdatabase
from disk='\\yourfirstserver_UNC\path\backupfile'
-- with move if you want to use new filepaths for mdf and ldf
Your...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 7, 2007 at 8:46 am
how about :
select sum(case when condition1 then 1 else 0 end ) as whatevernameyouwannegiveit
, sum(case when condition2 then 1 else 0 end ) as whatevernameyouwannegiveit_theSecond
from yourobject
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 7, 2007 at 8:43 am
have a look in the cluster log as well as the sqlserver errorlog file.
(C:\WINNT\cluster\cluster.log)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 5, 2007 at 5:05 am
all service accounts that have a relation to your sqlserver instance need at least instance level login auth.
The clusterservice account ('RTDOMAU\svc-proxy-pclust') just needs login rights to the sqlserver instance...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 5, 2007 at 3:55 am
use yourdb;
-- Based on (class=0,object_id=27199197,column_id=0,referenced_major_id=11199140
select object_name( 11199140 ) as ToBeRevised
, object_name( 27199197 ) as ToBeRevisedToo
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 4, 2007 at 2:37 am
Oops :blush: ... this thread is in the SQL2005 forum ...
the methode I explained is not possible with SQL2000.
So you connect to a sqlserver instance and specify a dbname,.....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 3, 2007 at 7:26 am
with SQL2005 Express Edition, you can "in line" attach a mdf-file only on the local instance !
Attach a database file on connect to a local SQL Server Express instance
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 3, 2007 at 7:17 am
TommyB has given you the solution.
Afterward you should restart sqlserver "normal".
On the other hand, I wouldn't advise tempdb to reside on Raid5 ! Best is to put is on a...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 2, 2007 at 8:05 am
just put brackets around the columnname ( look at my previous reply 😉 )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 2, 2007 at 5:25 am
maybe this will get you going ..
SELECT CASE t1.[ORDINAL_POSITION] WHEN 1 THEN 'SELECT ' ELSE ' , ' end
+ ' sum( CASE WHEN ' + t1.[COLUMN_NAME] + ' is...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 2, 2007 at 5:12 am
Viewing 15 posts - 5,566 through 5,580 (of 7,499 total)