Viewing 15 posts - 3,601 through 3,615 (of 7,506 total)
(11 row(s) affected) (94 row(s) affected) (8 row(s) affected) (94 row(s) affected)
Msg 7726, Level 16, State 1, Line 38 Partition column 'RgValue' has data type varchar(36) which is different...
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
July 7, 2009 at 7:14 am
Just another thought: You are at the console, or are using a remote desktop solution to run SAC, right ?
We now only have SP3 instances with sql2005 and are not...
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
July 6, 2009 at 7:31 am
Try this:
SET @bcpCommand = 'bcp " select ' + @CTX_TRAILER +' " queryout "'
Why aren't you using the T-SQL "Backup database" command with a SQLCMD ?
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
July 6, 2009 at 5:34 am
Oh, you should !
Why ?
- bugs have been cleaned up
- new features have been added (SSB, logon triggers,..)
- performance optimisations
- SSMS menu items have been shifted around (SP2) :sick:...
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
July 6, 2009 at 4:42 am
What service pack is your sqlinstance on ?
Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS
, Serverproperty( 'Edition' ) as Edition
, Serverproperty( 'InstanceName' ) as InstanceName
, Serverproperty(...
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
July 6, 2009 at 2:54 am
Did you change the SAC connection from localhost to the logical server name of your sqlserver instance ?
e.g. mysqlserver\myinstance you should connect to mysqlserver.
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
July 5, 2009 at 11:49 pm
Why do you want the dependancy of both pk columns?
- an identity column auto increments its value by the increment value. If not tampered with that definition, it will generate...
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
July 5, 2009 at 10:50 am
did you try this in SSMS:
EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
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
July 5, 2009 at 3:04 am
With clustering stuff, many thing must be managed using cluster administrator!
What are you looking for ? (With regards to instance management)
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
July 4, 2009 at 1:59 am
GilaMonster (7/2/2009)
ALZDBA (7/2/2009)
Keep prod and dev data on separate instances !Keep prod and dev on different servers!
Whenever possible indeed !
OP stated
..dev server is gng to decomission soon ..
I...
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
July 3, 2009 at 8:00 am
That is strange indeed.
Double check if you are trying to move the correct db-files. (they can have any name with no "link" to the db itself)
Check if there are still...
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
July 3, 2009 at 12:51 am
I'm totally with Lynn here :w00t:
One other thought of the day:
Whay are you defining the clustering index on a 3-column ix ?
- Are those columns always used (all 3...
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
July 2, 2009 at 12:42 pm
I'm with PaulB's suggestion !
Keep prod and dev data on separate instances !
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
July 2, 2009 at 12:31 pm
it may need some time to actually take it offline.
It will no longer accept new connections/commands for that db.
But it may need to complete the offload, taking some time.
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
July 2, 2009 at 12:28 pm
Maybe just create a view (on the remote server) and query that.
Test it and see what the effects are.
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
July 2, 2009 at 12:45 am
Viewing 15 posts - 3,601 through 3,615 (of 7,506 total)