Viewing 15 posts - 2,866 through 2,880 (of 5,394 total)
Yes, with Visual Studio.
What can I say... good luck! It's not simple at all.
Search "SQL Server 2005 debugging" with Google. Lots of good resources out there.
August 5, 2011 at 1:31 am
Changing the database collation does not change the collation on all the table columns in the database.
You could move the database to a new server with the same collation and...
August 5, 2011 at 1:29 am
You can make the second "rows affected" disappear by adding SET NOCOUNT ON on top of the trigger.
August 5, 2011 at 1:24 am
SQL ORACLE (8/4/2011)
GilaMonster (8/4/2011)
If it's the active node you're rebooting, yes.If so, any running job will be killed?
Sure.
August 5, 2011 at 1:22 am
george sibbald (8/4/2011)
there are scripts out there which only rebuild or reorganise indexes which are actually fragmented and need rebuilding.
August 5, 2011 at 1:21 am
The Dixie Flatline (8/4/2011)
August 5, 2011 at 1:19 am
You can't tell for all cases.
DISTINCT will always perform a SORT right before the SELECT operator in the execution plan.
GROUP BY could end up doing the same thing, but...
August 5, 2011 at 1:14 am
You can use SELECT CONVERT(char(10),GETDATE(), 120), as Sean suggested.
Hope this helps
Gianluca
August 5, 2011 at 1:09 am
Try expliciting the date format in TO_DATE / TO_CHAR.
Maybe you installed the client with different locale settings and the dates don't get parsed/converted correctly.
August 4, 2011 at 10:02 am
You have to set identity_insert(Customers) ON and then insert the values.
Look up SET IDENTITY_INSERT on BOL.
August 4, 2011 at 4:02 am
"i" is a table alias for the INSERTED logical table, a special object available in triggers only. The INSERTED table is a logical representation of the rows modified by the...
August 4, 2011 at 4:00 am
GilaMonster (8/4/2011)
Jeffrey Williams-493691 (8/3/2011)
GilaMonster (8/3/2011)
August 4, 2011 at 3:50 am
I guess you need a splitter function, such as the great one desribed by Jeff Moden in his article here[/url].
If you like his code, please consider voting for him in...
August 4, 2011 at 3:42 am
This is how a clustered service is supposed to be.
It's the cluster service that takes care to start/stop the services. Leave them in "manual" startup.
August 3, 2011 at 3:56 am
Ninja's_RGR'us (8/2/2011)
Huge kitty litter pic goes here
:hehe::hehe::hehe: This reminds me of that movie "Meet the parents"!
That had definitely some ROTFLMAO moments!
August 2, 2011 at 4:17 pm
Viewing 15 posts - 2,866 through 2,880 (of 5,394 total)