Wrong. Hmm. Does the "choose 3" mean choose three data types or choose three options from the selection provided? Apparently the former. Don't tick 3 boxes!

robert_verell (4/15/2014)

---

-licensing with SQL 2012 is a pain point here too for physical clusters. Since you've installed SQL Server on the second (and n+ nodes) you have to license...

Markus (4/15/2014)

---

William Soranno (4/15/2014)

---

Bill,

Your senario might work if I had only a few databases to mirror and a few "applications" to change connection strings.

I have 66 databases, and growing, on...

Good tip. I've done this in the past, but not via the service. I've stopped the service, opened a command prompt to the SQL Server program folder, and run the...

"Now, after you take a log backup, could you see a log file bigger than usual?"

No points for me. I perceive there being a difference between a "backup file" and...

Sean Elliott (UK) (11/7/2011)

---

Be aware that using the /z switch (restartable mode) for Robocopy slows it down massively cant tell you how much but something like half speed. You are...

I thought this was a very good question. I must admit i spent time debugging the CASE statement in my head to try and determine what it would return -...

Good question. Couple of issues with the construction of it though:

1. Unless the database context is set to tempdb, or you explicitly reference tempdb..sysobjects, you will get no rows returned.

2....

Like someone else who replied, I shortcircuited the whole thing & counted the delimiters (well, more specifically the spaces between the delimiters), assuming it was an obfuscation question not a...

Good point.

I've never really understood the big fuss over xp_cmdshell being enabled or not. I see how it can be a security risk, and how if SQL security gets...

If you're running it as a SQL Agent job, why not enable xp_cmdshell on the first step, run the utility in the next step then disable xp_cmdshell in the last...

Thanks for the info Hugo. I can now see where it would be useful in a couple of queries I have for some reports - where I was getting...

Good question but just raises another for me - when would you use NULLIF? It may be useful, but I am struggling to see where you would use it....

This seems to work:

DECLARE @sql4 nvarchar(4000)

DECLARE @sql5 nvarchar(4000)

DECLARE @ParmDefinition nvarchar (500)

DECLARE @ParmDefinition2 nvarchar (500)

DECLARE @Prop int

DECLARE @SrvName sysname

SET @SrvName = N'AServer'

SET @sql5 = N'USE [model]; SELECT @PropOUT2 = FILEPROPERTY (''modeldev'',''SpaceUsed'')'

SET...

To start with, here's solution to your undefined variable error:

DECLARE @sql4 nvarchar(4000)

DECLARE @sql5 nvarchar(4000)

DECLARE @ParmDefinition nvarchar (500)

DECLARE @ParmDefinition2 nvarchar (500)

DECLARE @Prop int

SET @sql5 = N'USE [model]; SELECT @PropOUT2 = FILEPROPERTY...