Viewing 15 posts - 2,506 through 2,520 (of 7,502 total)
AFAIK you cannot rename a named instance.
Best is to just install an instance with the new name and port everything from your wrongly named instance to the new one.
After that...
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
January 4, 2011 at 1:05 am
Craig Farrell (1/3/2011)
For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with that issue.
Good...
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
January 3, 2011 at 3:18 pm
Please read my little article called "Scope: The drastic caveat with Logon Triggers. " at http://www.sqlservercentral.com/articles/Administration/64974/
Main message: If you don't need to interrupt the connection at connect time, don't do...
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
January 3, 2011 at 3:12 pm
Please read my little article regarding the use of logon triggers for this purpose !
There may be some considerable down sides !!
Scope: The drastic caveat with Logon Triggers.
http://www.sqlservercentral.com/articles/Administration/64974/
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
January 3, 2011 at 3:08 pm
Hey... you have compare 8 !
Just script your full db.
Edit the sqltext and alter all current filegroup to NEWfilegroup.
Save the file
Use compare8 to generate your migration script comparing the db...
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
January 3, 2011 at 7:08 am
how about using a staging table to prepare all your new data and only at the very last merge the data into your target table ?
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
January 3, 2011 at 6:15 am
maybe even start with this script that can help you with your inventory and scripts.
Just add that part to use the new location.
http://www.sqlservercentral.com/Forums/FindPost368929.aspx
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
January 3, 2011 at 5:49 am
DMV sys.dm_db_index_usage_stats contains the usage info you need.
BIG REMARK from BOL:
The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database...
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
January 3, 2011 at 5:43 am
If that occurs with our backup jobs, it's always an xcopy still trying to copy the file to a safe zone.
We examine why that copy is taking that...
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
January 3, 2011 at 5:32 am
I would first run :
dbcc updateusage ('yourdb') with count_rows
and re-inspect the figures after that.
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
December 31, 2010 at 6:08 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations for the 10K barrier.
Thank you for your support, 10000...
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
December 31, 2010 at 6:01 am
euhm, no ... still on 32 bit xp :blush:
Does msdtc have a 64-bit version too, and is that the version you configured.
Did you configure both versions ?
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
December 30, 2010 at 10:51 am
as you know, the value null is not NULL !
declare @var varchar(128)
set @var = 'NULL'
if @var is null
begin
select @var, ' it is indeed null 1'
end
else
begin
select @var, ' it 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
December 30, 2010 at 6:35 am
It works on my laptops sql2000 (SP4) instance ..
begin tran
SELECT *
FROM [ws20098002\SQL2000PE].pubs.dbo.employee
commit tran
must be a config issue.
Can you doublecheck your dtc configuration and firewall...
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
December 30, 2010 at 6:05 am
is tcp\ip enabled for the 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
December 30, 2010 at 5:49 am
Viewing 15 posts - 2,506 through 2,520 (of 7,502 total)