Viewing 15 posts - 181 through 195 (of 279 total)
Aren't the Tools (which includes the SSMS) in a different folder on the media than the SQL Engine install folder?
August 7, 2009 at 8:55 am
Yes, that's very odd. I confirmed with the other DBA here and he has also the Pre_release SSMS installed.... He's requesting the media from M$ now..
August 7, 2009 at 7:35 am
Strange thing is that I DID install all from an RTM disk. I have 1 SQL 2008 Server install with the Client tools, and the version for the engine is...
August 6, 2009 at 7:27 pm
We mostly use "SQL_Latin1_General_CP1_CI_AS" but we have some applications that require different. It's really depending on the requirements of the application what you would have....
August 6, 2009 at 6:55 am
.. as John posted, you need to help us also to provide you help.
Read here Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 5, 2009 at 2:13 pm
... you know you can Edit your own posts, right? 😎
August 5, 2009 at 1:05 pm
... I must be missing something, but that query, in T-SQL would look different. First of all, STARTDATE would need to be a valid variable, ie @STARTDATE and then the...
August 4, 2009 at 2:15 pm
sturner (8/4/2009)
64 bit versions of Windows OS can handle 32GB
The amount of memory SQL can use depends on the OS in use.
See this chart for comparison.
And here you can...
August 4, 2009 at 9:27 am
... probably Word97-2003 which share the same format....
August 3, 2009 at 1:38 pm
In theory, the SA account should not be used by any process at all, only for sysadmin purposes..... but, as we all know that is not always the case.
...
July 31, 2009 at 9:07 am
As Gail mentioned above, the table does probably not have enough data to be "considered" for a reindex. I have a few tables with a couple hundred records that don't...
July 27, 2009 at 11:06 am
It could be because the Action is spelled wrong? You have there "autousefix_fix" and it should be "Auto_Fix" ?
July 24, 2009 at 10:03 am
I guess Lowell's post above give's you the best option, using the LEFT and charindex to find the opening < of the html tag
July 22, 2009 at 10:44 am
... I know.. I just wanted it to be as simple as possible for the OP 😉
July 22, 2009 at 10:18 am
Peter D (7/22/2009)
+ 'WHERE kpid = ' 7116
kpid is numeric, so you should change that to:
+ 'WHERE kpid = 7116 '
July 22, 2009 at 9:58 am
Viewing 15 posts - 181 through 195 (of 279 total)