Viewing 15 posts - 2,521 through 2,535 (of 7,506 total)
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
If you have ssms on that server, can you just start it.
Do not connect to the server yet!
so cancel the connect popup.
Then click "new query" and then connect using the...
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 4:59 am
- please provide sql2005 version info ( @@version )
- is this an upgraded db (from 7 or 2000) ?
(and did you perform post migration maintenance ?)
- can you run dbcc...
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 4:51 am
1) why are you using 4-part naming ?
You should just connect to the correct sql-instance and db and use two part naming.
2) did you enable and configure msdtc at the...
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 4:45 am
What's wrong with:
/* day 2 of the current month 00:00:00.000 */
select dateadd(dd,1,dateadd(mm, datediff(mm, 0, getdate()), 0))
/* if you need day 2 12 noon */
select dateadd(hh,36,dateadd(mm, datediff(mm, 0, getdate()), 0))...
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 29, 2010 at 8:38 am
IMO aligned indexes provide both performance and recovery advantages:
- performance: because the are physically split like their corresponding table, so the engine will only use the part needed by the...
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 28, 2010 at 3:32 pm
you can use
return(@yourcode)
to provide an exit code for your sproc.
in your app you can capture this value using the first parameter @return_value.
e.g.
If sqlcmd.Parameters("@RETURN_VALUE").Value.ToString = "0" Then
'.....
...
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 28, 2010 at 3:21 pm
Please use the datetime data type when working with datetime info, so you don't have to bother about formating and have all wonderful datetime related functions available.
Have a look at...
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 28, 2010 at 12:42 pm
As Ray Mond stated, to restore a db, you'll need free space at least equal to the size of the database files at backup time.
If your bak file contains...
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 28, 2010 at 4:32 am
Be sure to start off with all columns you need in your data system.
e.g. maybe it's better to add birth date to your users table and calculate age yourself (inline...
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 27, 2010 at 8:16 am
just the refs of some interesting articles on data analysis (DA) and normalization:
http://www.sqlservercentral.com/blogs/abhijit_desai/archive/2010/09/07/noramlization.aspx
http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/
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 27, 2010 at 8:08 am
Indeed, you'll have to test it anyway 😀
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 26, 2010 at 10:27 am
Viewing 15 posts - 2,521 through 2,535 (of 7,506 total)