Viewing 15 posts - 7,576 through 7,590 (of 19,564 total)
Bru Medishetty (12/12/2011)
Have you tried this ? http://technet.microsoft.com/en-us/library/ms190757.aspx
Hey Bru, where have you been? Long time no see!
December 12, 2011 at 7:16 pm
L' Eomot Inversé (12/10/2011)
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
To infinity and...
December 10, 2011 at 9:53 am
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
December 10, 2011 at 9:41 am
You can't restore a 2008 database on SQL 2005.
If you must get the data from one to the other, you will need to import it (dts, ssis, redgate data compare).
December 8, 2011 at 11:20 pm
Surprised to see this one. It was only a few months ago we had one just like it (IIRC).
December 8, 2011 at 11:19 pm
Of course there is also the other way of doing it:
SELECT CONVERT(CHAR(10),GETDATE(),101)
December 8, 2011 at 11:15 pm
Must you have the slashes or would this work?
SELECT CONVERT(DATE,GETDATE())
The output of that is a DATE format rather than a string and it is in format of yyyy-mm-dd
December 8, 2011 at 11:13 pm
You should also watch the SSIS forums here and try to create the solutions for the questions posed. You will need to get some practice with it.
December 8, 2011 at 10:39 pm
Revenant (12/8/2011)
I suppose, Tom, you noticed that the message says 32,766, not 32,767.
Is that because it is counting model in the total? So are there 32766 databases in addition...
December 8, 2011 at 10:35 pm
There are many improvements in SQL 2012. It will be out early 2012.
December 8, 2011 at 10:33 pm
Keep visiting SSC and try to solve some of the problems in the forums.
Reading List:
http://www.amazon.com/Official-Server-Certified-Master-Readiness/lm/R3RB13PQ7D8TKB
The list has some heavy duty stuff in it, but it is well worth learning.
December 8, 2011 at 10:30 pm
GilaMonster (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Yup, very much so. Confirms my opinion that you need to learn nothing to pass that exam....
December 8, 2011 at 12:02 pm
Brandie Tarvin (12/8/2011)
jcrawf02 (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Evil, evil, evil...
Seriously, though, with all the grease in Jason's brain from all those Cheezburgerz,...
December 8, 2011 at 11:59 am
Viewing 15 posts - 7,576 through 7,590 (of 19,564 total)