Viewing 15 posts - 61 through 75 (of 515 total)
I re-read your post and found that you are actually looking for detaching and attaching the DB's. Here is the useful link http://msdn.microsoft.com/en-us/library/ms189625.aspx
Hope this helps!
June 10, 2013 at 1:42 am
Take a backup of the database on 2008R2, example shown below:
USE Master
GO
BACKUP DATABASE [SQLTraining]
TO DISK = N'D:\SQLTraining_FullBackup.bak' WITH NOFORMAT, NOINIT,
NAME = N'SQLTraining-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS...
June 10, 2013 at 1:22 am
🙂
Yes correct! I developed this script for my development team, so that they can add/remove articles. And should get some custom error message instead of SQL error message.
June 10, 2013 at 1:15 am
Bhaskar.Shetty (6/10/2013)
Normally on a huge database it is not a good idea to generate the snapshot everytime you an article to it, why not try intilize subscription with backup option.
+1
Normally,...
June 10, 2013 at 12:59 am
This should not happen ideally. Try going over once again and restart. Hopefully it should be created!
June 10, 2013 at 12:43 am
Thomas Abraham (6/8/2013)
Didn't notice the boxes were, well, boxes. So only selected one answer, which appears to be only half the correct answer.
+1
Same here, I also marked the single answer:...
June 9, 2013 at 10:40 pm
Interesting question Mark!
With no idea about the question, I went ahead with a fluke and got that correct 🙂
June 6, 2013 at 10:51 pm
Danny Ocean (6/5/2013)
You write down in question that "Meaning IIF is not a function in SQL SERVER 2012? ". I think it should be "Meaning IIF is not...
June 6, 2013 at 12:25 am
Danny Ocean (6/4/2013)
June 5, 2013 at 12:16 am
An easy one for the day.
SET ANSI_NULLS ON --> enforces SQL-92 standard which says that all equal to and not equal to with NULL evaluates to FALSE.
June 4, 2013 at 11:12 pm
Srinivas.Pendyala (6/3/2013)
what about the 5 th value,why it is not giving output of 5?
Srinivas, The idea here is we are using "TOP(6) WITH TIES", initially "TOP 6" is executed,...
June 3, 2013 at 11:01 pm
Firstly, I would appreciate Ron for coming up with a nice Qotd with an intent to teach grouping sets. Secondly, I do feel, solving this question was rather tricky and...
May 31, 2013 at 6:49 am
L' Eomot Inversé (5/30/2013)
But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial...
May 30, 2013 at 7:49 am
Viewing 15 posts - 61 through 75 (of 515 total)