Viewing 15 posts - 3,796 through 3,810 (of 7,506 total)
Can you add SP1 ? support.microsoft.com/kb/968369
BTW. your version numbers are incorrect !
They don't publish like 10.00.***
but the results I get are like 10.0.*** (SP1)
(with both
SELECT SERVERPROPERTY('productversion')
select @@VERSION
)
And...
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
April 15, 2009 at 5:14 am
You are correct.
Apparently MS is also promoting the .Net infrastructure to achieve optimal integration.
If you are developing a new application it is recommended that you consider using ADO.NET and 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
April 15, 2009 at 3:42 am
Tasumy (4/15/2009)
Ok thanks.In conclusion :
- for managing sqlserver : SMO
- for query : ADO.Net with .NET Framework Data Provider for SQL Server
Use SQLNCLI as much as you...
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
April 15, 2009 at 3:03 am
Technically that isn't a problem.
However, symantically that doesn't make sence to me.
If the BusinessentityID is non nullable, you must first assing the person to an existing business entitiy ?
If BusinessentityID...
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
April 15, 2009 at 2:56 am
XML columns start "in row" ...
My little test: ( never mind the xml content 😉 )
-- my test database
Create database SSC_Test
go
use SSC_Test
go
Create table T_SSC (
...
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
April 15, 2009 at 2:38 am
- Is you sqlserver instance enabled for tcp/ip connections ?
- is there a firewall active ? (you may need to open some ports)
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
April 15, 2009 at 2:13 am
manohar (4/14/2009)
QuestionID BIGINT (Primary key)
QuestionXML NTEXT
Will it be a problem if the datatype is NTEXT...
And also we wil store XML...
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
April 15, 2009 at 2:09 am
SMO stands for SQLServer Management Objects.
Meaning a layer with a number of methods and properties specifically made for managing sqlserver.
You wouldn't want to use that layer for your "normal" querying...
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
April 15, 2009 at 2:01 am
New Commer (4/15/2009)
for a process the time frame is
-StartDate-|-EndDate-|--Starttime-|-EndTime-
-15/04/09-|-16/04/09-|---10:00---|--14:30--
both days the total hrs spent on the process is 9 hrs
Now how to get the result via query...
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
April 15, 2009 at 1:53 am
Typical for a child object is that it cannot exists without a parent object.
So the parent object has to exist first, only then you can use that parent key in...
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
April 15, 2009 at 1:42 am
I downloaded it last Friday (2009-04-10) and just wanted to let you know it the install on my 32-bit Dev Edtn instance went fine.
Initial test seem OK.
We currently don't have...
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
April 14, 2009 at 5:03 am
FYI Lynn also posted a nice overview of common date routines.
http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.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
April 14, 2009 at 1:55 am
If you have the dba edition, you should be able to do far more then reverse engineer and forward engineer.
http://sqlblogcasts.com/blogs/simons/archive/tags/Data+Dude/default.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
April 14, 2009 at 12:27 am
Indeed, must have been a dyping error 😉
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
April 13, 2009 at 11:59 pm
INFORMATION_SCHEMA views also work with pre sql2005 versions.
To only select actual tables you need to add the where clause
Where TABLE_TYPE = 'BASE 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
April 13, 2009 at 1:28 pm
Viewing 15 posts - 3,796 through 3,810 (of 7,506 total)